About this role
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'll support 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 valueAnnual discretionary performance bonusesRRSP, TFSA, Pension Contribution OptionsFlexible medical, dental and vision benefitsPrescription drug coverage and virtual care servicesLife, AD&D and disability insurancePaid parental leave and family care supportHealth and lifestyle spending account optionsMental health and wellness support, including Employee Assistance ProgramsCareer growth pathways, leadership development and mentorship programsAccess to world-class training through PCL's College of Construction and professional development coursesOngoing opportunities to learn new skills, explore different roles and grow your career across sectors and regionsHere's how a Data Analyst for PCL Constructors Inc. within Edmonton NAHQ contributes to our team: ResponsibilitiesDevelop 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.QualificationsPostsecondary 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)Data storage technologies (Fabric, OneLake, Data Lake, SQL)Data movement and transformation technologies (Boomi, Data Bricks, Data Factory, etc.)Azure DevOps Boards and PipelinesScripting 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 HerePCL projects are where life happens, where communities connect, careers begin, and progress is made. Regardless of the type of project, we are building something bigge