Data Modeler

CPUS Engineering Staffing Solutions Inc.; Toronto; On-site; CAD 75,000 - 95,000; Full time

Job summary

A leading engineering staffing firm in Toronto seeks a Data Modeller to analyze and document data sources, design data models for S / 4HANA, and ensure high data quality standards. Candidates should have a Bachelor's degree in Computer Science, 5+ years of experience in data modelling, and proficiency in tools like SAP ECG and SQL. The role involves collaborating with teams to deliver optimal data structures and governance strategies.

Qualifications

• Minimum 5 years of experience in data modelling.
• Hands-on experience with SAP ECG and S / 4HANA data structures.
• Strong understanding of data governance principles.

Responsibilities

• Analyze and document existing data sources across SAP ECG.
• Design conceptual and logical data models for S / 4HANA.
• Collaborate with teams to ensure data models meet requirements.

Skills

Data modelling

Data quality management

Problem-solving

Analytical skills

Communication skills

Education

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

Tools

SAP ECG

S / 4HANA

ER / Studio

ERwin

Python

SQL

Job description

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.