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.