SAP BODS Developer – ETL, ECC / S4HANA, Oracle, SQL Server, HANA, Control-M, Autosys, Unix/Linux

Toronto, ON – Hybrid 2 days onsite

Long Term Contract

Key Responsibilities

Design, develop, and maintain SAP BODS ETL jobs to extract, transform, and load data from:

SAP ECC / SAP S/4HANA (IS-U, FI, CO, PM)

Metering, billing, customer information systems (CIS)

Legacy and third-party applications

Build and manage:

Dataflows, workflows, scripts, and transforms

Error-handling, logging, and recovery mechanisms

Optimize BODS jobs for performance, scalability, and reliability in batch and near–real-time processing

Implement data validation, reconciliation, and quality checks to meet regulatory and audit requirements

Support data integration for:

Gas distribution operations

Regulatory reporting (Ontario Energy Board / compliance reporting)

Finance, asset management, and customer analytics

Collaborate with:

Business analysts and data architects

SAP functional teams

Reporting and BI teams (BW, Power BI, SAP BO)

Participate in:

DLC activities (design, development, testing, deployment)

Production support, incident resolution, and performance tuning

Maintain technical documentation, job schedules, mappings, and run books

Technical Skills & Experience

Strong hands-on experience with SAP BusinessObjects Data Services (BODS)

Solid understanding of:

ETL architecture and data warehousing concepts

SAP source systems (ECC / S4HANA, IS-U preferred)

Proficiency in:

SQL (Oracle, SQL Server, HANA)

Data profiling, cleansing, and transformations

Experience with:

Control-M, Autosys, or equivalent job schedulers

Unix/Linux environments

Version control and migration practices

Familiarity with utility-industry data such as:

Meter reads & consumption data

Billing and revenue

Asset and pipeline information (preferred)

Soft Skills & Competencies

Strong analytical and problem-solving skills

Ability to work in a regulated utility environment

Excellent communication and stakeholder coordination

Detail-oriented with a focus on data accuracy and consistency

Able to support production environments with SLA accountability

Pay: $60.00-$65.00 per hour

Work Location: Hybrid remote in Toronto, ON (Toronto District)