Tech Stack
AirflowAWSAzureCloudGoogle Cloud PlatformMatillionPythonSQLTerraform
About the role
- Define and evolve Snowflake platform architecture, standards, and best practices.
- Translate business goals into a pragmatic technical roadmap and delivery plan.
- Lead and mentor data engineers; establish quality bars, review code, and guide execution.
- Manage delivery using Agile rituals; align priorities across data, analytics/BI, and application teams.
- Design, build, and optimize ELT pipelines on Snowflake with an ELT-first approach (dbt preferred).
- Implement modern data ingestion using tools such as Fivetran, ADF, Glue, or Matillion.
- Set up orchestration and CI/CD for data using Airflow or Dagster and Git-based pipelines.
- Ensure data quality, observability, monitoring, alerting, documentation, and runbooks.
- Apply performance tuning and cost optimization in Snowflake, including query profiling and warehouse sizing.
- Implement security and governance in Snowflake (RBAC, masking, row access policies, auditing, data sharing).
- Facilitate discovery with stakeholders, clarify requirements, and communicate trade-offs and recommendations.
Requirements
- Deep hands-on Snowflake experience: warehouses, databases/schemas, stages, file formats, external tables, Snowpipe, Streams and Tasks, Time Travel/Fail-safe, query performance, micro-partitions, clustering, and cost management.
- Strong SQL and Python for data engineering use cases.
- ELT-first development with dbt or an equivalent modeling/testing/documentation framework.
- Experience with modern ingestion and orchestration (Fivetran, ADF, Glue, Matillion, Airflow, or Dagster).
- Cloud experience (AWS preferred; Azure or GCP considered), including storage, IAM, networking basics, and secrets management.
- CI/CD for data with Git-based workflows and environment promotion.
- Familiarity with Infrastructure as Code (e.g., Terraform Snowflake provider).
- Solid understanding of dimensional modeling and data quality practices.
- Health insurance
- Flexible work arrangements
- Professional development opportunities
- Paid time off
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SnowflakeSQLPythonELTdbtFivetranADFGlueAirflowTerraform
Soft skills
leadershipmentoringcommunicationcollaborationproblem-solving