Database Developer with Residential Mortgage exposure

Role: Database Developer with Residential Mortgage exposure

Location: Chicago, IL / NYC, NY (In-person interview for the final round)

Duration: Long Term

Interview Mode: Video & F2F must - (In-person interview for the final round)

JD:

Domain: Residential Mortgage

About the Role

We are seeking a motivated Database Developer to join our technology team supporting the Residential Mortgage business. You will work alongside experienced engineers to design, develop, and optimize database solutions across Snowflake, Python, and MySQL, powering data warehouse sourcing, reconciliation, and analytics for Residential Mortgage teams. This is a great opportunity to grow across the full data technology stack at the intersection of finance and technology, with growing exposure to cloud data platforms and generative-AI tools and workflows.

Qualifications

• Proficiency in Python, with experience building data pipelines, automation scripts, and or APIs.
• Strong understanding of SQL and relational database design; hands on experience with Snowflake and MySQL required.
• Familiarity with Snowflake concepts such as virtual warehouses, clustering, Snowpipe, and Snowpark is a plus.
• Familiarity with Git, Azure DevOps, and CI/CD pipelines.
• Experience with, or strong interest in, agile software development practices.
• Interest in applying generative AI tools to database engineering workflows.
• Strong problem-solving skills, attention to detail, and ability to collaborate across teams.
• Interest in financial services or mortgage technology is a plus, though not required.

Key Responsibilities

Data & Infrastructure

· Design, build, and maintain data pipelines using Python, Snowflake, and MySQL to load, store, transform, and export data.

· Support Snowflake infrastructure setup, including virtual warehouse configuration, Snowpipe ingestion, and cost or performance optimization.

· Ensure data integrity, quality, and performance across source systems and downstream consumers.

· Troubleshoot and resolve production issues; improve performance, reliability, and observability of data jobs and pipelines.

Application & Database Development

· Design, develop, and enhance databases and data models supporting Residential Mortgage data sourcing, mastering, and reconciliation.

· Design and optimize SQL schemas, stored procedures, and queries across Snowflake and MySQL environments.