Opens LinkedIn
- Employment type
- Contract
- Experience level
- Senior · 7+ years
- Posting language
- English
- Location requirements
- Country, Vancouver, British Columbia, Canada
Job summary
Support end-to-end SAP S/4HANA ERP data migration, including SQL-based analysis, profiling, mapping, transformation, cleansing, validation, and reconciliation of master and transactional data. Collaborate with business and technical teams on requirements, testing, mock loads, cutover, issue resolution, and post-go-live support.
Job details
Job Description On behalf of our public-sector client, Affinity is seeking a Senior Technical BA (SAP Data Migration). The successful candidate will have experience in ERP data migration, data analysis, data mapping, transformation, data quality, validation, and reconciliation activities. This role requires strong hands-on experience with Syniti ADMM, SAP S/4HANA data structures, SQL, and large-scale enterprise migration programs. The ideal candidate is a self-sufficient practitioner with a proven track record supporting complex ERP transformations involving multiple sites, business units, and legacy systems. Experience within mining, manufacturing, or other asset-intensive industries is highly desirable. Responsibilities Develop and execute SQL queries for data analysis, profiling, reconciliation, and migration validation. Utilize Syniti ADMM to support migration execution, testing, and data validation. Support end-to-end ERP data migration activities for SAP S/4HANA. Gather, document, and validate business and data migration requirements. Support source-to-target mapping specifications and transformation rules. Perform data profiling, cleansing, transformation, validation, and reconciliation activities. Support migration of both master data and transactional data. Analyze and resolve complex data quality and migration issues. Analyze source system data structures and identify data transformation requirements. Collaborate with business stakeholders, data stewards, developers, functional consultants, and system integrators. Support System Integration Testing (SIT), User Acceptance Testing (UAT), mock loads, cutover activities, and post-go-live support. Facilitate workshops to define business rules, transformation requirements, and data quality remediation activities. Qualifications 7+ years of experience in ERP data migration, business analysis, data management, or related technical roles. Proven experience supporting large-scale SAP ECC and/or SAP S/4HANA transformation programs. Experience migrating large volumes of both master data and transactional data. Demonstrated experience supporting multi-site and multi-system ERP transformations. Previous experience in mining, metals, manufacturing, energy, or other asset-intensive industries. Proven experience working with System Integrators and large project teams on enterprise ERP implementations. Strong experience performing data analysis, reconciliation, and migration validation using SQL against large and complex datasets. Advanced SQL skills with the ability to write complex queries, perform data profiling, analyze source system data, validate migration results, and support reconciliation activities. Strong hands-on experience with Syniti ADMM (Advanced Data Migration and Management). Expertise in data mapping, transformation, profiling, cleansing, validation, and reconciliation. Familiarity with SAP ECC and SAP S/4HANA data structures and migration methodologies. Experience working directly with relational databases and large-scale ERP datasets. Proficiency with Microsoft Excel for data analysis and reporting. Familiarity with SAP migration tools, ETL concepts, and data quality management practices. Experience with ERP systems such as SAP, Oracle, or Microsoft Dynamic Affinity Earn Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/ About Affinity Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need. For more information on Affinity, please visit www.affinity-group.ca Job Number: 14168
What you’ll do
Support end-to-end SAP S/4HANA ERP data migration, including SQL-based analysis, profiling, mapping, transformation, cleansing, validation, and reconciliation of master and transactional data. Collaborate with business and technical teams on requirements, testing, mock loads, cutover, issue resolution, and post-go-live support.
Requirements
Requires 7+ years of ERP data migration, business analysis, or related experience, including large-scale SAP ECC or S/4HANA transformations and multi-site, multi-system programs. Candidates need advanced SQL, hands-on Syniti ADMM experience, expertise in data migration practices, and familiarity with relational databases, SAP data structures, Excel, and asset-intensive industries.
Listed skills
- SQL · Preferred
- Data analysis · Preferred
- Data Validation · Preferred
- Microsoft Excel · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Syniti ADMM
- SAP S/4HANA
- SAP ECC
- SQL
- ERP Data Migration
- Data Analysis
- Data Mapping
- Data Transformation
- Data Profiling
- Data Cleansing
- Data Quality
- Data Validation
- Data Reconciliation
- Microsoft Excel
- System Integration Testing
- User Acceptance Testing
Job areas
- Technology
- Data & Analytics
- Consulting
- Government & Public Sector
More jobs from Affinity
Senior Full Stack Software Engineer
- On-site
- BC
- Posted Nov 17, 2026
Full Stack Development Services
- Remote
- Canada
- Posted Nov 17, 2026
Project Coordinator
- On-site
- Saskatoon, SK
- Posted Nov 17, 2026
Network Engineer
- On-site
- Surrey, BC
- Posted Nov 17, 2026
