Analytics Analyst

PCL Construction, Inc.; Edmonton; On-site; CAD 70,000 - 95,000; Full time

Benefits offered by this job

Employee ownership opportunities that

Annual discretionary performance bonus

RRSP, TFSA, Pension Contribution

Flexible medical, dental and vision

Prescription drug coverage

Life, AD&D and disability insurance

Paid parental leave

Health and lifestyle spending accounts

Mental health and wellness support

Career growth pathways

Access to training

Opportunity to learn new skills

Job summary

PCL Industrial Management Inc. in Edmonton, Alberta, is seeking an Analytics Analyst to design and develop Power BI dashboards, model data, and translate business needs into analytical solutions. You will partner with IT and project teams to drive data-powered decisions.

The role emphasizes data visualization, data governance awareness, and continuous improvement of analytics practices, including training end-users and staying current with BI trends.

Qualifications

• 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.

Responsibilities

• Visualization Design and Development: Build and enhance Power BI dashboards, ensuring data accuracy, intuitive design, and performance optimization.
• Data Modeling: Create and maintain efficient data models within Power BI, employing Power Query and DAX to perform data transformations and calculations. Maintain ERD models for reference outside of PowerBI
• Collaboration: 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 backend and innovate on current practices.
• Simplification: Help identify where we can simplify, streamline, and automate our reporting.
• Training & Support: Serve as the in-house expert on Power BI, providing training sessions, documentation, and best practices to end-users.
• Continuous Improvement: Stay current on Power BI updates, features, and industry trends to recommend and implement innovative solutions.

Skills

Power BI

DAX

Power Query

Data modeling

SQL

Visualization design

Cross-functional collaboration

Education

Bachelor's degree in business, Computer Science, Data Analytics, or a related field

Tools

Power BI

Job description

The future you want is within reach. Let's build it together.

At PCL Industrial Management Inc., part of the PCL Family of Companies (PCL), we don't just build projects -- we build opportunities, careers and communities. We are 100% employee-owned, every employee has a stake in our success, and that shared commitment drives how we work, grow and lead in the construction industry.

We're a team of builders who care deeply about what we create and who we build with. That includes you. We are not only shaping the future of construction, we are also committed to shaping the future of your career.

As a Analytics Analyst for PCL Industrial Management Inc. in Edmonton, Alberta (Ind Mgmt), you'll have the opportunity to workwithin a team or individually to write, review, and debug code that supports and maintains current or new development projects. They participate in or lead estimation, design, and planning activities.

Why Choose PCL?

Choose a career with rewards that matter. PCL's total rewards are designed to support your growth, well-being and future success -- because when you succeed, we all do. Our offerings could include:

• 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

Here's how aAnalytics Analyst for PCL Industrial Management Inc. within Edmonton Industrial Management contributes to our team:

• Visualization Design and Development: Build and enhance Power BI dashboards, ensuring data accuracy, intuitive design, and performance optimization.
• Data Modeling: Create and maintain efficient data models within Power BI, employing Power Query and DAX to perform data transformations and calculations. Maintain ERD models for reference outside of PowerBI
• Collaboration: 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 backend and innovate on current practices.
• Simplification: Help identify where we can simplify, streamline, and automate our reporting.
• Training & Support: Serve as the in-house expert on Power BI, providing training sessions, documentation, and best practices to end-users.
• Continuous Improvement: Stay current on Power BI updates, features, and industry trends to recommend and implement innovative solutions.

Qualifications

• 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.

Your Work Has Purpose Here

PCL projects are where life happens, where communities connect, careers begin, and progress is made. Regardless of the type of project, we are building something bigger: a future that's inclusive, resilient and full of opportunity.

At PCL Industrial Management Inc., we are committed to creating a workplace where everyone belongs. We value the diverse experiences, identities and perspectives our employees bring. Employment decisions are based on merit, potential and the drive to make a difference, regardless of race, gender, age, ability or background.

We know everyone's needs are different, if you require accommodation during the application process, please contact [e-mail] and include the position and location of interest.

This recruitment process does not involve the use of artificial intelligence (AI) to screen, assess, or select applicants. All hiring decisions are made by human reviewers.

Primary Location: Edmonton, Alberta (Ind Mgmt)