AdTechTalent
Data Science18 days agoRemote

StackAdapt

Senior Database Administrator

ETLSnowflakeData WarehouseAWSPythonSQLSparkJavaData EngineeringData OperationsApache AirflowData PipelineCloudDatabase AdministrationMentorship

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 expertise, strong problem-solving, data warehousing architecture knowledge, and experience with 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 candidates, 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 automated data ingestion and transformation pipelines
  • 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, troubleshooting, and resolving production issues promptly
  • Act as a player-coach for 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 professional experience as a Snowflake Database Administrator (DBA) 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 in a scaled environment
  • Strong problem-solving skills with a focus on root cause analysis and prevention
  • Understanding of data warehousing architecture fundamentals (Kimball vs. Inmon, Medallion Architecture, 3NF, dimensional models, SCDs, etc.)
  • Experience orchestrating data operations using tools such as Apache Airflow, Cron, Astronomer
  • Ability to lead and mentor junior and intermediate data engineers and ETL developers

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.