Senior Data Engineer: Snowflake & dbt Pipelines

Kapitus; Arlington (VA); On-site; USD 96,000 - 154,000; Full time

Benefits offered by this job

Health Insurance

401K with company match

Paid Time Off

Job summary

Kapitus is looking for a Senior Data Engineer to build production data pipelines on Snowflake and dbt, model layered warehouse structures, and migrate legacy analytics workloads to a modern cloud stack. You will implement data quality as code and contribute to reusable ingestion frameworks, while maintaining performance and cost discipline.

You will collaborate with distributed teams, follow engineering standards, and drive verification and monitoring across the data platform.

Qualifications

• 5+ years of hands-on data engineering experience building production data pipelines and warehouse models.
• Strong Snowflake experience including warehouse and database objects, performance and cost-aware SQL.
• Production dbt experience building and maintaining real dbt projects: layered model organization, incremental models, tests and documentation, macros, and working in a shared multi-developer project with CI.
• Expert SQL skills complex transformations, window functions, performance tuning.
• Solid Python experience for data engineering ingestion utilities, API integrations, automation, and orchestration code.

Responsibilities

• Develop ELT pipelines on Snowflake and dbt for BI, API, ML, and AI consumption.
• Model data within the platform’s layered architecture—staging, conformed core entities, dimensional and product-level models.
• Migrate legacy analytics workflows to the modern stack: analyze, implement, parity, and retirement of legacy assets.
• Implement data quality as code: dbt tests, source freshness checks, reconciliation and validation queries, and pipeline observability.
• Build for reuse: contribute to shared ingestion frameworks and common serving structures.
• Tune performance and manage Snowflake cost; surface risks early and ensure clean handoffs across a distributed team.

Skills

Snowflake

dbt

SQL

Python

Git

CI/CD

Data modeling

Data quality

Tools

dbt

Airflow

Tableau

Job description

Kapitus is looking for a Senior Data Engineer to build production data pipelines on Snowflake and dbt, model layered warehouse structures, and migrate legacy analytics workloads to a modern cloud stack. You will implement data quality as code and contribute to reusable ingestion frameworks, while maintaining performance and cost discipline.

You will collaborate with distributed teams, follow engineering standards, and drive verification and monitoring across the data platform.