Data Engineer
Remote · Egypt
Job Summary
Data Engineer role within Mortgage Cadence Platform focusing on designing, building, and maintaining robust data pipelines and transformation logic to power analytics, compliance, and operational reporting. Core duties include creating ETL pipelines with Microsoft Fabric, writing optimized SQL for data ingestion, applying data quality checks, implementing incremental loads, developing dimensional models, and ensuring data governance and documentation. Responsibilities also cover validating pipeline outputs against business logic, maintaining data quality dashboards, supporting UAT for new data sources, troubleshooting performance issues, and collaborating with the Lead to refine semantic models and metrics. Proficiency across SQL, ETL tools, Python, Power Query, and Git is required, with Mortgage/lending domain familiarity preferred and willingness to learn the domain.
Required Qualifications
- Advanced SQL with query optimization, window functions, and debugging complex transformations
- Proficient with Microsoft Fabric (Dataflow Gen2, Notebooks, Lakehouse) or equivalent ETL tools (Python, dbt, Talend, Informatica)
- Strong understanding of relational database design and dimensional modeling
- Power Query / M — complex data shaping, merging, error handling, and transformation logic
- Python or similar scripting language for data manipulation and pipeline automation
- Git/version control basics for collaboration on code
- Data quality and testing frameworks — unit tests, assertions, validation rules
- Ability to interpret business requirements and design efficient data solutions
- Data governance mindset — data lineage, documentation, and quality standards
- Proactive about identifying edge cases and potential data issues
- Mortgage/lending domain familiarity preferred; willingness to learn domain
- Works within defined standards and escalates architectural questions to Lead
- Balance speed with quality; advocate for technical excellence
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.