BI and Analytics Developer

The future you want is within reach.

At PCL, we build the places where life happens and find camaraderie in the process. We're a community of builders committed to building better communities. That's why we're always looking ahead, and not just to the next project or what's next in our industry.

We're also looking at what's next for you and how we can help you build a career you're proud of. PCL’s Business Technology group’s EIS (Enterprise Information & Security) team enables measurable and material business outcomes using a valuable asset: data. The EIS team is seeking a BI & Analytics Developer at our North American Headquarters, located in Edmonton, Alberta. The BI & Analytics Developer is a data expert who transforms 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. This is an hourly, contract position.

Here's how a(n) BI and Analytics Developer for our Edmonton NAHQ office 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 and analytics
• Develop and maintain ETL/ELT processes
• Create and maintain technical documentation
• Define test plans and execute test cases to ensure BI content processes meet quality assurance standards
• Ensure BI content follows and meets PCL’s data governance and security policies
• Liaise with business, technology, and support teams to ensure business requirements are met

Qualifications

• Bachelor's degree or diploma in computer science (or equivalent education)
• The candidate has 3+ years of design and development experience in business intelligence, data management, and data modeling
• Extensive hands-on experience with data visualization tools such as Microsoft Power BI is preferred
• Extensive hands-on experience with ETL development
• 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:
  o Positive, can-do attitude, enthusiastic, self-motivated, and able to manage multiple development projects simultaneously
  o Ability to work in a fast-paced environment, be flexible, stay organized, and maintain attention to detail and accuracy

PCL is an innovative, employee-owned company comprised of people who find passion in their profession and take pride in doing great work every day. Our work powers the infrastructure and utilities that are essential to daily life and our projects are the scene of vacations, careers, education and healing. We are consistently ranked among the best companies to work for because we are committed to supporting and developing our teams.

The PCL Companies celebrate diversity and are proud to be an equal opportunity employer. We are committed to creating equitable opportunities and an inclusive environment for all employees and applicants. We make employment-related decisions without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, age, disability or veteran status.

PCL combines numerous pay and benefit strategies to provide a comprehensive and competitive total rewards package. Any salary range displayed by a job board is an estimate. Your salary, which considers your unique qualifications and experience, is just one component of the robust total rewards you'll enjoy at PCL. This may include an employee share purchase offering, discretionary annual performance bonus, comprehensive benefits and wellness programs, retirement plan plus matching, and career development programs.

Should you require an accommodation during the application process, please contact us at careers@pcl.com with the position and location you are interested in.

Together, we can build success and a better future. Let’s get started!

Employee Status: Contractual Full-Time

Company: PCL Constructors Inc.

Primary Location: Edmonton, Alberta (Corporate)

Job: BI and Analytics Developer

Requisition: 7011