SQL and Power BI Data Engineer
Job Description
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
- 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)