Business Analyst - Power BI

DiceTek UAE; Dubai; On-site; AED 200,880 - 312,480; Full time

Benefits offered by this job

Opportunity to work on a business-critical Oracle Fusion Cloud project.

Exposure to finance, HR, and project data across the organization.

Job summary

DiceTek UAE is looking for a skilled Business Analyst - Power BI to drive reporting and data automation. This role involves working on a critical Oracle Fusion Cloud transition programme in Dubai, transforming data into actionable insights.

Candidates should have a Bachelor’s degree and 4 years of experience in BI roles, along with expert knowledge in Power BI, DAX, SQL, and relevant reporting tools. Strong analytical skills are essential.

Qualifications

• Minimum 4 years of experience as a Business Analyst, BI Developer, Power BI Developer, or similar.
• Expert-level Power BI experience, including data modelling, DAX, Power Query, and security.
• Strong SQL skills for data extraction, transformation, and validation.

Responsibilities

• Gather reporting, automation, and data visibility requirements from stakeholders.
• Develop Power BI dashboards and reports that support business visibility during transitions.
• Use SQL to extract and transform data from relational databases.

Skills

Business analysis and BI development

Power BI dashboard development

DAX and Power Query

Power BI data modelling

Row‑level security and workspace management

Power BI gateway configuration

Power Automate cloud flows

Approval workflows and scheduled triggers

SQL extraction and validation

ERP and finance system reporting

Advanced Microsoft Excel

Education

Bachelor's degree in Business, Information Systems, Computer Science, or a related field

Tools

Power BI

SQL

Microsoft Excel

Power Automate

Oracle Fusion OTBI

Oracle Analytics Cloud

Job description

Job Details

Location: Dubai, United Arab Emirates

Country: United Arab Emirates

City: Dubai

Industry: IT and Services

Function: Business Analysis-Research

Job Type: Full-time

Salary: 18000–28000 (estimated)

Overview

Business Analyst - Power BI in Dubai, within the IT and Services sector is a high-impact business intelligence and data automation role focused on Power BI dashboards, Power Automate workflows, SQL data extraction, and consolidated reporting across Finance, Projects, and HR domains. The role is suitable for a hands‑on BI professional who can transform legacy ERP, project, HR, and Excel‑based data into actionable insights during a critical Oracle Fusion Cloud transition programme.

Key Responsibilities

• Gather reporting, automation, and data visibility requirements from Finance, Projects, HR, and programme stakeholders.
• Develop Power BI dashboards, reports, and analytical models that support business visibility during the transition to Oracle Fusion Cloud.
• Build consolidated data models using information from Sage Evolution, Deltek Vantagepoint, Smart HR, Excel, and other structured sources.
• Design data models using star schema, fact tables, dimension tables, relationships, measures, and reusable reporting logic.
• Create advanced DAX calculations, Power Query transformations, and clean semantic models for business reporting.
• Configure Power BI workspaces, gateways, row-level security, refresh schedules, and report access controls.
• Use SQL to extract, transform, validate, and reconcile data from relational databases and legacy systems.
• Build Power Automate cloud flows, approval workflows, scheduled triggers, and Microsoft 365 connector‑based automations.
• Support business users with reporting prototypes, dashboard walkthroughs, requirements workshops, and user acceptance validation.
• Work with data analysts to align reporting outputs with finance, project, HR, and Oracle migration data structures.
• Create exception reports, reconciliation dashboards, operational trackers, and programme performance views.
• Improve process efficiency by automating manual reporting, approval, and notification workflows.
• Support data-driven decision‑making throughout ERP implementation, migration readiness, and business transition activities.

Ideal Profile

• Bachelor's degree in Business, Information Systems, Computer Science, or a related field.
• Minimum 4 years of experience as a Business Analyst, BI Developer, Power BI Developer, or similar data‑focused role.
• Expert‑level Power BI experience, including data modelling, DAX, Power Query, row‑level security, workspaces, and gateway management.
• Hands‑on experience with Power Automate, including cloud flows, approval workflows, scheduled triggers, and Microsoft 365 connectors.
• Strong SQL skills for data extraction, transformation, validation, and reconciliation across relational databases.
• Experience extracting and analysing data from ERP or finance systems such as Sage, SAP, Oracle, Microsoft Dynamics, or similar platforms.
• Advanced Microsoft Excel capability, including Power Query, pivot tables, dynamic arrays, and data modelling.
• Experience working with project management or PSA data from systems such as Deltek, Project Online, or similar platforms.
• Strong understanding of star schema, fact and dimension modelling, data relationships, and reporting layer design.
• Ability to run requirements workshops and translate business needs into practical BI and automation solutions.
• Microsoft PL‑300 Power BI Data Analyst certification is an advantage.
• Microsoft Power Platform PL‑200 certification is preferred.
• Experience with Oracle Fusion OTBI, Oracle Analytics Cloud, or BI Publisher will add value.
• Familiarity with Sage Evolution reporting, Deltek Vantagepoint reporting APIs, Oracle Fusion Cloud data structures, or ERP migration programmes is beneficial.
• Knowledge of Python, Azure Data Factory, Dataverse, SharePoint, or Power Platform data sources is an advantage.
• GCC or UAE experience in construction, leisure, real estate, or professional services environments is preferred.

Skills Set

• Business analysis and BI development
• Power BI dashboard development
• DAX and Power Query
• Power BI data modelling
• Row‑level security and workspace management
• Power BI gateway configuration
• Power Automate cloud flows
• Approval workflows and scheduled triggers
• SQL extraction and validation
• ERP and finance system reporting
• Sage Evolution data analysis
• Deltek Vantagepoint data reporting
• Smart HR and workforce data
• Advanced Microsoft Excel
• Star schema and dimensional modelling
• Oracle Fusion Cloud reporting awareness
• OTBI, Oracle Analytics Cloud, and BI Publisher
• Data reconciliation and exception reporting
• Microsoft 365 connectors and workflow automation

Why Join Us

• Work on a business‑critical Oracle Fusion Cloud transition programme in Dubai.
• Build practical exposure across Finance, Projects, HR, ERP data, Power BI reporting, and Power Platform automation.
• Contribute directly to business visibility, reporting accuracy, and process improvement during system migration.
• Strengthen expertise in data modelling, dashboards, workflow automation, SQL, and enterprise reporting.
• Ideal opportunity for BI professionals looking to grow in ERP transformation, Power Platform consulting, and data‑driven business operations.