Business Analyst - Data Mapping

PwC Canada; Montreal; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

PwC Canada in Montreal seeks a Data Mapping Business Analyst to validate and define matching rules between source systems and Oracle Fusion Cloud data structures. You will contribute to mapping matrices and ensure transformation rules meet finance and SCM needs.

You bring a bachelor's degree and at least 3 years in data management or ETL, with knowledge of data mapping tools and ERP data structures. Collaboration across multi-team environments is essential.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.
• Minimum of 3 years of experience in data management, data analysis, or ETL.
• Knowledge of data mapping and transformation tools.

Responsibilities

• Analyze data structures from source systems.
• Contribute to the development of mapping matrices for assigned domains.
• Document data transformation, cleansing, and deduplication rules.
• Validate mapping rules with Finance and SCM business teams.
• Identify data matching gaps and propose resolution rules.
• Collaborate with interface and data conversion leads to ensure mapping rule consistency.
• Participate in validation of mapped data during conversion exercises.

Skills

Data mapping

Data analysis

ETL

ERP data

Education

Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field

Tools

ETL tools

Data mapping tools

Job description

Work Model: Hybrid (2 days onsite, 3 days remote)

Duration: 12 months

Start Date: Approximately 2 weeks after request issuance

Work Hours: 8:30 AM to 4:30 PM

Language: French and English

Business Analyst – Data Mapping

The Data Mapping Business Analyst supports the definition and validation of matching rules between source system data and the target Oracle Fusion Cloud data structure. The analyst contributes to the development of mapping matrices and ensures the quality of transformation rules used for data conversions and interfaces.

Specific Responsibilities

• Analyze data structures from source systems.
• Contribute to the development of mapping matrices for assigned domains.
• Document data transformation, cleansing, and deduplication rules.
• Validate mapping rules with Finance and Supply Chain Management (SCM) business teams.
• Identify data matching gaps and propose resolution rules.
• Collaborate with interface and data conversion leads to ensure consistency of mapping rules.
• Participate in the validation of mapped data during conversion exercises.

Education and Experience Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.
• Minimum of 3 years of experience in data management, data analysis, or ETL.
• Knowledge of data mapping and transformation tools.

Assets

• Knowledge of ERP data structures.
• Experience working on ERP data migration or conversion projects.
• Strong analytical skills and attention to detail in documenting mapping rules.
• Ability to communicate complex rules to non-technical teams.
• Strong collaboration skills in a multi-team environment.