Data Engineer

Hornet Staffing, Inc, a GEE Group company; Dallas (TX); On-site; USD 96,000 - 152,000; Full time

Job summary

Hornet Staffing, Inc., a GEE Group company, is seeking a data engineering professional for a 6-month contract to support a large-scale system migration focused on mortgage analytics. The role emphasizes building cloud-native data pipelines and data lake architectures (Snowflake) and managing ETL/ELT workflows across structured and unstructured data sources.

The candidate will also contribute to project coordination, data validation, and stakeholder alignment, ensuring data integrity and

Qualifications

• 5+ years of advanced SQL experience with complex queries and data manipulation.
• 5+ years of professional Python development for processing large datasets.
• Experience in building and maintaining data pipelines and data engineering.
• Industry expertise in ABF and mortgage servicing workflows and analytics.
• Strong communication and change-management abilities to align stakeholders.
• Experience leading full lifecycle projects (requirements, design, build, test, cutover, go-live).

Responsibilities

• Design, build, and maintain cloud-native data pipelines and datalake architectures (Snowflake) for ABF analytics.
• Develop and manage scalable ETL/ELT workflows for structured and unstructured data.
• Support analytics and reporting: data reconciliation, validation, and data integrity checks.
• Assist in migration from legacy systems to a modern data platform with mapping and transformation logic.
• Contribute to light project management: break work into Epics/User Stories (Jira), plan timelines, and coordinate across teams.
• Support testing, cutover planning, and go-live readiness.

Skills

Advanced SQL

Python development

Data engineering

Mortgage analytics

Stakeholder communication

Product management

Education

BA / BS or equivalent

Tools

Snowflake

Polars

Pandas

Job description

Duration: 6 months (Possibility of extension/conversion)

Only US Citizen or Green Card holder who can work on W2 can apply

Recent Mortgage or loan analytics experience is must

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

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

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

Notes:

(very little Project Management if any)-clear demonstrated Mortgage loan analytics exp Python, SQL-Snowflake a must.

Take several years of data and look at process flow confirm and tie out at end of system Dive into data models and technologies how data is being transformed and all info flowing and ties out accurately

More focused on is the “data is right” more than data migration skills