Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Data Analyst improving PCL Construction’s CraftStream application for PCL Construction, a construction company. Developing Power BI dashboards, ETL processes, and reliable data integrations.

Responsibilities

  • Support CraftStream, an internally built application, with a focus on data, integrations, analytics, and continuous improvement
  • 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 bugs, particularly those 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
  • Work closely with business and technical stakeholders to ensure CraftStream and connected systems provide reliable, meaningful data

Requirements

  • 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 (Power BI)
  • Intermediate to advanced experience with data storage technologies (Fabric, OneLake, Data Lake, SQL)
  • Intermediate to advanced experience with data movement and transformation technologies (Boomi, Data Bricks, Data Factory, etc.)
  • Intermediate to advanced experience with Azure DevOps Boards and Pipelines
  • Intermediate to advanced experience with scripting languages (SQL or Python)
  • Effective communication and collaboration skills, with the ability to build stakeholder relationships and communicate complex concepts clearly

Benefits

  • 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

Job title

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Associate's Degree

Tech skills

AzureETLPythonSQL

Location requirements

OnsiteEdmontonCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.