Onsite Snowflake Data Engineer | dbt & Azure Pipelines

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

Job summary

Cornerstone Capital Bank is seeking a senior data engineer to design, build, and optimize Snowflake data pipelines supporting mortgage loan servicing. You will develop dbt models, optimize SQL objects, and implement ingestion patterns from Azure storage using ADF/Snowpipe, while ensuring data quality and reliable production delivery.

The role emphasizes real-time data operations with Azure Functions, API integrations, and RBAC governance across a large-scale data environment.

Qualifications

• Bachelor’s degree in CS or related field, or equivalent 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).
• Experience with Azure Data Factory for orchestration and data movement.
• Experience with Azure Function Apps for event-driven data integrations.
• Familiarity with RESTful API design and JSON payloads.
• Understanding of medallion/layered data architecture and mortgage servicing data.

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 data operations.
• Implement loan boarding and MERS data pipelines.
• Optimize query performance across multicluster warehouses; tune clustering keys and materialized views.
• Develop audit trails and historical tracking patterns.
• Manage schema migrations, version control via GitHub, and CI/CD through dbt Cloud.

Skills

Snowflake

dbt

SQL

Azure Data Factory

Azure Functions

API integrations

Python

GitHub

CI/CD

RBAC

Education

Bachelor’s degree in Computer Science or related field

Tools

dbt

GitHub

dbt Cloud

Job description

Cornerstone Capital Bank is seeking a senior data engineer to design, build, and optimize Snowflake data pipelines supporting mortgage loan servicing. You will develop dbt models, optimize SQL objects, and implement ingestion patterns from Azure storage using ADF/Snowpipe, while ensuring data quality and reliable production delivery.

The role emphasizes real-time data operations with Azure Functions, API integrations, and RBAC governance across a large-scale data environment.