Data Engineer

PartnerOne

Data Engineer designing and maintaining ETL pipelines for analytics and reporting on Mortgage Cadence Platform. Focus on SQL, data quality, and collaboration with Lead for architectural decisions.

Posted 6/12/2026full-timeRemote • 🇪🇬 EgyptMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLInformaticaPythonSQL

About the role

Key responsibilities & impact

Design and build extraction, transformation, and loading (ETL) pipelines using Microsoft Fabric (Dataflow Gen2, Notebooks, or equivalent tools)
Write optimized SQL queries and transformations for data ingestion from designated source systems
Apply data quality rules and validation logic at each pipeline stage
Implement incremental loads and manage refresh schedules for performance
Escalate to Lead for architectural decisions or complex transformation patterns
Define and implement data quality checks at ingestion, transformation, and output stages
Perform ongoing data validation to ensure pipeline outputs align with business logic and source system expectations
Identify, document, and escalate data quality issues with root cause analysis
Maintain data quality dashboards and SLA monitoring
Support UAT for new data sources or transformation logic
Build and maintain data transformations using Power Query, SQL, or Python as appropriate
Develop dimensional models and define aggregation logic aligned with analytics requirements
Optimize data structures for performance and maintainability
Document transformation logic, lineage, and assumptions per team standards
Troubleshoot pipeline failures and performance issues; coordinate resolution with IT/Engineering
Respond to data discrepancy reports from business users and analysts
Maintain documentation of data sources, data dictionaries, and transformation specifications
Support capacity planning and optimization of Fabric environments and pipelines
Collaborate with Lead to define semantic models and calculated metrics

Requirements

What you’ll need

Advanced SQL — query optimization, window functions, performance tuning, 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 — data manipulation, pipeline automation
Git/version control basics — able to collaborate on code and track changes
Data quality and testing frameworks — unit tests, assertions, validation rules
Ability to interpret business requirements and design efficient data solutions
Data governance mindset — understands data lineage, documentation, and quality standards
Proactive about identifying edge cases and potential data issues
Mortgage/lending domain familiarity preferred; willingness to learn domain required
Works effectively within defined standards and escalates architectural questions to Lead
Able to balance speed with quality; advocates for technical excellence

Benefits

Comp & perks

🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account PartnerOne Website LinkedIn All Job Openings 201 - 500 employees 🏢 Enterprise ☁️ SaaS 💳 Fintech Enterprise
SaaS
Fintech PartnerOne is one of the fastest growing software groups in the world, providing solutions that enhance the operational efficiency of the largest enterprises globally. The company specializes in acquiring software firms and investing in their development to create more robust, effective, and agile software solutions. PartnerOne is trusted by 80% of the world's largest companies, including the top US and European banks, defense contractors, and media conglomerates, focusing on delivering unparalleled customer support and innovative technologies. Data Engineer Job not on LinkedIn 🔥 12 minutes ago 🇪🇬 Egypt – Remote ⏰ Full Time 🟡 Mid-level 🟠 Senior 🚰 Data Engineer ETL Informatica Python SQL Apply Now Find Hiring Managers Customize resume + cover letter Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 Description
Design and build extraction, transformation, and loading (ETL) pipelines using Microsoft Fabric (Dataflow Gen2, Notebooks, or equivalent tools)
Write optimized SQL queries and transformations for data ingestion from designated source systems
Apply data quality rules and validation logic at each pipeline stage
Implement incremental loads and manage refresh schedules for performance
Escalate to Lead for architectural decisions or complex transformation patterns
Define and implement data quality checks at ingestion, transformation, and output stages
Perform ongoing data validation to ensure pipeline outputs align with business logic and source system expectations
Identify, document, and escalate data quality issues with root cause analysis
Maintain data quality dashboards and SLA monitoring
Support UAT for new data sources or transformation logic
Build and maintain data transformations using Power Query, SQL, or Python as appropriate
Develop dimensional models and define aggregation logic aligned with analytics requirements
Optimize data structures for performance and maintainability
Document transformation logic, lineage, and assumptions per team standards
Troubleshoot pipeline failures and performance issues; coordinate resolution with IT/Engineering
Respond to data discrepancy reports from business users and analysts
Maintain documentation of data sources, data dictionaries, and transformation specifications
Support capacity planning and optimization of Fabric environments and pipelines
Collaborate with Lead to define semantic models and calculated metrics 🎯 Requirements
Advanced SQL — query optimization, window functions, performance tuning, 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 — data manipulation, pipeline automation
Git/version control basics — able to collaborate on code and track changes
Data quality and testing frameworks — unit tests, assertions, validation rules
Ability to interpret business requirements and design efficient data solutions
Data governance mindset — understands data lineage, documentation, and quality standards
Proactive about identifying edge cases and potential data issues
Mortgage/lending domain familiarity preferred; willingness to learn domain required
Works effectively within defined standards and escalates architectural questions to Lead
Able to balance speed with quality; advocates for technical excellence Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score Similar Jobs Senior Data Warehouse Consultant 🕒 March 31 Robusta Studio 51 - 200 Website LinkedIn All Job Openings Data Warehouse Senior Consultant overseeing Data Warehouse implementations using Microsoft Fabric. Collaborating with vendors and stakeholders to ensure data integrity and quality in a dynamic environment. 🇪🇬 Egypt – Remote ⏰ Full Time 🟠 Senior 🚰 Data Engineer 🗣️🇸🇦 Arabic Required ERP ETL Senior Data Engineer 🕒 November 12, 2025 Unifonic 501 - 1000 🤖 Artificial Intelligence ☁️ SaaS 📡 Telecommunications Website LinkedIn All Job Openings Senior Data Engineer at Unifonic developing data-driven solutions and building the future enterprise Data Lake. Collaborating with the engineering team to enhance data capabilities. 🇪🇬 Egypt – Remote 💰 $125M Series B on 2021-09 ⏰ Full Time 🟠 Senior 🚰 Data Engineer Apache ETL Greenplum Java Kafka Python Scala Spark SQL View More Data Engineer Jobs 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETLdata qualitydata transformationdimensional modelingPower QueryPythondata validationdata governanceperformance tuning

Soft Skills

collaborationproblem-solvingattention to detailproactivecommunicationanalytical thinkingadaptabilitytime managementcritical thinkingtechnical excellence