Data Analyst

About The Company

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, meaning 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.

About The Role

As a Data Analyst for PCL Constructors Inc. in Edmonton, Alberta (Corporate), you will support CraftStream, an internally built application, with a focus on data, integrations, analytics, and continuous improvement. You will 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 will help ensure CraftStream and its connected systems provide reliable, meaningful data that supports business decision-making. This role offers the opportunity to contribute to innovative data solutions that enhance operational efficiency and strategic insights within the organization.

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 analytic tools and technology, including Power BI.
• Experience with data storage technologies such as Fabric, OneLake, Data Lake, and SQL.
• Proficiency in data movement and transformation technologies such as Boomi, Data Bricks, and Data Factory.
• Familiarity with Azure DevOps Boards and Pipelines.
• Experience with scripting languages such as SQL or Python.
• Effective communication and collaboration skills, with the ability to build stakeholder relationships and communicate complex concepts clearly.
  
  

Responsibilities

• Develop and maintain Power BI reports and dashboards to support business decision-making.
• 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 bugs, particularly related to data quality between systems.
• Use SQL to manipulate, transform, and analyze data effectively.
• 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.
  
  

Benefits

• Employee ownership opportunities that build long-term value.
• Annual discretionary performance bonuses.
• RRSP, TFSA, and 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.
  
  

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

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.