Analytics Analyst

PCL Construction

. Build and enhance Power BI dashboards, ensuring data accuracy, intuitive design, and performance optimization.

Posted 11/10/2026full-timeEdmonton • CanadaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Power BI, including DAX and Power Query, to build and optimize dashboards and data models. Capable of translating business requirements into actionable analytical solutions while maintaining strong communication and problem-solving skills.

Highest-signal resume keywords

Power BI ProficiencyDAX ExpertiseData Modeling SkillsSQL KnowledgeBusiness Analysis Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BIDAXPower QueryData ModelingSQLETL ProcessesData GovernanceDashboard CreationAnalytical SolutionsVisualization Techniques

Soft Skills

Strong CommunicationPresentation AbilitiesProblem-Solving SkillsAnalytical Thinking

Industry Keywords

Business AnalysisAgile DevelopmentConstructionAEC Fields

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Build and enhance Power BI dashboards, ensuring data accuracy, intuitive design, and performance optimization.
Create and maintain efficient data models within Power BI using Power Query and DAX for data transformations and calculations.
Maintain ERD models for reference outside of Power BI.
Work with line-of-business and project teams to gather requirements and translate business questions into actionable analytical solutions.
Partner with IT and data professionals to design technical backends and innovate on current practices.
Identify opportunities to simplify, streamline, and automate reporting.
Serve as the in-house Power BI expert by providing training sessions, documentation, and best practices to end users.
Stay current on Power BI updates, features, and industry trends to recommend and implement innovative solutions.
Write, review, and debug code supporting current or new development projects.
Participate in or lead estimation, design, and planning activities.

Requirements

What you’ll need

Bachelor’s degree in business, Computer Science, Data Analytics, or a related field (or equivalent experience).
Proficiency in Power BI, including DAX, Power Query, and data modeling.
Comfortable with SQL and experience working with relational and nonrelational data stores.
Exposure to ETL processes, databases, and data governance practices.
Visual design and selection of most appropriate visualization techniques.
Exposure to a modern agile development workflow is an asset.
A track record of creating impactful dashboards and analytics solutions.
Business analysis: Experience working with cross-functional teams to translate business goals into analytical tasks.
Experience in construction or AEC fields is a benefit, but not necessary.
Strong communication and presentation abilities.
Strong problem-solving skills and analytical thinking.

Benefits

Comp & perks

Employee ownership opportunities that build long-term value
Annual discretionary performance bonuses
RRSP, TFSA, Pension Contribution Options
Flexible medical, dental and vision benefits
Prescription drug coverage and virtual care services
Life, AD&D and disability insurance
Paid parental leave and family care support
Health and lifestyle spending account options
Mental health and wellness support, including Employee Assistance Programs
Career growth pathways, leadership development and mentorship programs
Access to world-class training through PCL's College of Construction and professional development courses
Ongoing opportunities to learn new skills, explore different roles and grow your career across sectors and regions