Data Engineering & Analytics Lead
Description
Job Description – Data Engineering & Analytics Lead
About the Role
Mansour Automotive Group (MAG) is building a modern, group-wide data platform on Microsoft Fabric, fed primarily from SAP, to power reporting, advanced analytics and AI across our automotive businesses.
We are looking for a hands-on Data Engineering & Analytics Lead to own both sides of that platform: the pipelines and lakehouse that move and model the data, and the Power BI layer that turns it into decisions.
Key Responsibilities
1. Practice Ownership & Delivery
- Own the data engineering and analytics practice: architecture, standards, tooling and ways of working.
- Define and maintain engineering and BI best practices — modelling conventions, code reviews, testing, documentation and release processes.
- Own the data & analytics roadmap and backlog, prioritising work based on business value.
- Translate business requirements into scalable data products, semantic models and dashboards.
- Continuously assess new Fabric and Power BI capabilities and decide what the platform should adopt.
2. Data Engineering (Microsoft Fabric)
- Design, build and operate the Fabric data platform: Lakehouse, Warehouse, Data Factory pipelines, Dataflows Gen2, Notebooks (PySpark/Spark SQL) and OneLake.
- Implement and maintain a Medallion architecture (Bronze/Silver/Gold) with clear standards for ingestion, transformation, naming and data contracts.
- Build reliable ingestion from SAP (ECC/S/4HANA) and non-SAP sources, including incremental and CDC loads.
- Own data quality, monitoring, alerting, performance tuning and capacity/cost management.
- Apply CI/CD, Git integration and deployment pipelines for Fabric and Power BI artifacts.
3. Analytics & BI (Power BI)
- Own the enterprise semantic layer: star-schema modelling, shared datasets/semantic models, DAX standards and Direct Lake / Import / DirectQuery design choices.
- Deliver executive and operational dashboards; ensure consistency of KPIs and a single version of the truth across business units.
- Establish workspace governance, row-level security, certified datasets, and self-service BI guidelines.
- Drive adoption through training, documentation and a community of practice for business power users.
4. Governance & Architecture
- Define and enforce data governance, security, access control and lineage (including Microsoft Purview where applicable).
- Partner with SAP, integration and AI teams so the platform supports downstream use cases such as forecasting, ML models and AI agents.
Requirements
Must Have
- Bachelor's degree in Computer Science, Engineering or a related field.
- 4–7 years in data engineering and/or BI, including some experience leading a team.
- Hands-on production experience with Microsoft Fabric.
- Strong Power BI skills: data modelling, DAX and Power Query.
- Strong SQL; working knowledge of Python / PySpark.
- Good understanding of data warehousing and dimensional modelling.
- Good communication skills in English and Arabic.
Preferred
- Experience working with SAP environments (ECC or S/4HANA) as a data source — understanding of core SAP tables and modules (SD, MM, FI/CO), and extraction approaches such as SAP CDS views, ODP/SLT, Datasphere or Fabric SAP connectors.
- Experience in the automotive, retail or distribution sectors.
- Exposure to Azure data services (Synapse, Data Factory, Databricks) or migrating from them to Fabric.
- Familiarity with Microsoft Purview, data quality frameworks, or MLOps / feature preparation for data science.
- Microsoft certifications.
Key Competencies
- Hands-on technical leadership — leads by example and still writes code.
- Ownership and accountability for platform reliability and data quality.
- Business acumen: connects data work to commercial and operational outcomes.
- Structured problem solving and clear prioritisation.
- Coaching mindset and ability to build and develop technical capabilities within the team.
Skills
- Agentic AI
- AI
- Analytics
- Azure
- Azure Data Factory
- CI/CD
- Data Engineering
- Data Governance
- Data Modeling
- Data Quality
- Data Science
- Data Warehousing
- Databricks
- Dimensional Modeling
- Git
- Lakehouse
- Machine Learning
- Medallion Architecture
- Microsoft Fabric
- Microsoft Purview
- MLOps
- Power Query
- Power BI
- PySpark
- Python
- SAP
- SAP S/4HANA
- Spark
- SQL
Sign in to read and join the discussion.