UAE National Data Analyst – Power BI, SQL & Python

وزارة تمكين المجتمع; Dubai; On-site; AED 120,000 - 240,000; Full time

Job summary

Data Analyst role in the United Arab Emirates (Dubai) to support Social Support Operations. Transform data from multiple sources into actionable insights, build dashboards in Power BI, and ensure data quality across CRM and databases.

Proficiency in Python, SQL, Excel, and Power BI required to support operational decision-making and performance monitoring. You will collaborate with finance, auditors, and IT teams, document data definitions, and develop automation for validation checks and

Qualifications

• Bachelor's degree in Data Analytics, Computer Science, Statistics, or related field.
• Strong hands-on Python skills (Pandas, NumPy, Matplotlib, Seaborn).
• Advanced SQL skills with MS SQL Server or similar.
• Strong Power BI experience including DAX, Power Query, data modelling, dashboards.
• Advanced Excel skills (XLOOKUP, SUMIFS, COUNTIFS, IF/IFERROR, Pivot Tables).
• Experience validating data from multiple sources and CRM data such as Dynamics 365.

Responsibilities

• Clean, transform, validate, and analyze data from multiple sources using Python, SQL, Excel, and Power BI.
• Develop and maintain Power BI dashboards and reports with KPIs, trends, forecasts, and interactive visuals.
• Design data models and implement DAX measures, Power Query, drill-throughs, tooltips, and row-level security.
• Write and optimize complex SQL queries (joins, subqueries, CTEs, window functions, views, procedures).
• Extract and analyze data from CRM platforms, preferably Microsoft Dynamics 365.
• Investigate and reconcile discrepancies across CRM systems and source data.
• Identify and resolve data-quality issues (missing data, duplicates, invalid values, inconsistencies).
• Conduct trend, variance, MoM, and forecasting analyses.

Skills

Python

SQL

Power BI

Excel

Data validation

DAX

Pandas

NumPy

Matplotlib

Seaborn

Education

Bachelor's degree in Data Analytics, CS, Statistics, or related field

Tools

Power BI

Microsoft SQL Server

Excel

Dynamics 365

Azure/ADF

Git

Job description

Data Analyst role in the United Arab Emirates (Dubai) to support Social Support Operations. Transform data from multiple sources into actionable insights, build dashboards in Power BI, and ensure data quality across CRM and databases.

Proficiency in Python, SQL, Excel, and Power BI required to support operational decision-making and performance monitoring. You will collaborate with finance, auditors, and IT teams, document data definitions, and develop automation for validation checks and