Business System Analyst

Senior Officer – Project Controls (Digital Reporting & Analytics)The role is based at office, with travel to project sites as required.This role sits at the intersection of project controls, data analytics, and digital systems integration, supporting enterprise-level reporting, automation, and decision-making across our project portfolio.Role OverviewReporting to the Senior Manager – Project Controls, you will lead the integration of Primavera P6 EPPM with Power BI, oversee Power BI administration, and support the broader Microsoft Power Platform ecosystem (Power Apps, Dataverse, Power Automate).Key ResponsibilitiesIntegration & AutomationLead integration of Primavera P6 EPPM data with Power BI to deliver automated dashboards and KPIsDevelop and maintain ETL pipelines, data models, and data connections across P6, Power Apps, and DataverseEnsure data accuracy, refresh efficiency, and performance optimizationPower BI Administration & DevelopmentManage Power BI workspaces, datasets, permissions, and user accessMaintain and develop interactive dashboards and executive reports covering schedule, cost, progress, and performanceDesign advanced visuals including Shape Maps / TopoJSONImplement row-level security (RLS), governance standards, and version controlPower Platform & Data EcosystemSupport integration of Power Apps, Dataverse, and SharePoint with Power BICoordinate with IT and project teams to ensure seamless data synchronizationProcess ImprovementIdentify manual reporting pain points and automate them using Power BI, Power Automate, and Power AppsRecommend and implement best practices in data architecture, visualization, and governanceStakeholder SupportWork closely with IT, EPMO, development, procurement, project controls teams, and senior managementDeliver user training and maintain documentation for dashboards and integrationsQualifications & SkillsEducationBachelor’s degree in Engineering, Computer Science, Information Systems, or related fieldRelevant certifications in data analytics or project systems are an advantageTechnical SkillsAdvanced Power BI (DAX, Power Query, data modeling, administration)Strong experience integrating Primavera P6 EPPM with Power BIMicrosoft Power Platform: Power Apps, Power Automate, DataverseProficiency in SQL, APIs, ETL tools (Python or Azure Data Factory is a plus)Knowledge of data governance, RLS, and security frameworksSolid understanding of project controls concepts (schedule, cost, progress, KPIs)Experience5–7 years in data analytics, project reporting, or digital transformation rolesMinimum 2 years developing Power BI reports for the construction / real estate sector, including Primavera P6 integrationProven experience delivering enterprise-level Power BI dashboardsBackground in engineering, construction, or project management environments strongly preferredPreferred CertificationsMicrosoft Certified: Data Analyst Associate (Power BI)Microsoft Certified: Power Platform App Maker or Developer Associate