Senior Data Engineer, Snowflake EDW Platform

CMG Financial; United States; On-site; USD 130,000 - 165,000; Full time

Benefits offered by this job

Comprehensive benefits package

Equal opportunity employer

Job summary

CMG Financial seeks a Senior Data Engineer to own end-to-end data pipelines on a Snowflake-based EDW. You will build ingestion from on‑prem and SaaS sources, develop Dagster assets, and implement robust data governance and security controls.

You will collaborate with domain data owners, security, and BI teams to ensure reliable, auditable data flows while advancing automation and CI/CD practices across DEV, QA, UAT and PROD environments.

Qualifications

• 7+ years in data engineering
• 3+ years building production pipelines on a cloud data warehouse
• Expert SQL and strong Python for pipeline and platform code, with tests
• dbt production experience: modeling, testing, CI
• Experience with orchestrators (Dagster, Airflow, Prefect)
• Infrastructure-as-code (Pulumi, Terraform) and CI/CD with GitHub Actions or Azure DevOps
• Snowflake security depth: RBAC, masking and row-access policies
• SQL Server CDC and Change Tracking knowledge with DBA collaboration
• Experience handling regulated or sensitive data with auditable controls
• Clear written communication: specs, PR descriptions, incident notes

Responsibilities

• Ingestion from on-prem SQL Server and SaaS sources into Snowflake using Fivetran, CDC, Azure Data Factory
• Develop and maintain Dagster assets, schedules, sensors and checks; migrate SSIS jobs
• Write and review dbt models, tests, seeds and snapshots for Raw/Bronze/Silver layers
• Manage Snowflake as code via Pulumi/Terraform; deploy through GitHub Actions across DEV/QA/UAT/PROD
• Implement role-based access, data masking and just-in-time elevation for GLBA/FCRA/HMDA obligations
• Build freshness, volume and schema checks, runbooks and alerting
• Contribute to specs, ADRs, and rigorous code reviews; measure before asserting
• Collaborate with Servicing/Lending/Marketing data owners and BI teams during migration
• Mentor engineers and raise the bar on testing, automation and documentation

Skills

Data engineering

SQL

Python

dbt

Dagster

CI/CD

Snowflake

Security governance

Regulated data

Mentoring

Tools

Dagster

Fivetran

Azure Data Factory

Terraform

Pulumi

Snowflake

GitHub Actions

SSIS

Job description

CMG Financial seeks a Senior Data Engineer to own end-to-end data pipelines on a Snowflake-based EDW. You will build ingestion from on‑prem and SaaS sources, develop Dagster assets, and implement robust data governance and security controls.

You will collaborate with domain data owners, security, and BI teams to ensure reliable, auditable data flows while advancing automation and CI/CD practices across DEV, QA, UAT and PROD environments.