Reporting Analyst

Turner & Townsend; Edmonton; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading global professional services company is seeking an experienced Program Reporting Analyst in Edmonton, Canada. This role requires expertise in Power BI and SQL, focusing on developing dashboards for construction projects. The ideal candidate will have over 5 years of experience in a similar role, strong analytical abilities, and a recognized degree. The position promotes a collaborative environment, ensuring data accuracy and proactive decision-making to drive project success.

Benefits

Flexible working environment

Opportunity for growth

Diversity and inclusion policy

Qualifications

• 5+ years of experience in data analytics roles, particularly as a Power BI Developer.
• Strong SQL proficiency with complex queries and optimization.
• Experience with data automation and ETL/ELT processes.

Responsibilities

• Develop and optimize Power BI dashboards for project metrics.
• Analyze trends in project costs and schedules.
• Collaborate with stakeholders for data consistency.

Skills

Power BI expertise

SQL skills

Data modeling

Data automation

Analytical skills

Construction project controls

Education

Recognized degree in Computer/Data Science, Business, Economics, Mathematics, Commerce, Engineering

Tools

Power BI

SQL

Job description

Company Description

Turner & Townsend is a global professional services company with over 22,000 people in more than 60 countries.

Working with our clients across real estate, infrastructure, energy and natural resources, we transform together delivering outcomes that improve people’s lives. Working in partnership makes it possible to deliver the world’s most impactful projects and programmes as we turn challenge into opportunity and complexity into success.

Our capabilities include programme, project, cost, asset and commercial management, controls and performance, procurement and supply chain, net zero and digital solutions.

We are majority-owned by CBRE Group, Inc., the world’s largest commercial real estate services and investment firm, with our partners holding a significant minority interest. Turner & Townsend and CBRE work together to provide clients with the premier programme, project and cost management offering in markets around the world.

You are an experienced Program Reporting Analyst with 5+ years of post-graduate experience looking for the next step or are currently undertaking a similar role in a similar environment.

The ideal candidate is self‑motivated, driven, and capable of working both independently and as part of a team. In this impactful role, you will be providing leadership and direction, actively embedding and promoting the purpose, values, and vision of Turner & Townsend.

Job Description

• Develop regular and ad hoc reports from concept to completion and use insight to identify the best format and data interpretation to present and communicate to internal and external stakeholders
• Develop, maintain, and optimize data models and Power BI dashboards for project performance metrics.
• Design real‑time and near real‑time dashboards to monitor construction progress by work package, including filtering and export capabilities.
• Create dashboards to track cost health with comparisons against multiple forecasts and baseline budgets.
• Develop schedule health dashboards comparing current performance to multiple baselines and what‑if scenarios.
• Analyze trends in cost, schedule, and risk to identify emerging issues, risks, and opportunities.
• Support predictive analytics, forecasting, and scenario modeling to enable proactive decision‑making.
• Build and maintain near real‑time dashboards for risk exposure, contingency status, and mitigation progress.
• Display leading indicators, trends, and forecasts related to project progress and costs.
• Automate data pipelines, refresh processes, and reporting workflows using Power BI and related tools.
• Collaborate with functional leads and stakeholders to ensure data consistency, accuracy, and system integration.
• Provide ad hoc analysis and customized reports to support executive and operational decision‑making.

Qualifications

• Recognized degree in Computer/Data Science, Business, Economics, Mathematics, Commerce, Engineering, or equivalent
• Proven minimum 5 years of experience as a Power BI Developer or in a similar data analytics role.
• Strong expertise in Power BI, including data modeling, DAX, Power Query, and performance optimization.
• Strong SQL skills, including writing complex queries, joins, stored procedures, and performance tuning.
• Experience integrating SQL‑based and cloud data sources into Power BI.
• Knowledge of Data Lakehouse architecture and concepts (e.g., data lakes, data warehouses, Delta/Parquet formats, medallion architecture).
• Experience working with large, structured and semi‑structured datasets in a Lakehouse environment.
• Experience building real‑time or near real‑time dashboards using multiple data sources.
• Solid understanding of project controls concepts such as cost, schedule, forecasting, risk, and baselines.
• Experience with data automation, ETL/ELT processes, and report deployment.
• Ability to translate complex data into clear, actionable insights for senior leadership.
• Experience in Construction projects and Project Controls is an asset.

Additional Information

*On-site presence and requirements may change depending on our client's needs*

Our inspired people share our vision and mission. We provide a great place to work, where each person has the opportunity and voice to affect change.

We want our people to succeed both in work and life. To support this we promote a healthy, productive and flexible working environment that respects work‑life balance.

Turner & Townsend is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees and actively encourage applications from all sectors of the community.

Please find out more about us at www.turnerandtownsend.com/ and https://www.heery.com/

All your information will be kept confidential according to EEO guidelines.

#LI-JD1

Join our social media conversations for more information about Turner & Townsend and our exciting future projects:

Twitter

Instagram

LinkedIn

It is strictly against Turner & Townsend policy for candidates to pay any fee in relation to our recruitment process. No recruitment agency working with Turner & Townsend will ask candidates to pay a fee at any time.

Any unsolicited resumes/CVs submitted through our website or to Turner & Townsend personal e‑mail accounts, are considered property of Turner & Townsend and are not subject to payment of agency fees. In order to be an authorised Recruitment Agency/Search Firm for Turner & Townsend, there must be a formal written agreement in place and the agency must be invited, by the Recruitment Team, to submit candidates for review.