Sr. Developer, BI

Come Build Your Career at Aecon!

Aecon delivers some of the most complex and impactful infrastructure projects — from transformative transportation networks to critical energy, industrial and nuclear programs. The projects we build connect communities and power future generations. With deep roots in North America and a strong footprint internationally, Aecon brings global expertise and proudly serves public and private sector clients through its Construction and Concessions segment.

Safety Always is not only our #1 core value – it is the standard that anchors our culture. We believe the most ambitious projects deserve the most committed people. At Aecon, you won’t just build your career — you’ll help build what matters to enable future generations to thrive.

At Aecon, you can count on:

• Safety Always. Our number one core value. The safety of our people, projects, partners, and stakeholders is our priority focus – today and always.
• Integrity. We lead by example, with humility and courage.
• Accountability. We’re passionate about delivering on our commitments.
• Inclusion. We provide opportunities where people feel valued, supported, and empowered to contribute fully.

We deliver infrastructure with purpose, and our people are at the heart of everything we do. Aecon employees are incredibly proud to build some of the most impactful infrastructure of this generation – we call it Aecon Proud.

At Aecon we:

• Ensure you and your family receive the services and benefits needed to support your mental, emotional, and physical well-being.
• Are intentional when it comes to investing in your development. We help you build your career and advance your skills through our Aecon University, tuition reimbursement, and Leadership Programs.
• Are committed to creating work environments focused on mutual respect, teamwork, collaboration, and new ideas, through meaningful initiatives, training, partnerships with Veteran groups, our Aecon Women in Trades and diversity programs, as well as our Employee Resource Groups (ERGs), to ensure we are building with top talent and harnessing our collective strengths within every aspect of our culture.
• Operate responsibly by managing risk, safety, and environmental considerations across all our projects and surrounding communities.

Our success is built on the passion, expertise, and dedication of our people. Together, we embrace strong execution, innovation, and continuous improvement — values that come to life through the unique talents and collaborative spirit of every team member. If you’re inspired to make a difference through future-building projects, join our best-in-class team.

What is the Opportunity?

The Sr. BI Developer is responsible for designing, developing, and implementing enterprise data solutions using SAP Datasphere. This role supports data integration, modeling, virtualization, analytics, and governance initiatives by enabling seamless access to data across SAP and non-SAP platforms. The consultant works closely with business stakeholders, architects, and analytics teams to deliver scalable and secure data products.

What You'll Do Here:

Data Modeling & Architecture

• Design and develop Datasphere models including dimensions, analytical datasets, and business entities.
• Build semantic layers and consumption models for reporting and analytics.
• Implement data virtualization and zero-copy architectures where appropriate.
• Rebuild existing Hana side car objects into Datasphere system.
• Ingest data from ECC or S/4 HANA into Datasphere environment.

Data Integration

• Integrate SAP S/4HANA, SAP HANA, Databricks, and non-SAP data sources.
• Develop and maintain replication flows, data flows, and data pipelines.
• Support real-time and batch data integration strategies.

Analytics Enablement

• Create and optimize data models for SAP Analytics Cloud (SAC) and other reporting platforms.
• Partner with business teams to define KPIs, metrics, and reporting requirements.
• Support self-service analytics and data product development.

Governance & Security

• Implement role-based and attribute-based security.
• Ensure compliance with enterprise data governance standards.
• Maintain metadata, lineage, and catalog integration.

Performance Optimization

• Monitor and optimize query performance and data processing workloads.
• Troubleshoot integration and modeling issues.
• Support capacity planning and environment sizing.

Stakeholder Collaboration

• Gather business requirements and translate them into technical solutions.
• Provide technical guidance and best practices for SAP data platforms.
• Prepare documentation, design artifacts, and knowledge-transfer materials.

What You Bring to the Team:

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field.
• 7+ years of experience in SAP Data & Analytics solutions.
• Hands-on experience with SAP Datasphere.
• Strong SQL and data modeling skills.
• Experience with SAP HANA, SAP S/4HANA, or SAP BTP.
• Knowledge of ETL/ELT concepts and enterprise data architecture.
• Experience with SAP Analytics Cloud (SAC).

Preferred Qualifications

• Experience with Microsoft Fabric, Databricks, Snowflake, or Azure data services.
• Knowledge of SAP Business Data Cloud (BDC).
• Experience with SAP Data Intelligence, SDI, CPI-DS, or equivalent integration tools.
• Understanding of data governance, metadata management, and data lineage solutions.

Reason for vacancy: New

The expected salary range for this role is $95,000-$110,000 per year

Individual pay is determined based on several factors, including work location, education, experience, unique skills and job conditions. Other considerations may includecertifications, specialized training, and the complexity or scope of the role.

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.