Data Analyst

PCL Construction; Edmonton; On-site; CAD 70,000 - 100,000; Full time

Benefits offered by this job

Employee ownership

Annual discretionary bonuses

RRSP / TFSA options

Flexible medical benefits

Mental health support

Career development

Job summary

PCL Constructors Inc. in Edmonton, Alberta (Corporate) seeks a Data Analyst to support CraftStream with data, integrations, analytics and continuous improvement.

You will develop Power BI reports, maintain ETL processes and troubleshoot data quality across systems to deliver reliable data for business decisions. You will work closely with business and technical stakeholders, leveraging SQL, Boomi, Azure Synapse, Fabric and Azure DevOps to implement effective solutions and maintain documentation.

Qualifications

• Postsecondary degree or diploma in computer technology or a related discipline.
• 3+ years of progressive experience in a related field.
• Ability to think logically and analytically, and constructively express ideas and concepts.
• Intermediate to advanced experience with analytics tools (Power BI), data storage (Fabric, OneLake, Data Lake, SQL), data movement and transformation (Boomi, Databricks, Data Factory), Azure DevOps Boards and Pipelines, and scripting (SQL or Python).
• Effective communication and collaboration skills with stakeholders.

Responsibilities

• Develop and maintain Power BI reports and dashboards.
• Develop and maintain ETL processes using Boomi, Azure Synapse, and Power BI.
• Create, maintain and enhance analytics, data integrations and data repository solutions.
• Investigate, troubleshoot and resolve data quality issues between systems.
• Build and maintain dashboards, reports and data visualizations to support business decisions.
• Use SQL to manipulate, transform and analyze data.
• Translate business requirements into technical solutions.
• Conduct iterative testing with clients and stakeholders to ensure solutions meet needs.
• Research and recommend new data and analytics technologies and best practices.
• Create and maintain technical documentation and track progress in Azure DevOps.

Skills

Power BI

SQL

Python

Analytical thinking

Communication

Education

Postsecondary degree or diploma in computer technology or related discipline

Tools

Fabric

OneLake

Data Lake

Boomi

Azure DevOps

Databricks

Job description

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

At PCL Constructors 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 Data Analyst for PCL Constructors Inc. in Edmonton, Alberta (Corporate), you'llsupport CraftStream, an internally built application, with a focus on data, integrations, analytics, and continuous improvement. You’ll develop Power BI reports and dashboards, maintain ETL processes, troubleshoot data quality and integration issues, and use technologies such as SQL, Boomi, Azure Synapse, Fabric, and Azure DevOps to deliver effective technical solutions. Working closely with business and technical stakeholders, you’ll help ensure CraftStream and its connected systems provide reliable, meaningful data that supports business decision-making.

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 aData Analyst for PCL Constructors Inc. within Edmonton NAHQ contributes to our team:

Responsibilities

• Develop and maintain Power BI reports and dashboards.
• Develop and maintain ETL processes using Boomi, Azure Synapse, and Power BI.
• Creates, maintains, and enhances analytics, data integrations, and data repository solutions.
• Investigates, troubleshoots and resolves bugs, particularly related to data quality between systems.
• Build and maintain dashboards, reports, and data visualizations that support business decision-making.
• Use SQL to manipulate, transform, and analyze data.
• Translate business requirements and architectural designs into effective technical solutions.
• Conduct iterative testing with clients and stakeholders to ensure solutions meet business needs.
• Research and recommend new data and analytics technologies, enhancements, and best practices.
• Create and maintain technical documentation and track development progress in Azure DevOps.

Qualifications

• Postsecondary degree or diploma in computer technology or a related discipline.
• 3+ years of progressive experience in a related field.
• Ability to think logically and analytically, and constructively express ideas andconcepts.
• Intermediate to advanced experience with:
  • Analytic tools and technology (Power BI)
  • Data storage technologies (Fabric, OneLake, Data Lake, SQL)
  • Data movement and transformationtechnologies (Boomi, Data Bricks, Data Factory, etc.)
  • Azure DevOps Boards and Pipelines
  • Scripting languages (SQL or Python)
• Effective communication and collaboration skills, with the ability to build stakeholder relationships and communicate complex concepts clearly.

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

Company: PCL Constructors Inc.

Primary Location: Edmonton, Alberta (Corporate)