BI & Analytics Developer
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 BI & Analytics Developer for PCL Constructors Edmonton Alberta (Corporate) youll have the opportunity to transform raw data into business insights that support decision-making across all levels of the organization. The primary focus of this role is the design development and implementation of reporting and analytical content using data from PCLs business applications. The ideal candidate possesses hands-on experience in reporting and analytics development ETL and data modeling.
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 aBI & Analytics Developer for PCL Constructors Inc. within Edmonton NAHQ contributes to our team:
Responsibilities
- Translate business needs to design develop and maintain production reports and dashboards
- Acquire data from a variety of structured and unstructured data sources
- Design and develop business data models to support self-service BI analytics and AI
- Develop and maintain ETL/ELT data pipelines and processes
- Create and maintain technical documentation
- Define test plans and execute test cases to ensure analytics content processes meet quality assurance standards
- Ensure data solutions follow and meet PCLs data governance and security policies
- Liaise with business technology and support teams to ensure business requirements are met
- Prepare and structure business data to support AI use-cases
- Develop Fabric Data Agents to enable AI-driven interaction with PCL business data
Qualifications
- Bachelors degree or diploma in computer science (or equivalent education)
- Demonstrated experience or certification in Microsoft Fabric Analytics Engineer Associate (DP-600) and/or Microsoft Fabric Data Engineer Associate DP-700
- Extensive hands-on experience with data visualization tools such as Microsoft Power BI is preferred
- Experience in Fabric capacity management and resource optimization
- Extensive hands-on experience with data development in Microsoft Fabric
- Solid understanding of data modeling and relational database design and implementation techniques
- Experience in UI/UX development as it applies to dashboard and report design
- Excellent problem-solving and data-analysis skills
- Experience in the complete software development lifecycle (SDLC) including requirements analysis design development QA maintenance and CI/CD and version control tools
- Effective communication and writing skills necessary to effectively lead technical discussions and information-gathering sessions
- In addition to the technical skills listed above the ideal candidate will possess the following qualities:
- Positive can-do attitude enthusiastic self-motivated and able to manage multiple development projects simultaneously
- Ability to work in a fast-paced environment be flexible stay organized and maintain attention to detail and accuracy
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: BI & Analytics Developer
Requisition ID: 11998
Required Experience:
IC