Business Analyst

Opportunity

What you will do

• Gather reporting requirements and translate project teams’ and stakeholders’ needs into practical reporting and analytics solutions.
• Develop and maintain reports, dashboards, and visualizations on project cost, schedule, resources, and operational metrics.
• Analyze project data to identify trends, risks, opportunities, variances, and KPIs, and communicate findings for decision-making.
• Manage and validate data from multiple project systems and business applications for accurate, consistent, reliable reporting.
• Improve reporting processes, automate manual activities, and enhance access to project information using Microsoft technologies and data-driven solutions.

Required qualifications

• 1–3 years of experience in reporting, data analytics, business intelligence, project controls, or a related role.
• Post-secondary education in engineering, computer science, information systems, statistics, data analytics, business analytics, or a related discipline.
• Experience developing reports, dashboards, and visualizations with Power BI, Excel, or similar reporting tools.
• Working knowledge of data modeling, Power Query (M), DAX, SQL, and data transformation.
• Experience gathering business requirements and translating stakeholder needs into reporting and analytics solutions.

Additional qualifications

• Strong analytical and problem-solving skills, with the ability to interpret data and provide actionable insights.
• Strong communication and interpersonal skills for working with technical and non-technical stakeholders.
• Ability to manage multiple priorities, work independently in a fast-paced project environment, and maintain data accuracy and quality.
• Experience in construction, infrastructure, transit, rail, engineering, or other project-based environments is listed as a qualification.
• Experience with SAP, Primavera P6, InEight, Aconex, or similar project systems is listed as a qualification.

Additional or preferred experience

• Experience with Microsoft Power Platform, including Power Apps and Power Automate.
• Exposure to Microsoft Fabric or other modern analytics platforms.
• Knowledge of project controls, including cost management, scheduling, forecasting, progress measurement, and change management.
• Experience with Python or other programming languages used for analytics and automation.

Travel

• Occasional travel to project sites and office locations may be required.

Pay

• Expected pay range is CAD 65,000–75,000 per year.
• Individual pay depends on factors including work location, education, experience, skills, and job conditions.