About the role

Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.

Responsibilities

Design and develop SAP 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
Ingest data from ECC or S/4 HANA into Datasphere
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
Create and optimize data models for SAP Analytics Cloud and other reporting platforms
Partner with business teams to define KPIs, metrics, and reporting requirements
Support self-service analytics and data product development
Implement role-based and attribute-based security
Ensure compliance with enterprise data governance standards
Maintain metadata, lineage, and catalog integration
Monitor and optimize query performance and data processing workloads
Troubleshoot integration and modeling issues
Support capacity planning and environment sizing
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

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: Experience with Microsoft Fabric, Databricks, Snowflake, or Azure data services
Preferred: Knowledge of SAP Business Data Cloud (BDC)
Preferred: Experience with SAP Data Intelligence, SDI, CPI-DS, or equivalent integration tools
Preferred: Understanding of data governance, metadata management, and data lineage solutions

Mental, emotional, and physical well-being services and benefits for employees and families
Aecon University
Tuition reimbursement
Leadership Programs
Training and development initiatives
Employee Resource Groups (ERGs)
Diversity programs
Partnerships with Veteran groups
Accessibility accommodations throughout the interview and hiring process