Aecon Group Inc.
North American construction and infrastructure development company delivering civil, transport, nuclear, utility and industrial projects.
Design, develop, and maintain BI solutions using SAP and Power BI platforms.
12 hours ago
$81,500 - $100,000
Intermediate (4-7 years), Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
Toronto, Ontario, Canada
Office Full-Time
Company Size
9,427 Employees
Service Specialisms
Construction services
Project Management
Engineering
Design
Technical Services
General Contractor
Property Development
Turnkey
Sector Specialisms
Nuclear
Civil
Industrial
Urban Transportation
Utility
Electrical Transmission and Distribution
Renewables
Pipeline Distribution
Role
Description
dashboard design
etl development
data modeling
data warehouse
data governance
requirements gathering
The Business Intelligence Developer role will design, build, and optimize enterprise data and reporting environments, collaborating with business stakeholders, data engineers, and IT partners to deliver high‑quality BI and analytics solutions that drive informed decision‑making.
- 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 reports and dashboards are accurate, timely, and actionable, following BI best practices.
- Build, optimize, and maintain ETL 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 collaborate to resolve issues.
- Gather requirements from business stakeholders and provide follow‑ups.
- Collaborate with data engineers, analysts, and IT teams to deliver cohesive data solutions.
- Present insights and findings to 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.
- Stay current with emerging tools and technologies (including BDC/BTP) and contribute to architectural improvements.
Requirements
computer science
sap hana
power bi
sql
data warehousing
collaboration
- University degree in Computer Science, Information Systems, or a related field.
- Minimum 5 years of experience developing BI, analytics, and data solutions with advanced SAP proficiency.
- Expertise in SAP HANA modeling, performance optimization, and data architecture design.
- Proficiency in SAP BDC and SAP Datasphere building scalable data solutions.
- Strong background in SAP BusinessObjects tools (SAP Analytics Cloud, Web Intelligence, IDT).
- Experience creating interactive Power BI dashboards.
- Deep understanding of data warehousing concepts, architecture, and ETL development.
- Advanced SQL skills, including query optimization, stored procedures, and database design.
- Proven track record in BI solution development, system migration, and operational maintenance.
- Ability to perform end‑to‑end root cause analysis and technical troubleshooting.
- Knowledge of data privacy, security, redundancy, and compliance guidelines.
- Familiarity with software development methodologies and SDLC processes.
- Relevant certifications in development languages or SAP technologies (asset).
- Excellent collaboration skills with business stakeholders, analysts, data engineers, and IT teams.
Benefits
We invest in our people by providing mental, emotional, and physical well‑being services, career growth through Aecon University and leadership programs, and inclusive work environments supported by equity, diversity, and inclusion initiatives such as Women in Trades, Diversity in Trades, and employee resource groups.
This new position offers a salary range of $81,500–$100,000 and reflects Aecon’s commitment to diversity, inclusion, accessibility, and fair hiring practices, including the responsible use of AI tools in candidate screening.
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
C$9.7B Backlog
Record Project Orders
Signifies a substantial and growing pipeline of construction and infrastructure projects.
C$150M Investment
Utilities Expansion Fund
Strategic financial backing to bolster and expand utilities infrastructure development.
- From humble beginnings in plumbing and gas fitting, the company has evolved into a leading infrastructure developer, with operations rooted in Hamilton since its founding in 1877.
- Offers comprehensive construction services across civil infrastructure, urban transit, nuclear power, utilities, and industrial works.
- Through its Concessions arm, the company specializes in private-public partnerships (P3) for global infrastructure development, emphasizing integrated delivery from planning to long-term operations.
- Delivers iconic projects including the CN Tower, Vancouver SkyTrain, Montreal-Trudeau Airport, Gordie Howe Bridge, and major nuclear refurbishments.
- Expanding into next-generation energy solutions with Canada’s largest battery storage initiative and leadership in small modular reactor development.
- While maintaining a strong presence in Canada, the company also caters to North American markets and selectively engages in international concessions.
- Demonstrates expertise in complex mega-projects through seamless integration of engineering, construction, financing, and operations.
Culture + Values
- Safety First - Ensuring a safe, healthy work environment and fostering a 'zero injury' culture.
- Trust and Candour - Conducting ourselves professionally, with candour, respect, and integrity.
- Passion for Excellence - Being pace-setting and innovative, always striving to find a better way, and doing it right the first time - every time.
- A People Focused, Learning Culture - Developing the best leaders and realizing the full potential of our people. Learning is core - we never stop trying to improve.
- Results Oriented - Having a 'do whatever it takes' attitude. Empowered and entrepreneurial operations within a common framework of values, strategies, and key processes.
Environment + Sustainability
30% CO₂ Reduction
CO₂ Emissions Intensity Target
Aims to reduce CO₂ emissions intensity (Scopes 1 & 2) by 30% by 2030 compared to 2020 levels.
59% Revenue from Sustainability
Revenue Linked to Sustainability Projects
59% of 2024 revenue is tied to projects focused on climate change mitigation, energy transition, renewable energy, and water management.
78% Backlog Sustainability
Backlog Linked to Sustainability
78% of the company's backlog is connected to sustainability-related projects, highlighting a strong focus on environmental initiatives.
34% Early Target Achievement
Early Achievement of 2030 Target
Surpassed the 2030 target for Scope 1 & 2 emissions intensity reduction by achieving a 34% cumulative reduction by 2024, relative to revenue.
- Net‑zero target for Scopes 1, 2 & 3 by 2050
- 20% cumulative Scope 1 & 2 GHG reduction by end of 2023 (vs 2020)
- Projects include grid‑scale SMR, nuclear refurbishments, Oneida Energy Storage, Site C hydroelectric, Réseau express métropolitain, Surrey Langley SkyTrain
- Approved science‑based near/long‑term emissions targets; SBTi‑verified net‑zero by 2050
- Envision‑qualified company; offers employee Envision certification
- Silver Certification from Progressive Aboriginal Relations; procured $127 M Indigenous goods/services in 2024
Inclusion & Diversity
$275M Procured
Indigenous Procurement
Significant investments in Indigenous goods and services were made in 2023 and 2024.
0.89 Injury Frequency
Safety Metrics
Improved workplace safety with a low Total Recordable Injury Frequency in 2023.
- Inaugural Reconciliation Action Plan established
- Silver Certification in Progressive Aboriginal Relations
- Established three Indigenous‑led joint ventures
- Expanded Aecon Women in Trades program (added nuclear cohort)
- Inclusion stated as core value alongside Safety Always, Integrity and Accountability
- Committed to inclusion through equitable opportunities, Equity, Diversity & Inclusion training, Women in Trades and Diversity in Trades programs, and Employee Resource Groups