About the role

  • BI & Analytics Developer transforming raw data into business insights for decision-making at PCL Constructors. Focused on reporting, analytics, and ETL development.

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 PCL’s 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

Requirements

  • Bachelor's 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
  • 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

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

BI & Analytics Developer

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job