Our client in the manufacturing sector is seeking a contract based SAP Data Consultant to support data initiatives across SAP environments and erp upgrade.

Duration: 12 months

Location: hybrid 1d - 2d/week Toronto

The ideal candidate will have a strong background in SAP data management , migration , and reporting , with expertise in SAP S4 table schema , BW objects , and modern data warehousing platforms. This role focuses on data transformation, cleansing, and migration, with an emphasis on merging master data and streamlining reporting processes.

Responsibilities:

• SAP Data Expertise: Contribute to SAP upgrade projects with a focus on data transformation and migration , not ERP system configurations. Utilize deep knowledge of SAP S4 table schemas and BW objects for data structuring and reporting.
• Data Migration & Transformation: Lead SAP data migration efforts using tools like BODS , ADMM , or equivalent, ensuring data deduplication, cleansing, and integration with other ERP systems. Oversee all layers of the transformation process to ensure data consistency and integrity.
• SAP Datasphere and CDS Views: Develop and optimize SAP Datasphere solutions. Create and manage CDS views to support operational and analytical reporting needs.
• Data Warehousing: Work on migrating SAP BW reporting to platforms like BigQuery , Snowflake , or Synapse . Collaborate with data engineering teams to establish robust data pipelines and workflows.
• Reporting and Documentation: Document and translate native SAP reports into detailed technical specifications. Classify reports into analytical vs operational categories to align with business needs. Support the integration of reporting tools like Power BI , Tableau , or Looker (Power BI experience is a plus).
• Master Data Management: Design and implement master data strategies to merge and manage data across systems, ensuring clean, reliable data for business operations.

Requirements:

• Proven experience in SAP upgrade projects , with a focus on data transformation and migration .
• Expertise in SAP S4 table schema , BW objects , and CDS views .
• Hands-on experience with SAP Datasphere and data migration tools such as BODS , ADMM , or equivalents.
• Strong understanding of data deduplication, cleansing, and master data creation.
• Proficiency in data warehousing platforms like BigQuery , Snowflake , or Synapse .
• Ability to document and classify SAP reports, translating them into actionable technical specifications.
• Experience migrating SAP BW reporting to modern data warehousing platforms.
• Familiarity with reporting tools like Power BI , Tableau , or Looker is a plus.