Senior Data Engineer

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

About The Role

CMG Financial is moving its reporting and analytics off a legacy servicing data warehouse and onto a governed, Snowflake-based Enterprise Data Warehouse (EDW). The EDA team builds and runs that platform: ingestion from our loan-origination and servicing systems, the Raw and Bronze layers, the orchestration that keeps them fresh, and the access, classification and masking controls that let Servicing, Lending, Marketing and Domo users read the data they are entitled to, and nothing more.

Description

Senior Data Engineer

About The Role

CMG Financial is moving its reporting and analytics off a legacy servicing data warehouse and onto a governed, Snowflake-based Enterprise Data Warehouse (EDW). The EDA team builds and runs that platform: ingestion from our loan-origination and servicing systems, the Raw and Bronze layers, the orchestration that keeps them fresh, and the access, classification and masking controls that let Servicing, Lending, Marketing and Domo users read the data they are entitled to, and nothing more.

As a Senior Data Engineer you will be a hands‑on builder on that platform. You will own pipelines and platform components end to end, from source to consumer, and treat access control, data classification and change review as part of the engineering, not an afterthought. You will work alongside the EDA engineers, domain data owners, security and compliance, and the application and DBA teams whose systems feed the warehouse.

What you will do

Ingestion. Build and operate ingestion from on‑premises SQL Server systems (including the BytePro loan‑origination system) and SaaS and vendor sources into Snowflake, using Fivetran, CDC / Change Tracking, Azure Data Factory, and vendor data shares.

Orchestration. Develop and maintain Dagster (Dagster+) assets, schedules, sensors and checks in Python. Migrate remaining GitHub Actions‑run and legacy SSIS jobs onto the orchestration platform.

Transformation. Write and review dbt models, tests, seeds and snapshots for the Raw and Bronze layers, and the contracts that domain teams build on for Silver.

Platform as code. Manage Snowflake as code: databases, roles, grants, warehouses, service users and policies in Pulumi (TypeScript), Azure resources in Terraform, and deploys through GitHub Actions with reviewed, gated promotion across DEV, QA, UAT and PROD.

Security and governance. Implement role‑based access, tag‑based column classification and dynamic masking. Build least‑privilege service accounts with key‑pair authentication, and just‑in‑time elevation for sensitive data under GLBA, FCRA and HMDA obligations, with the approvals recorded and auditable.

Reliability. Build freshness, volume and schema checks, alerting and runbooks. Find and fix silent failures such as stalled pipes, stale grants and untagged objects before a consumer does.

Engineering practice. Contribute to specs and architecture decision records (ADRs), write clear PRs, and give and take rigorous code review. Measure before asserting, and leave a verifiable trail.

Collaboration. Partner with Servicing, Lending and Marketing data owners and with Domo and BI developers during the SDW‑to-EDW migration, including parallel‑run reconciliation against the legacy system.

Mentoring. Mentor engineers on the team and raise the bar on testing, automation and documentation.

What you bring

• 7+ years in data engineering, with 3+ years building production pipelines on a cloud data warehouse, Snowflake preferred.
• Expert SQL, and strong Python for pipeline and platform code, with tests.
• Hands‑on dbt experience in production: modeling, testing, CI, and environments.
• Experience with a modern orchestrator (Dagster, Airflow or Prefect), and with managed ingestion or CDC (Fivetran or similar).
• Infrastructure‑as‑code experience (Pulumi, Terraform or similar) and CI/CD with GitHub Actions or Azure DevOps.
• Snowflake security depth: RBAC design, masking and row‑access policies, tags, service authentication and cost‑aware warehouse management.
• Working knowledge of SQL Server as a source system: CDC and Change Tracking, and reading execution plans well enough to work productively with a DBA team.
• Experience handling regulated or sensitive data (PII, financial data) with auditable controls.
• Clear written communication: you can write a spec, a PR description and an incident note.

Nice to have

• Mortgage, lending or loan‑servicing domain experience (origination, servicing, investor reporting).
• Azure: Data Factory, ADLS, Key Vault, Entra ID groups and SCIM provisioning.
• Snowflake Iceberg / catalog‑linked tables, secure data sharing and reader accounts.
• Data catalog and lineage tooling (OpenMetadata / DataHub or similar).
• Migrating SSIS packages or legacy ETL onto modern tooling.
• Domo or other BI platforms as a downstream consumer of the warehouse.
• Experience using AI coding assistants responsibly in a reviewed engineering workflow.
• Streaming and event‑driven data: Kafka (or a similar platform such as Azure Event Hubs), change‑data streams, and Snowflake streaming ingestion (Snowpipe Streaming) alongside batch pipelines.
• Durable workflow orchestration and container platforms: Temporal (CMG is adopting it, and this role will integrate the data platform with it) and Kubernetes for running containerized services.
• Data modeling experience with one or more established approaches: Inmon (enterprise, normalized), Kimball (dimensional), Medallion (Bronze / Silver / Gold) or Data Vault 2.0, and the judgment to pick the right one for each layer.
• Experience with an AI‑Driven Development Lifecycle (AI‑DLC): AI agents working inside a structured, human‑governed lifecycle of intent, requirements, design, implementation, testing and deployment, with each step checked and approved by an engineer before it lands.

How we work

Changes land through reviewed pull requests, and production changes go through approval gates. Governance rules are written down as specs and ADRs and enforced in code and CI, so whether someone can read a column is decided by a reviewed rule, not a one‑off grant. We value measuring over assuming, fixing root causes over workarounds, and owning a problem until it is actually closed .

SUPERVISORY RESPONSIBILITIES: Direct Reports: N/A

PHYSICAL And ENVIRONMENTAL CONDITIONS

This role operates in an ADA compliant office environment, utilizing typical office equipment and tasks including computer work. The position may involve partial stationary positions and moving throughout the day. Flexibility to work overtime to meet project deadlines is required.

Compensation

Compensation Information – The salary range for this role is $130,000 to $165,000 annually. Actual compensation depends on experience, technical skills, industry background and other job‑related factors including location and education. Eligible employees also receive a comprehensive benefits package.

CMG Financial is an equal opportunity employer and does not unlawfully discriminate in employment decisions. CMG will consider all qualified applicants without regard to race, religion, national origin, sex, age, veteran status, disability, familial status, marital status, actual or perceived sexual orientation, or actual or perceived gender identity. Applicants requiring reasonable accommodation to the application and/or interview process should notify a representative of CMG Financial or reach out to [email protected] .

CMG MORTGAGE, INC. NMLS #1820 If you are a recruiter or placement agency, please do not submit resumes to any person or email address at CMG Financial prior to having a signed agreement . CMG Financial is not liable for and will not pay placement fees for candidates submitted by any agency other than its approved recruitment partners. Furthermore, any resumes sent to us without an agreement in place will be considered your company’s gift to CMG Financial and may be forwarded to our recruiters for their attention.