Senior SAP Data & Analytics Engineer

Aecon Group Inc.; Toronto; On-site; CAD 135,000 - 156,000; Full time

Job summary

Aecon Group Inc. is seeking a Sr BI Developer to design, develop and implement enterprise data solutions using SAP Datasphere. The role focuses on data modeling, security governance, and scalable data products across SAP and non-SAP platforms.

You will collaborate with stakeholders to define KPIs, build semantic layers, and optimize data pipelines for real-time and batch analytics, enabling trusted insights for critical infrastructure projects.

Qualifications

• 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).

Responsibilities

• 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.
• Ingest data from ECC or S/4 HANA into Datasphere environment.
• 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 (SAC).
• 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.
• Prepare documentation, design artifacts, and knowledge-transfer materials.

Skills

SQL & Data Modeling

Stakeholder Collaboration

ETL/ELT concepts

Data Architecture

Education

Bachelor's degree in Computer Science/Information Systems/Data Engineering

Tools

SAP Datasphere

SAP HANA

SAP S/4HANA

SAP Analytics Cloud (SAC)

Job description

Aecon Group Inc. is seeking a Sr BI Developer to design, develop and implement enterprise data solutions using SAP Datasphere. The role focuses on data modeling, security governance, and scalable data products across SAP and non-SAP platforms.

You will collaborate with stakeholders to define KPIs, build semantic layers, and optimize data pipelines for real-time and batch analytics, enabling trusted insights for critical infrastructure projects.