ETL Developer

MedNet Egypt

is one of the leading managed care service organizations that caters to healthcare needs. We are looking for a skilled

ETL Data Analyst

who will be responsible for designing, building, and maintaining robust data pipelines that support claims processing, financial reporting, regulatory submissions, provider analytics, and operational dashboards across the TPA ecosystem.

Your Job

• Design, develop, optimize, and maintain ETL workflows.
• Build automated ingestion pipelines for claims, remittance, eligibility, membership, provider files, and policy data.
• Ensure efficient transformations, data cleansing, deduplication, and quality checks.
• Develop scheduling, monitoring, and alerting mechanisms.
• Integrate data from claims engines, network systems, PA engines, finance systems, and insurer portals.
• Map heterogeneous data sources into unified analytical models.
• Support API‑ and SFTP‑based data exchanges with insurers and providers.
• Implement data validation rules for completeness and accuracy.
• Identify anomalies across claims, PA, member, policy, and provider datasets.
• Enhance data lineage and metadata management.
• Work with Data Analysts, BI developers, Operations, Medical, Finance, IT, and Compliance teams.
• Translate business rules into automated ETL logic.
• Provide root‑cause analysis for data issues.
• Tune ETL jobs for scalability, speed, and stability.
• Optimize SQL queries, indexing, and data partitioning.
• Ensure minimal downtime for critical data pipelines.

Your Profile

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 1-3 years ETL/data engineering experience, ideally in TPA or health insurance.
• Strong experience in building scalable ETL pipelines.
• Strong ETL tool experience (SSIS, Informatica, Talend, ADF, etc.).
• SQL (advanced), including query optimization.
• Data warehousing concepts and dimensional modeling.
• Experience with APIs, JSON/XML, and SFTP automation.
• Python, Bash, or PowerShell scripting.
• Cloud experience (Azure/AWS/GCP) preferred