Data Engineer- Mortgage Analytics

W2 ONLY - we are not able to provide sponsorship now or in the future MUST be based in Dallas - This role is 100% onsite Job Description • Support the technical execution of a large-scale system migration. This role will focus on the data engineering side to build out infrastructure and support other efforts as needed such as project coordination, data validation, and stakeholder alignment • Required experience working with mortgage analytics platforms and large-scale mortgage loan datasets, including servicing, investor reporting, remittance, and portfolio performance data Key Responsibilities: • Design, build, and maintain cloud-native data pipelines and datalake architectures (Snowflake) to support ABF investment and portfolio analytics • Develop and manage scalable ETL/ELT workflows to ingest, transform, and curate data from structured and unstructured sources • Support analytics and reporting use cases, including data reconciliation, validation, and financial data integrity checks • Support the migration from legacy systems to a modern data platform, including data mapping, transformation logic, and architecture alignment • Contribute to light project management activities, including: • Breaking down work into Epics/User Stories (Jira) • Supporting project planning, timelines, and coordination across teams • Assisting with testing, cutover planning, and go-live readiness Skills • Required experience working with mortgage analytics platforms and large-scale mortgage loan datasets, including servicing, investor reporting, remittance, and portfolio performance data • 5+ years of advanced SQL experience with common table expressions (CTEs), complex window functions, conditional logic, joins, aggregations etc. • Data cleaning/de-duplication/reconciliation etc, • 5+ years of professional python development to process complex dataset efficiently, process automations using Polars, Pandas or equivalent. • Demonstrated experience in data engineering, including building, maintaining, and optimizing data pipelines and workflow • Industry expertise in ABF and mortgage servicing – settlements, remittances/cash consolidation, servicing workflows, etc. • Good communication skills and change management abilities – align stakeholders and ensure operational readiness of new platform Education • BA / BS or equivalent About SSi: With over 26 years of industry experience, SSi People has built its reputation and expertise on putting people first. Everything we do works toward delivering an exceptional experience for our consultants, our clients, and our internal team. Through a genuine commitment to people in everything we do, we have developed refined processes and a stellar internal team to deliver talent quickly. More importantly, we focus on building long-term relationships, not transactions. Putting people first is just what we do well. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from SSi People and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: SSi People Privacy Policy.