Role Purpose
Design and deliver modern data,
analytics, and BI solutions that turn enterprise data into trusted insights.
Key Responsibilities
- Understand
business reporting and analytics requirements.
- Build
ETL/ELT pipelines from different data sources.
- Clean,
transform, and validate data.
- Design
data models, KPIs, and semantic layers.
- Develop
Power BI dashboards and reports.
- Support
data quality, governance, and documentation.
- Work
with business users to ensure reports are useful and adopted.
Requirements
Required Skills
- SQL, data modelling, ETL/ELT, Power BI, DAX, and Power
Query.
- Data warehouses, lake-houses, pipelines, semantic
models, and data quality.
- Ability to translate business requirements into
scalable data solutions.
Preferred
- Microsoft Fabric, Azure Data Factory, Databricks,
Snowflake, or similar.
- DP-600 and/or DP-700 certification.
Skills Required
- SQL experience
- Data modeling experience
- ETL experience
- Power BI experience
- DAX experience
- Power Query experience
- Understanding of data warehouses, lakehouses, and reporting concepts
- Ability to translate business needs into data solutions
- Experience with Microsoft Fabric
- Experience with Azure Data Factory
- Experience with Databricks
- Experience with Snowflake or similar platforms
What We Do
CID Consulting is a Cairo-based boutique strategy and implementation consultancy serving private- and public-sector leaders across Egypt and the wider MENA region. It helps organizations, individuals, and communities grow, communicate effectively, and achieve sustainable change through reform-program design, restructuring, project management, and development work. Its projects span economic growth, human development, sustainability, education, tourism, agribusiness, and other sectors for global and local clients.
