Data Warehouse Developer

Who We Are

Cornestone Servicing, a division of Cornerstone Capital Bank, is a best-in-class mortgage servicer known for its commitment to exceptional service, high client satisfaction, strong employee retention, and happiness. We hire individuals who are deeply committed to Cornerstone’s Mission, Vision, and Core Convictions. We honor God by using our talents to make a positive impact on our Team Members, Clients, Shareholders, Communities, and those who serve us.

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
• Build and maintain API-serving data layers delivering data to operational systems
• 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
• 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
• Ensure code quality: test coverage, documentation, PR review turnaround

What You’ll Need To Be Successful

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

What We Offer

• Competitive salary
• Medical, Dental, Vision insurance
• Accidental Death, Long-Term Disability, Short-Term Disability, FSA, HSA, 401K
• Paid Parental Leave
• Performance-based bonus