Senior Associate Data Engineer

About the role

PwC's Advisory practice in Cairo (ETIC) is looking for a Senior Associate Data Engineer. The team delivers and maintains bespoke .NET technology solutions for clients, and the role sits between engineering and analytics: building data pipelines, writing complex SQL and supporting ad hoc data needs. You will help maintain data accuracy across systems, support stakeholders with one-off data requests and make targeted updates directly in production databases.

Key responsibilities

• Write SQL queries to extract, analyse and transform data for business reporting or internal use.
• Create and run ad hoc insert, update and delete scripts in complex relational databases.
• Partner with analysts, product managers and business stakeholders to meet one-off data requests and generate insights.
• Ensure data integrity and accuracy during manual interventions and debugging.
• Collaborate with engineering teams to optimise database structure and improve data quality.
• Document queries, data structures and one-off scripts for transparency and repeatability.
• Design, develop and maintain data pipelines and ETL/ELT processes in Azure cloud environments (Data Factory, Logic Apps, Synapse, Databricks).

Required profile

• 5+ years of experience in data engineering, analytics or database administration roles.
• Strong communication skills, able to explain technical data issues to non-technical stakeholders.
• Excellent problem-solving and analytical skills, with strong attention to detail in a fast-paced environment.

Required skills

• Strong SQL, including CTEs, window functions and subqueries.
• Relational database systems and data modelling.
• Basic Python for maintaining and updating existing ETL processes.
• Experience writing safe, efficient data modification scripts for production environments.
• Nice to have: Azure Data Factory, Logic Apps, Synapse, Azure App Insights and basic .NET.