AdTechTalent
Data Science18 days agoRemote

StackAdapt

Senior Big Data Engineer & Database Administrator

ETLSnowflakeAWSPythonSQLData EngineeringData WarehouseApache AirflowDataOpsData LakeCloudData PipelinesDatabase Administration

Key details

Salary

CA$100K – CA$125K

Employment type

Full-time

Seniority

Senior

Years experience

5-10

Location

Canada; United States

Full job description

The role involves operational database administration, data engineering, and data operations within the Data Lake and Enterprise Data Warehouse (Snowflake) ecosystem. Responsibilities include leading daily database administration, collaborating on data artifact design, developing reusable ETL solutions, designing automated data pipelines, producing mapping documents, integrating data from various sources, defining a reliable data source, providing operational support, and mentoring junior staff. Required skills include ETL design and development using SQL, Python, Spark, Java, ETL tools (Coalesce, Informatica, DataStage, Talend), Snowflake DBA experience, AWS cloud services, strong problem-solving, data warehousing architecture knowledge, and data orchestration tools like Apache Airflow. The position is full-time, senior level, remote, with a salary range of $100,000 to $125,000 CAD for Ontario, Canada, and benefits including competitive salary, retirement plans, paid time off, health benefits, work from home reimbursements, training, and a supportive culture.

What you'll do

  • Lead daily database administration to maintain a healthy and reliable data environment
  • Collaborate with Staff EDW Architect to design high-quality data artifacts following best practices
  • Develop reusable ETL solutions aligned with business needs
  • Design end-to-end data pipelines with automated ingestion and transformation
  • Produce artifacts such as Source-to-Target Mapping documents
  • Integrate data from multiple sources including RDBMS, APIs, JSON, and flat files
  • Define and maintain the 'Source of Truth' using Python and ETL tools
  • Provide operational support by monitoring alerts and troubleshooting production issues
  • Mentor junior and intermediate data engineers and ETL developers

Requirements

  • Deep experience performing ETL design and development via custom coding (SQL, Python, Spark, Java, etc.) and ETL tools (Coalesce, Informatica, DataStage, Talend)
  • Extensive hands-on experience as a Snowflake Database Administrator with understanding of Snowflake’s Access Control framework
  • Experience with cloud-hosted solutions, especially AWS including Secrets Manager, KMS, S3, EC2, Linux, Cross-Account Access
  • Strong problem-solving skills with a drive to understand and prevent errors
  • Understanding of data warehousing architecture fundamentals (Kimball vs. Inmon, Medallion Architecture, 3NF, dimensional models, SCDs, etc.)
  • Experience orchestrating data operations using Apache Airflow, Cron, Astronomer or similar tools

Tech stack

SQLPythonSparkJavaCoalesceInformaticaDataStageTalendSnowflakeAWSSecrets ManagerKMSS3EC2LinuxApache AirflowCronAstronomer

Benefits

Highly competitive salaryRetirement/401K/Pension savings globallyCompetitive paid time off including birthdays offComprehensive mental health care programHealth benefits from day oneWork from home reimbursementsOptional global WeWork membership (London and Toronto hubs)Robust training and onboarding programSupport for personal development initiatives (conferences, courses, books)Access to StackAdapt programmatic courses and certificationsParental leave programFriendly, welcoming, and supportive cultureSocial and team events

Apply now

This MVP uses a placeholder application flow. In production, this section can connect to an external apply URL or a native application form.

Continue to applicationBrowse more jobs

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.