Position Title:  Developer, BI

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:

• Safety Always. Our number one core value. If we can’t do it safely, we don’t do it at all.
• Integrity. We lead by example, with humility and courage.
• Accountability. We’re passionate about delivering on our commitments.
• Inclusion. We provide equitable opportunities for everyone.

We lead the infrastructure industry with purpose, and our people are at the heart of everything we do. So, we invest in our people, just like they invest in us! 

At Aecon we:

• Ensure you and your family receive the services needed to support your mental, emotional, and physical well-being.
• Believe in helping you build your career through our Aecon University and Leadership Programs.
• Are committed to supporting and investing in inclusive work environments, through initiatives like Equity, Diversity & Inclusion training, our Aecon Women in Trades and Aecon Diversity in Trades programs, and our Employee Resource Groups (ERGs) to ensure we are building inclusion into every aspect of our culture at Aecon.
• Are a leader in sustainable construction. With a strong commitment to operating responsibly by minimizing our impact on the environment and surrounding communities.

Our business success relies on strong execution and continuous improvement – driven by the diversity, expertise and teamwork of our people. We’re always searching the globe for innovative, collaborative minds to join our best-in-class Aecon community!

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 (including BDC/BTP) and contribute to architectural improvements.

What You Bring to the Team:

• University degree in Computer Science, Information Systems, or a related field.
• Minimum 5 years of experience developing BI, analytics, and data solutions, with advanced proficiency in SAP technologies.
• Proven experience in SAP HANA modeling and development, including performance optimization and data architecture design.
• Proficient in SAP BDC and SAP Datasphere, with hands-on experience building scalable data solutions.
• Strong background in SAP BusinessObjects tools, including SAP Analytics Cloud (SAC), Web Intelligence (WebI), and Information Design Tool (IDT).
• Extensive experience developing interactive and visually compelling Power BI dashboards.
• Deep understanding of data warehousing concepts, architecture, and ETL development across structured and unstructured data sources.
• Advanced SQL skills, including query optimization, stored procedures, and database design.
• Demonstrated success with BI solution development, system migration, and ongoing operational maintenance.
• Experience performing full end-to-end root cause analysis, including debugging and technical troubleshooting.
• Strong understanding of data privacy, data security, data redundancy, and compliance guidelines.
• Knowledge of software development methodologies and SDLC processes.
• Certifications in relevant development languages or SAP technologies considered an asset.
• Excellent collaboration skills with the ability to work closely with business stakeholders, analysts, data engineers, and IT teams to accurately define requirements and deliver effective solutions.

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.