Reporting (Power BI) Specialist
About The Position
SYSTRA Canada is seeking a highly motivated Junior Power BI Data Analyst to join their reporting and analytics team, supporting a major infrastructure program. This role is crucial for developing and maintaining Power BI dashboards that offer strategic insights into scheduling performance for large-scale capital projects. The ideal candidate will be passionate about transforming complex data into meaningful visuals and using data to drive business decisions. The role involves collaboration with cross-functional stakeholders, including Scheduling, Project Controls, and Digital Transformation teams, to ensure reliable, scalable, and insightful reporting. The position will focus on sustaining the current reporting environment, including interdependent dashboards, Power Query transformations, and SharePoint-integrated dataflows, while also contributing to the transition towards a more centralized, automated, model-driven reporting solution.
Requirements
- 7+ years of experience building and maintaining reports in Power BI (Power BI Desktop and Power BI Service).
- Hands-on experience with Power Query (M) for data transformation and cleansing.
- Solid knowledge of DAX and report performance optimization techniques.
- Experience working with SharePoint Online, Excel-based source data, Power BI Dataflows and Microsoft Fabric Data Warehouses.
- Understanding of project controls concepts, especially around schedule management, forecasting and variance analysis.
- Comfortable working with structured and unstructured datasets, performing data validation, and reconciling reporting outputs.
- Strong analytical and problem-solving skills, with attention to detail and data accuracy.
- Excellent verbal and written communication skills to effectively interface with both technical and non-technical stakeholders.
Nice To Haves
- Exposure to Power Apps or interest in learning how to integrate low-code apps with Power BI for enhanced user experiences.
Responsibilities
- Maintain and enhance existing Power BI dashboards for schedule forecasting, variance analysis, and historical trending.
- Optimize report performance through improvements in Power Query/M Query transformations, DAX calculations, drill-throughs, bookmarks, and field parameters.
- Collaborate with Project Controls, Scheduling, and Digital teams to clarify reporting requirements and support ad hoc updates.
- Troubleshoot data and visualization issues (refreshes) to ensure ongoing report reliability.
- Apply strong UI/UX principles in dashboard design, focusing on layout hierarchy, visual clarity, accessibility, and interactive navigation.
- Support updates to semantic models in alignment with evolving reporting requirements.
- Maintain and enhance data models using star schema principles for scalable and performant reporting.
- Maintain dataflows and queries connecting Excel, SharePoint, and Power BI Service sources.
- Assist in validating and reconciling schedule data against source systems like Primavera (P6).
- Contribute to the planning and gradual shift towards a model-driven, centralized schedule reporting architecture.
- Automate current workflows to support dashboard integration of new and ongoing developments.
- Provide documentation and knowledge transfer to support long-term reporting automation goals.
Benefits
- Equal access employment program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Education Level
No Education Listed
