SQL and Power BI Data Engineer

About This Role

The Business Analyst — Power BI, Power Automate & Data is a pivotal programme resource for Project, responsible for bridging the gap between raw legacy data and actionable business intelligence during. This role combines deep data extraction and modelling capability with hands-on Power BI dashboard development and Power Automate workflow automation, enabling to maintain business visibility, improve process efficiency, and support data-driven decision-making throughout the critical transition period from legacy systems to Oracle Fusion Cloud.

The role operates across all functional domains — Finance, Projects, and HR — working closely with the Data Analysts to develop consolidated data models that span Sage Evolution, Deltek Vantagepoint, Smart HR and other sources like Excel. This is a unique, high-impact position that serves both the programme and the business simultaneously.

Essential Requirements

• Minimum 4 years' experience as a Business Analyst or BI Developer
• Expert-level Power BI: data modelling, DAX, Power Query (M), RLS, workspaces, gateway management
• Hands-on Power Automate: cloud flows, approval workflows, scheduled triggers, Microsoft 365 connectors
• Proficiency in SQL for data extraction, transformation, and validation across relational databases
• Experience extracting data from ERP or finance systems (Sage, SAP, Oracle, Dynamics, or similar)
• Advanced Microsoft Excel: Power Query, pivot tables, dynamic arrays, data modelling
• Experience with data from project management or PSA systems (Deltek, Project Online, or similar)
• Strong data modelling skills: star schema, fact/dimension tables, relationship management
• Ability to conduct requirements workshops and translate business needs into technical BI solutions
• Bachelor's degree in Business, Information Systems, Computer Science, or related field

Desirable / Advantageous

• Microsoft PL-300 (Power BI Data Analyst) certification
• Microsoft Power Platform (PL-200) certification
• Experience with Oracle Fusion OTBI, Oracle Analytics Cloud, or BIP (BI Publisher)
• Familiarity with Sage Evolution reporting or database schema
• Experience with Deltek Vantagepoint reporting APIs or database
• Knowledge of Oracle Fusion Cloud data structures for GL, AP, AR, PPM, and HCM
• Experience in ERP implementation or system migration programmes
• Python for data extraction, transformation, or automation scripting
• Familiarity with Azure Data Factory, Dataverse, or SharePoint as data sources in Power Platform
• GCC / UAE industry experience (Construction, leisure, real estate, or professional services)