Snowflake Data Engineer: dbt Pipelines & Mortgage Analytics

Cornerstone Capital; Englewood (CO); On-site; USD 95,000 - 115,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401K

Paid Parental Leave

Performance bonus

Job summary

Cornerstone Capital Bank is seeking a data engineer to design, build, and optimize Snowflake-based data pipelines for mortgage servicing analytics. You will develop and maintain dbt transformations across Raw → Staging → Production, build API-serving data layers, and ensure reliable data delivery in a large-scale environment (100B+ rows).

Onsite in Englewood, CO, the role offers a competitive salary and a comprehensive benefits package.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field — or equivalent professional experience.
• 3+ years developing in Snowflake (DDL, DML, stored procedures, tasks, streams, UDFs).
• Strong dbt experience (models, tests, incremental strategies, macros, packages)
• Advanced SQL: window functions, CTEs, semi-structured data (VARIANT/JSON), query optimization
• Experience with Azure Data Factory for orchestration and data movement

Responsibilities

• Develop and maintain dbt models powering production and analytics layers
• Build and optimize SQL objects: tables, views, stored procedures, tasks, and streams
• Design and implement data ingestion patterns from Azure storage via ADF pipelines and Snowpipe
• Develop data quality and quarantine logic to validate and gate data before production
• Build and maintain API-serving schemas delivering data to operational systems
• Develop and support Azure Function Apps that interact with Snowflake for real-time operations
• Implement loan boarding and MERS registrations data pipelines
• Optimize query performance across multicluster warehouses and tuning
• Develop audit trails and historical tracking patterns
• Support extract pipelines delivering data to investors, regulators, and partners via Azure storage
• Manage schema migrations, version control via GitHub, and CI/CD through dbt Cloud
• Track and report success metrics
• Evaluate pipeline reliability and data availability
• Evaluate query performance improvements and warehouse credit efficiency

Skills

SQL

Data modeling

Team collaboration

Education

Bachelor’s degree in CS/IS or related field

Tools

Snowflake

dbt

Azure Data Factory

Azure Functions

Snowpipe

GitHub

dbt Cloud

Python

Job description

Cornerstone Capital Bank is seeking a data engineer to design, build, and optimize Snowflake-based data pipelines for mortgage servicing analytics. You will develop and maintain dbt transformations across Raw → Staging → Production, build API-serving data layers, and ensure reliable data delivery in a large-scale environment (100B+ rows).

Onsite in Englewood, CO, the role offers a competitive salary and a comprehensive benefits package.