Job Description

Title:  Data Modeler

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

Number of Vacancies: 1

Level:  MP4

Duration:  12 Months

Hours of work:  35

Location:  

Temp – 700 University Av (Hybrid – 2 days remote)  

Base – From Oct, Oshawa on rotating schedule

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.