Senior Data Engineer: Snowflake EDW & Data Platform Lead

Jobvite, Inc.; United States; On-site; USD 130,000 - 165,000; Full time

Job summary

CMG Financial is moving its reporting and analytics off a legacy servicing data warehouse onto a governed, Snowflake-based EDW. 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.

Qualifications

• 7+ years in data engineering, with 3+ years building production pipelines on a cloud data warehouse, Snowflake preferred.

Responsibilities

• 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 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.

Job description

CMG Financial is moving its reporting and analytics off a legacy servicing data warehouse onto a governed, Snowflake-based EDW. 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.