Database Developer

Role- Residential Mortgage Database Developer

Location: Chicago or NY

Department: Global Technology - Residential Mortgage Business

Level: Developer

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.

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.

Software Development Lifecycle

•  Work across the full SDLC covering requirements, design, implementation, testing, deployment, and support.
•  Implement unit, integration, and data quality tests; apply Test Driven Development where appropriate.
•  Participate in code reviews and maintain technical documentation such as data models, architecture, and mapping specifications.

Collaboration & Agile Practices

•  Participate in agile ceremonies such as stand-ups, sprint planning, and retrospectives.
•  Partner with engineers, data stewards, and business stakeholders to translate data requirements into technical solutions.
•  Collaborate with cross functional teams during handovers, knowledge transfer, and documentation initiatives.
•  Work independently and engage in business and client interactions as needed, partnering directly with Residential Mortgage business teams.

Tooling & Productivity

•  Use Git and Azure DevOps for version control, work tracking, and CI/CD.
•  Use AI coding tools such as GitHub Copilot and Claude Code to boost productivity while maintaining strong independent coding and debugging skills.

Qualifications

• Bachelor''s degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• 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.