Data Engineer

Note:

• Local candidates to Dallas, TX only
• Must be available for onsite work

Job Description:

Call notes:

Client is seeking a strong Data Engineer with experience, specifically with recent hands-on experience in mortgage analytics and mortgage loan projects. The role is heavily focused on data engineering, including data transformation, ETL development, data modelling, and ensuring high standards of data quality, consistency, and accuracy.

Key technical requirements include:

• 5+ years of experience as Data Engineer
• 5+ years of experience with Python and SQL
• Strong experience in Excel-to-ETL transformations
• Hands-on expertise in Snowflake
• Experience with data modeling and data transformation
• Open to candidates with any cloud platform experience

Duties:

• Demonstrated experience in solving complex data problems with strong proficiency in:
• 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.

Job Description/Requirements:

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

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

Skills:

• 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
• Product/Program Management experience leading a full lifecycle project including driving requirements, design, build, testing, cutover planning, and go-live execution

Education:

• BA / BS or equivalent Education: BA / BS or equivalent