Data Modeler

Morson Talent (Canada & USA); Pickering; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

A recruitment agency is looking for a Data Modeler to analyze data sources and design data models for SAP S/4HANA. The role requires at least 5 years of experience in data modelling and proficiency in SQL and Python. The position offers a hybrid work environment, involving 2 days remote per week and a contract duration of 12 months with a pay rate of up to $90/hr.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 5+ years of experience in data modelling, preferably within SAP environments.
• Strong understanding of data harmonization, quality management, and governance.

Responsibilities

• Analyze and document existing data sources and structures.
• Design data models for SAP S/4HANA with a focus on data quality.
• Develop data mapping specifications and support data transformation.

Skills

Data modelling

SAP S/4HANA

Data quality management

Problem-solving

Communication

Education

Bachelor's degree in Computer Science

Tools

ER/STudio

ERwin

SQL

Python

Job description

Title: Data Modeler

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

Number of Vacancies

Level

MP4, upto $90 / hr INC

Duration

12 Months

Hours of work / 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.