Data Analyst

• Location: Abu Dhabi, UAE
• Contract Duration: Initial 6 months, with the possibility of extension or conversion to a permanent position.
• Compensation & Benefits: Salary based on experience, visa, medical insurance, and travel tickets.
• Accommodation & Food: To be arranged and covered by the candidate.

Responsibilities for Data & Analytics Specialist

Develops and maintains analytical solutions, dashboards and reports to support informed business

decisions.

Translates stakeholder business needs into technical specifications and BI standards.

Develops, deploys and maintains PowerBI cubes, data models, database queries and optimises them for

performance.

Performs advanced data modelling, data collection and analysis from primary and secondary sources.

Identifies, analyses and interprets trends and patterns in complex datasets; turns data into business

insight.

Ensures reports are tested; tracks and resolves defects and issues to closure.

Collaborates with the Digital Core Team and business units on BI project goals, timelines and

standardised reporting requirements.

Education/ Qualification

Bachelor Degree or Masters in Computer Science/Engineering/Applications or

related field.

Certification in Business Analysis is an advantage.

Microsoft Azure-related training/certifications are an advantage: Data Scientist

Associate (DP-100), Power BI Data Analyst Associate (PL-300) or equivalent of

other major cloud platforms

Work Experience

4 to 6 Years of overall work experience primarily working on Analytics and BI

domain preferably in Microsoft stack (MSBI, PowerBI & Excel).

Experience in creating business critical Dashboards and Reports in Power BI

using SQL Server, Lakehouse as sources.

In depth knowledge of data lake, data warehouse/BI development with a focus

on auditability, end-to-end lineage.

Experience of Dynamics 365 or ERP in comparable role within IT, Finance or

Business.

Technical expertise regarding data models, database design development, data

mining and segmentation techniques.

Must have hands-on experience in Power BI report design, with mandatory

expertise in the on-premise Power-BI Report Server with proficiency in DAX and TSQL

queries, along with their integration with cloud services.

Experienced in Data warehousing and Dimensional modelling (Star schema and

Snowflake schema).

Experienced in maintaining and customizing Cubes using SQL Server Analysis

Services (SSAS) and experienced in Data visualization/reporting tools like SSRS

and Power BI.

Experience in creating Power BI Reports using various sources like Excel, CSV,

SQL Server, Oracle, SQL Server Analysis service (SSAS), Azure SQL, Azure Data

Warehouse, etc.,

Experience in creating complex calculations and measures for Visuals and KPI's

using DAX.

Experience in Azure Cloud Services, Azure Databricks, Azure DevOps, Azure

Storage, Azure Data Lake added value.

Knowledge

In-depth knowledge in SQL Server, SSAS, SSIS and SSRS; SQL database

administration experience is added advantage.

Knowledge in Microsoft Dynamics 365 architecture.

Knowledge in PowerBI report/dashboard designing and publishing.

Expertise in writing complex SQL queries and optimizing the Performance

of Power BI Reports. Designed and created databases, tables, views