Data & Analytics Specialist

Techcarrot

Abu Dhabi

On-site

AED 180,000 - 320,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Techcarrot in Abu Dhabi is seeking a BI Analyst to develop and maintain analytical solutions, dashboards and reports to support informed business decisions. You will translate stakeholder needs into technical specifications and BI standards, and deploy Power BI cubes, data models and queries optimized for performance.

Responsibilities include advanced data modelling, data collection from multiple sources, identifying trends, and turning data into actionable business insight.

Qualifications

  • Experience in Analytics and BI using Microsoft stack
  • Experience creating dashboards/reports in Power BI with SQL Server/ Lakehouse
  • Knowledge of data lake, data warehouse with end-to-end lineage
  • Experience with Dynamics 365 or ERP in IT/Finance
  • Strong data modelling and database design skills
  • Hands-on Power BI Report Server, DAX and TSQL
  • Experience in SSAS/SSRS/SSIS and data visualization
  • Experience with Azure cloud services

Responsibilities

  • Develop and maintain analytical solutions, dashboards and reports
  • Translate stakeholder needs into technical specifications and BI standards
  • Develop and deploy Power BI cubes, data models and queries
  • Perform advanced data modelling and analysis from sources
  • Identify trends and turn data into business insight
  • Ensure reports are tested and defects tracked to closure
  • Collaborate with Digital Core Team on BI goals and reporting

Skills

Analytical thinking
SQL
Python/R scripting
Power BI
DAX
Data visualization
Problem solving

Education

Bachelor's degree in CS/Engineering/Applications
Master's degree in related field
Power BI / Azure certifications

Tools

Power BI
SSAS
SSRS
SSIS
Azure Databricks
Azure Data Lake
Azure SQL
SQL Server
Dynamics 365

Job description

Develop and maintain analytical solutions, dashboards and reports to support informed business decisions. Translate stakeholder business needs into technical specifications and BI standards. Develop, deploy and maintain Power BI cubes, data models and database queries, and optimise them for performance. Perform advanced data modelling, data collection and analysis from primary and secondary sources. Identify, analyse and interpret trends and patterns in complex datasets, and turn data into business insight. Ensure reports are tested; track and resolve defects and issues to closure. Collaborate with the Digital Core Team and business units on BI project goals, timelines and standardised reporting requirements.

Requirements
  • 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
Education:
  • 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
Knowledge of
  • 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, stored procedures, and functions using SQL server
Skills required:
  • Proven analytical background
  • Proficiency in scripting / programming languages SQL. Python/R scripting
  • is preferred
  • RPA and predictive analytics capabilities is an added advantage
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Executive Data Analytics
Senior Executive Data Analytics

Client of WhiteCrow Research • Dubai

On-site
AED 120,000 - 180,000
Senior Executive – Data Analytics
Senior Executive – Data Analytics

WhiteCrow Research • Dubai

On-site
AED 240,000 - 420,000
Senior Data & Insights Analyst
Senior Data & Insights Analyst

Al Tayer Group • Dubai

On-site
AED 300,000 - 540,000
Power BI Developer
Power BI Developer

Rivoli Group • Dubai

On-site
AED 180,000 - 260,000
Strategic Data Insights & Analytics Leader
Strategic Data Insights & Analytics Leader

du • Dubai

On-site
AED 446,000 - 670,000
16079 - Software Enginer
16079 - Software Enginer

ParamInfo • Dubai

On-site
AED 167,000 - 301,000
Data & Business Intelligence Analyst
Data & Business Intelligence Analyst

Caliberly • Dubai

On-site
AED 120,000 - 240,000
Senior Specialist - Power BI Developer /Reporting
Senior Specialist - Power BI Developer /Reporting

Dicetek LLC • Abu Dhabi

On-site
AED 120,000 - 180,000
Power BI Developer Data Visualization & Reporting Specialist
Power BI Developer Data Visualization & Reporting Specialist

Dicetek LLC • Abu Dhabi

On-site
AED 120,000 - 180,000
Power BI Lead – Business Intelligence & Analytics
Power BI Lead – Business Intelligence & Analytics

VPS Elite Human Resources Consultancies LLC • Dubai

On-site
AED 250,000 - 450,000
Top locations