MICROSOFT STACK BI ENGINEER DUNCAN AND ROSS MANAGEMENT CONSULTANCIES

Posted on 12 Mar

Experience

5 - 10 Years

Job Location

Dubai - United Arab Emirates (UAE)

Education

Master of Technology/Engineering(Computers), Master of Science(Computers)

Nationality

Any Nationality

Gender

Any

Vacancy

1 Vacancy

Job Description

Roles & Responsibilities

  • Design & Document: Architect and develop end-to-end BI solutions including ETL, data models, and reporting layers.

  • Model & Transform: Construct the Bronze, Silver, Gold layer and semantic models using SQL Server, SSIS, and SSAS.

  • Develop & Visualize: Build interactive dashboards and reports in Power BI Desktop with optimized DAX.

  • Automate & Optimize: Implement Power Automate workflows and optimize SQL/SSAS performance.

  • Handoff: Deliver clear source-to-destination mapping documentation (Primary Keys, Join Logic, Transformations, and Data Lineage) for business and technical stakeholders.


Desired Candidate Profile

  • SQL Server: Complex SQL development, performance tuning, and high-volume data handling.

  • SSIS: Strong experience in designing ETL packages with full and incremental load strategies.

  • SSAS (Multidimensional & Tabular): Deep understanding of cube design, tabular modelling, DAX, hierarchies, and measures.

  • Power BI Desktop: Advanced report development, data modelling, and DAX optimization.

  • Power Query: Strong data transformation and mashup capabilities.

  • Power Automate: Workflow automation and report distribution processes.

  • Python: Data manipulation, automation, and integration scripting.

  • Data Modelling & Validation: Expertise in dimensional modelling (Star/Snowflake schemas) and data reconciliation techniques.

Preferred Experience

Experience in Dynamics AX or Oracle Fusion ERP and enterprise BI implementations.

Employment Type

    Full Time

Company Industry

Department / Functional Area

Keywords

  • MDX
  • Power BI
  • Reporting Analyst
  • BI Developer
  • BI Analyst
  • Data Analyst
  • SSIS
  • Analytics Engineer

DUNCAN AND ROSS MANAGEMENT CONSULTANCIES

Duncan & Ross Engineering & Technology offers integrated and customer oriented services in the different industries such as Energy, Utilities, Oil & Gas, Construction, Healthcare & Life Sciences, Banking & Finance, Technology, Media & Telecommunications, Aerospace & Defense, Transport & Railway. We support our clients with Engineering Services onsite and offsite and Technology Services (Cloud & Security, Applications, Data & Analytics). Duncan & Ross can draw on its worldwide network of human capital, engineering consulting and quality oriented solutions. Our customers will profit from these synergies that play an important role in the processing of our projects.

Read More

Fabien Claeys - Operations Director

Ubora Business Tower Level 705 Post Code: 5002353 Dubai Knowledge Village, Dubai, United Arab Emirates (UAE)