Developer, BI

Overview

Come Build Your Career at Aecon! As a Canadian leader in infrastructure development, Aecon is safely and sustainably building what matters for future generations to thrive. We lead some of the most impactful infrastructure projects of our generation, at the forefront of transformational change in transportation and energy, and partnering every day to build, connect, power, and strengthen our communities.

At Aecon, you can count on a focus on people and impact. We invest in our people just as they invest in us, with a commitment to safety, integrity, accountability, and inclusive work environments.

What is the Opportunity?

As the BI Developer you will design, build, and optimize enterprise data and reporting environments. In this role, you will collaborate with business stakeholders, data engineers, and IT partners to translate organizational needs into scalable, high-quality BI and analytics solutions. You will be instrumental in developing modern data architectures, ensuring data accuracy and compliance, and delivering insights that drive informed decision-making across the organization.

What You’ll Do Here

• Design and develop interactive dashboards, reports, and visualizations using SAP toolsets and modern BI platforms.
• Translate business requirements into detailed technical specifications and solution designs.
• Ensure all reports and dashboards are accurate, timely, and actionable, following best practices in BI development.
• Build, optimize, and maintain ETL (Extract, Transform, Load) processes to support enterprise analytics.
• Cleanse and transform raw data into structured, usable formats; integrate data from multiple systems.
• Design and maintain data models to support analytical and reporting needs.
• Develop and manage data warehouses and data marts, ensuring performance and scalability.
• Validate data quality, accuracy, and consistency across systems and pipelines.
• Perform unit testing, troubleshoot technical issues, and conduct root cause analysis.
• Monitor system performance, identify bottlenecks, and work with cross-functional teams to resolve issues.
• Collaborate with business stakeholders to gather requirements, clarify needs, and provide follow-ups.
• Work closely with data engineers, analysts, and IT teams to deliver cohesive data solutions.
• Present insights and findings to both technical and non-technical audiences.
• Ensure data privacy, compliance, and audit readiness through robust governance practices.
• Implement role-based access controls and maintain data security protocols.
• Support and promote data governance practices across the extended team.
• Remain up to date with emerging tools and technologies and contribute to architectural improvements.

What You Bring To The Team

Reason for vacancy : New position

The expected salary range for this opportunity is $81,500-$100,000

Aecon fosters diversity, inclusion and belonging within and across our organization. We welcome all to apply including, women, visible minorities, Indigenous peoples, persons with disabilities, and persons of any sexual orientation or gender identity.

We are committed to adhering to the objectives and requirements outlined in the Accessible Canada Act (ACA), and to meeting the accessibility needs of persons with disabilities in a timely manner. Through the implementation of the requirements of the ACA and its applicable regulations, appropriate accommodations will be provided upon request throughout the interview and hiring process.

As part of our commitment to fair and transparent hiring practices, Aecon may use artificial intelligence (AI) tools to assist in screening and reviewing candidates. These tools are applied responsibly and in accordance with applicable privacy laws and Aecon’s AI Usage Policy. All final decisions are made by qualified Aecon team members.

#J-18808-Ljbffr