DBT/Snowflake Engineer
Remote · United States
Job Summary
DBT/Snowflake Engineer for offshore data modernization program. Translate Informatica mappings into dbt models on Snowflake; design staging/core/mart layers; develop dbt tests for data quality; implement snapshots, seeds, macros; collaborate with Snowflake developers; ensure functional equivalence between legacy Informatica outputs and new dbt outputs; participate in performance tuning of dbt models and Snowflake queries; integrate dbt with CI/CD pipelines (Azure DevOps, GitHub Actions) for automated runs and validations; contribute to documentation of dbt models, data lineage, and business rules; participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases.
Required Qualifications
- 7+ years of experience in Data Engineering / ETL / DW
- 1–3+ years working with dbt (Core or Cloud)
- Strong SQL skills, especially on Snowflake or another modern cloud DW
- Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures
- Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable
- Understanding of CI/CD practices and integrating dbt into automated pipelines
- Knowledge of data modeling (dimensional models, SCDs, fact/dimension design)
- Experience working in offshore delivery with onshore coordination
- Good communication skills and ability to read/understand existing ETL logic and requirements documentation
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.