Data Warehouse Developer

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

Englewood, CO 200
10800 E Geddes Ave
Suite 200
Englewood, CO 80112, USA

Who we are

Cornerstone Servicing, a division of Cornerstone Capital Bank, is a best‑in‑class mortgage servicer with a reputation for amazing service, customer satisfaction, employee retention and happiness. We employ people who are passionately committed to Cornerstone’s Mission, Vision & Core Convictions.

We honor God by using our talents to make a positive difference in the lives of our Team Members, Clients, Shareholders, Communities, and the People who provide services to us.

Who we are looking for

Design, build, and optimize database objects and data pipelines within a Snowflake platform supporting mortgage loan servicing operations. Develop and maintain dbt transformations that move data through a medallion architecture (Raw → Staging → Quarantine → Production → Analytics), build API‑serving data layers, and ensure performant, reliable data delivery across a large‑scale environment (100B+ rows, 10,000+ tables).

• Location: Onsite in Englewood, CO
• Compensation: $95-115k

Key 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 promotion to 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 and event‑driven data operations
• Implement loan boarding and MERS registration data pipelines
• Optimize query performance across multicluster warehouses; tune clustering keys, materialized views, and partition strategies
• 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 on‑time data availability
• Evaluate query performance improvements and warehouse credit efficiency
• Evaluate API response time and availability SLAs
• Evaluate data quality pass‑through accuracy

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
• Experience with Azure Function Apps for event‑driven and API‑based data integrations
• Familiarity with RESTful API design, development, and consumption (JSON payloads, authentication, error handling)
• Understanding of medallion/layered data architecture patterns
• Understanding of mortgage servicing data: loan‑level records, payment transactions, escrow, collections, delinquency, credit reporting
• Experience with Snowflake features: multi‑cluster warehouses, external stages, storage integrations, notification integrations (Event Grid, Storage Queue)
• Python for Azure Functions, data processing, and pipeline automation
• Experience with Snowflake external functions and API integrations
• Knowledge of OAuth, API key management, and secure service‑to‑service communication
• Git‑based workflow for database development; CI/CD with dbt Cloud
• Snowflake RBAC administration and role‑based access patterns

Benefits

Competitive salary, Medical, Dental, Vision, Accidental Death, Long‑Term Disability, Short‑Term Disability, FSA, HSA, 401K, Basic Life, Voluntary Life, Paid Parental Leave benefits, and a performance‑based bonus based on position and department.

Next Steps

If Cornerstone sounds like the place for you and you have the qualifications, drive, and passion to match, we invite you to join our winning team. Once you’re part of our team, we’ll continue to invest in you as a valuable asset to our company.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.