Data Modeler

Rodan Energy Solutions; Toronto; On-site; CAD 90,000 - 110,000; Full time

Job summary

An energy solutions provider in Toronto is seeking a Data Modeler for a 12-month contract. The role involves analyzing data sources, designing data models for SAP S / 4HANA, and ensuring data quality during transformations. Candidates should have a bachelor's degree and over 5 years of experience in data modelling, particularly with SAP environments. The position supports a hybrid work model, combining remote and onsite work in Toronto.

Qualifications

• 5+ years of experience in data modelling, preferably within SAP environments.
• Hands-on experience with SAP ECG and S / 4HANA data structures.
• Strong understanding of data harmonization and quality management.

Responsibilities

• Analyze and document existing data sources and structures.
• Design conceptual, logical, and physical data models for S / 4HANA.
• Develop data mapping specifications and support data transformation.

Skills

Data modelling

Data quality management

Data governance

Python scripting

SQL

Analytical skills

Problem-solving

Communication

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

ER / Studio

ERwin

Job description

We are currently requesting resumes for the following position : Data Modeler

Resume Due Date : Thursday, August 21, (5 : 00PM EST)

Job ID : 25-

Number of Vacancies : 1

Level : MP4

Duration : 12 Months

Hours of work : 35 Hours per week

Location : Temp – University Ave, Toronto, Base – CHQ on rotating schedule

Work Mode : Hybrid – 2 days remote

Job Overview

• Analyze and document existing data sources and structures across SAP ECG and related systems.
• Design conceptual, logical, and physical data models for the S / 4HANA target environment, with a focus on embedding data quality and integrity in all designs.
• Develop data mapping specifications and support data transformation, cleansing, and enrichment activities, ensuring data quality is maintained throughout.
• Develop and maintain scripts or code (e.g., Python, SQL, or similar) to automate data curation, cleansing, structuring, and enrichment, with a strong emphasis on data quality controls and validation.
• Collaborate with business and technical teams to ensure data models meet business requirements, SAP best practices, and data quality standards.
• Create and maintain comprehensive data dictionaries, mapping documents, and model diagrams, incorporating data quality rules and definitions.
• Support data validation, reconciliation, and quality assurance efforts during migration.
• Advise on data governance, master data management, and data integration strategies.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 5+ years of experience in data modelling, preferably within SAP environments.
• Hands‑on experience with SAP ECG and S / 4HANA data structures.
• Strong understanding of data harmonization, data quality management, and data governance principles.
• Proficiency with data modelling tools (e.g., ER / STudio, ERwin, or similar).
• Ability to write scripts or code (such as Python, SQL, or similar languages) to automate and enforce data quality during cleansing, curation, transformation, and enrichment processes.
• Excellent analytical, problem‑solving, and communication skills.
• Experience in large‑scale ERP migrations or transformations is highly desirable.

Our client is dedicated to promoting employment equity and encourages applications from equity‑seeking communities including but not limited to : Indigenous Peoples, racialized individuals, persons with disabilities, and women. Our client aims to build a diverse team that reflects the communities it serves, enhancing its ability to meet their needs. We are committed to an inclusive and accessible work environment and invites all qualified individuals to apply, offering accommodations during the application, interview and onboarding process as needed. This effort supports our client’s long‑term strategy for equity, diversity, and inclusion.