Data Analyst
Job Summary
The future you want is within reach. Lets build it together.
At PCL Constructors Inc. part of the PCL Family of Companies (PCL) we dont 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.
Were 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 Edmonton Alberta (Corporate) youllsupport CraftStream an internally built application with a focus on data integrations analytics and continuous improvement. Youll 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 youll 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. PCLs 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 PCLs College of Construction and professional development courses
- Ongoing opportunities to learn new skills explore different roles and grow your career across sectors and regions
Heres how aData Analyst for PCL Constructors Inc. within Edmonton NAHQ contributes to our team:
- 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.
- 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 thats 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 everyones needs are different if you require accommodation during the application process please contact 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)
Job Title: Data Analyst
Requisition ID: 14865
Required Experience:
IC
About Company
Build with PCL, a 100% employee-owned construction company providing exceptional services across Canada, the U.S., Caribbean, and Australia. We specialize in civil infrastructure, industrial, and building projects.