> Markdown version of [/jobs/ext/1368844-data-warehouse-developer](https://www.wearedevelopers.com/jobs/ext/1368844-data-warehouse-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Developer - **Company:** Cornerstone Capital Bank - **Location:** Englewood, CO, United States - **Experience:** Experienced - **Salary:** $95,000.0 - $115,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Application Programming Interfaces (APIs), Data Analysis, User Authentication, Microsoft Azure, Cloud Computing, Code Coverage, Software Quality, Information Systems, Continuous Integration, Data Architecture, Data Definition Language, Data Integration, Extract Transform Load (ETL), Data Manipulation Languages, Data Warehousing, Database Development, Github, JSON, Python (Programming Language), Key Management, OAuth, Query Optimization, Role-Based Access Control, DataOps, SQL Stored Procedures, SQL Databases, Systems Integration, Data Processing, Macros, Data Ingestion, Azure Data Factory, Sql Optimization, Delivery Pipeline, Snowflake, Git, Data Layers, Semi-structured Data, Information Technology, Google Cloud Functions, Operational Systems, Data Delivery, Api Design, Restful APIs, Software Version Control, Data Pipelines, Api Management, Serverless Computing - **Published:** July 21, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17646278?backUrl=%2Fcareer%2F17646278%2FData-Warehouse-Developer-Colorado-Englewood ## About the Role * Bachelor's degree in Computer Science, Information Systems, or related field - or equivalent professional experience. * This position requires 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 * Knowledge of GSE reporting structures (Fannie Mae, Freddie Mac) * Git-based workflow for database development; CI/CD with dbt Cloud * Snowflake RBAC administration and role-based access patterns ## Description 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)., * 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 * Perform Code quality: test coverage, documentation, PR review turnaround ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Keeping applications secure by evolving OAuth 2.0 and OpenID Connect](https://www.wearedevelopers.com/videos/100152-keeping-applications-secure-by-evolving-oauth-2-0-and-openid-connect) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)