BI & Analytics Developer

Edmonton, AB
Permanent
Full-time

20 days ago

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 BI & Analytics Developer for PCL Constructors Inc. in Edmonton, Alberta (Corporate), you'll 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 PCL's 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. 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 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

Here's how a BI & 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 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

Qualifications

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
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 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 bigger: a future that's 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 everyone's 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 DeveloperRequisition ID: 11998

PCL Construction

Apply Now