Data Analyst – Social Support Operations - UAE National

About the Role

Core Responsibilities

• Clean, transform, validate, and analyze multi-source data using Python, SQL, Excel, and Power BI.
• Develop and maintain Power BI dashboards and reports with KPIs, trends, forecasts, and interactive visualizations.
• Design data models and implement DAX measures, Power Query, drill-throughs, tooltips, and row-level security.
• Write and optimize complex SQL queries using joins, subqueries, CTEs, window functions, aggregations, views, and stored procedures.
• Extract and analyze CRM data, preferably from Microsoft Dynamics 365.
• Investigate discrepancies across CRM systems, databases, integrations, reports, and source data.
• Identify and resolve missing data, duplicates, invalid values, inconsistent classifications, and broken dataset relationships.
• Conduct trend, variance, month-over-month, and forecasting analyses.
• Develop automated data-quality checks, exception reports, and validation mechanisms for operational and audit purposes.
• Translate business requirements and business rules into SQL, Python, DAX, and data-validation logic.
• Gather and document requirements, KPIs, calculation rules, assumptions, filters, and acceptance criteria.
• Prepare UAT cases, communicate findings, maintain documentation, collaborate with stakeholders, and ensure confidentiality, security, access control, auditability, and reproducibility.

Required Qualifications and Experience

• Bachelor's degree in Data Analytics, Computer Science, Statistics, Information Systems, Business Analytics, or a related field.
• Strong hands-on Python experience, particularly with Pandas, NumPy, Matplotlib, and Seaborn.
• Advanced SQL skills with Microsoft SQL Server or similar relational databases.
• Strong Power BI experience, including DAX, Power Query, data modelling, and dashboard development.
• Advanced Microsoft Excel skills, including XLOOKUP, SUMIFS, COUNTIFS, IF/IFERROR, Pivot Tables, and Power Query.
• Experience analyzing and validating data from multiple sources.
• Strong understanding of data-quality principles and data reconciliation.
• Experience with CRM data.
• Strong analytical, problem-solving, and root-cause analysis skills.
• Ability to translate complex business processes into measurable requirements and analytical solutions.
• Strong communication and documentation skills.

Preferred Qualifications

• Microsoft Power BI or equivalent analytics certification is preferred.
• Microsoft Dynamics 365 CRM experience is preferred.
• Familiarity with Azure, Data Factory, Microsoft Fabric, APIs, or data integration technologies is preferred.
• Knowledge of Git or other version-control systems is preferred.
• Familiarity with Agile delivery and requirements-management practices is preferred.

Key Skills

• Python, SQL, Power BI, DAX, Power Query, Microsoft Excel, data modelling, data quality, data validation, CRM analytics, business intelligence, KPI reporting, forecasting, root-cause analysis, UAT, and data governance.