Data Engineer (Fintech)

TL;DR

Data Engineer (SQL/Microsoft Fabric): Designing and maintaining robust data pipelines and transformation logic for the Mortgage Cadence Platform with an accent on ETL optimization, data quality, and dimensional modeling. Focus on building scalable data workflows, implementing incremental loads, and ensuring high data integrity across the platform.

Location: Remote (Must be based in Egypt)

Company

hirify.global provides the Mortgage Cadence Platform for the mortgage and lending industry.

What you will do

• Design and build ETL pipelines using Microsoft Fabric (Dataflow Gen2, Notebooks) and equivalent tools.
• Write optimized SQL queries for data ingestion from various source systems.
• Implement and monitor data quality rules, validation logic, and SLA dashboards.
• Develop dimensional models and aggregation logic aligned with analytics requirements.
• Troubleshoot pipeline failures and coordinate resolution with the Engineering team.
• Maintain detailed documentation for data sources, dictionaries, and transformation specifications.

Requirements

• Advanced SQL proficiency, including query optimization and window functions.
• Experience with Microsoft Fabric (Dataflow Gen2, Notebooks, Lakehouse) or similar ETL tools like dbt, Talend, or Informatica.
• Strong understanding of relational database design and dimensional modeling.
• Proficiency in Power Query / M for complex data shaping and transformation.
• Python scripting skills for data manipulation and pipeline automation.
• Must be located in Egypt.

Nice to have

• Familiarity with the mortgage or lending domain.