AdTechTalent
Data Science12 days agoRemote

StackAdapt

Snowflake Database Administrator

ETLSnowflakeAWSData WarehouseData LakePythonSQLSparkJavaApache AirflowData EngineeringDatabase AdministrationCloudData OperationsMentorship

Key details

Salary

CA$100K – CA$125K

Employment type

Full-time

Seniority

Senior

Years experience

5-10

Location

Canada; United States

Full job description

Responsible for operational database administration, data engineering, and data operations within the Data Lake and Enterprise Data Warehouse (Snowflake) ecosystem. Lead daily database administration, design and develop ETL pipelines and data artifacts, integrate data from multiple sources, and provide operational support. Collaborate with architects and mentor junior staff. Requires deep ETL development experience using SQL, Python, Spark, Java, and ETL tools, strong Snowflake DBA experience, AWS cloud expertise, and knowledge of data warehousing architectures and orchestration tools.

What you'll do

  • Lead daily database administration ensuring data environment health and reliability
  • Partner 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
  • Analyze and produce artifacts such as Source-to-Target Mapping documents
  • Build pipelines integrating data from RDBMS, APIs, JSON, flat files
  • Define 'Source of Truth' using Python and ETL tools to clean, integrate, and transform data
  • Provide operational support by monitoring alerts and troubleshooting production issues
  • Act as 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 working with Snowflake as a Database Administrator (DBA)
  • Clear understanding of Snowflake’s Access Control framework
  • Experience with Cloud-hosted solutions, especially AWS (Secrets Manager, KMS, S3, EC2, Linux, Cross-Account Access)
  • 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 data models, reference data models, dimensional models, conformed dimensions, SCDs)
  • Experience orchestrating data operations via 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 packages including birthdays offAccess to a comprehensive mental health care programHealth benefits from day one of employmentWork 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.