Change Home Mortgage is a Community Development Financial Institution focused on providing digital-first banking and financial services to underserved communities. They are seeking a Senior Data Engineer to design, develop, and maintain data pipelines and ETL processes, ensuring data quality and governance while collaborating with various stakeholders.
Responsibilities:
- Commitment to and behavior modeling of the Company’s Core Values
- Collaborate with business stakeholders, analysts, and IT teams to gather requirements and deliver scalable data solutions that support strategic business initiatives
- Design, develop, and maintain robust data pipelines and ETL processes to ingest, transform, and load data from multiple internal and external sources
- Develop and optimize SQL Server and Snowflake-based data solutions, including database development, performance tuning, and query optimization
- Build and maintain data models and architectures that support analytics, reporting, and operational use cases
- Implement and manage enterprise data warehouse solutions and cloud-based data platforms
- Ensure data quality, consistency, and integrity through validation, monitoring, and automated checks
- Design and implement master data management (MDM) processes to ensure single sources of truth across systems
- Partner with application teams to integrate data systems and support end-to-end system workflows
- Maintain and enforce data governance standards, security policies, and compliance requirements
- Troubleshoot and resolve data-related issues, ensuring high system availability and performance
- Prepare documentation, data dictionaries, technical specifications, and operational procedures
- Serve as a technical expert and mentor to team members on data engineering best practices and technologies
Requirements:
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience
- 10+ years of experience in data engineering, data warehousing, or database development
- Strong experience with SQL Server, including T-SQL development, indexing, stored procedures, and performance tuning
- Hands-on experience with Snowflake (or other cloud data warehouse platforms), including data modeling and optimization
- Proven expertise in building and managing ETL/ELT pipelines using modern data integration tools
- Strong knowledge of database architecture and design principles, including normalization, dimensional modeling, and scalability
- Experience implementing and maintaining Master Data Management (MDM) solutions and data governance practices
- Understanding data integration patterns, APIs, and real-time/streaming data processing
- Familiarity with cloud environments and distributed data systems
- Knowledge of systems development lifecycle (SDLC) methodologies
- Experience with data quality frameworks, monitoring, and troubleshooting techniques
- Strong analytical, problem-solving, and communication skills
- Ability to work in a fast-paced, collaborative environment and manage multiple priorities