Snowflake Database Administrator
New
S
StackAdaptAdTech
Location: Canada; United StatesFull-TimeMiddle
Salary100,000 - 125,000 CAD per year
Apply NowOpens the employer's application page
Job Details
- Required Skills
- AWSPythonSQLApache AirflowETLSnowflakeData engineeringSpark
Requirements
- Deep experience in ETL design and development (SQL, Python, Spark, Java).
- Experience with ETL tools such as Coalesce, Informatica, DataStage, or Talend.
- Extensive hands-on professional experience with Snowflake as a DBA.
- Clear understanding of Snowflake Access Control framework.
- Comfortable with AWS cloud-hosted solutions (Secrets Manager, KMS, S3, EC2, Linux).
- Understanding of data warehousing architecture fundamentals (Kimball, Inmon, Medallion, 3NF).
- Experience with data orchestration tools like Apache Airflow, Cron, or Astronomer.
- Experience with Data Quality and Metadata Management tools.
Responsibilities
- Lead daily database administration to maintain health and reliability.
- Partner with Staff EDW Architect to design high-quality data artifacts.
- Develop reusable ETL solutions to meet business needs.
- Design end-to-end automated ingestion and transformation pipelines.
- Analyze and produce Source-to-Target Mapping documents.
- Build pipelines integrating RDBMS, APIs, JSON, and flat files.
- Define source of truth using Python and ETL software.
- Monitor alerts and troubleshoot production data pipeline issues.
- Act as a player-coach for junior and intermediate data engineers.
View Full Description & ApplyYou'll be redirected to the employer's site
