Data & Analytics Specialist

About the role

techcarrot FZ LLC is looking for a Data & Analytics Specialist in Abu Dhabi to develop and maintain analytical solutions, dashboards and reports that support informed business decisions. The role translates stakeholder business needs into technical specifications and BI standards, and works closely with the Digital Core Team and business units on BI projects.

Key responsibilities

• Develop, deploy and maintain Power BI cubes, data models and database queries, optimising them for performance
• Perform advanced data modelling, data collection and analysis from primary and secondary sources
• Analyse trends and patterns in complex datasets and turn data into business insight
• Test reports, track and resolve defects until closure
• Collaborate with the Digital Core Team and business units on BI project goals, timelines and standardised reporting requirements

Required profile

• 4 to 6 years of overall experience, primarily in analytics and BI, preferably in the Microsoft stack (MSBI, Power BI and Excel)
• Bachelor's or Master's degree in Computer Science, Engineering, Applications or a related field
• Certification in Business Analysis is an advantage; Azure or Power BI certifications are also an advantage

Required skills

• Hands-on Power BI report design, including on-premise Power BI Report Server, DAX and T-SQL
• Data warehousing, dimensional modelling (star and snowflake schemas) and SSAS cube maintenance
• Creating reports from Excel, CSV, SQL Server, Oracle, SSAS, Azure SQL and Azure Data Warehouse
• Complex DAX calculations and measures for visuals and KPIs
• SQL Server, SSAS, SSIS, SSRS and SQL database administration (added advantage)
• Azure services such as Azure Databricks, Azure DevOps, Azure Storage and Azure Data Lake (added value)
• Scripting in SQL, Python or R (preferred); RPA and predictive analytics (added advantage)