Data Migration Reconciliation Lead

Cambridge, England, United Kingdom

12/9/2024

AVEVA is creating software trusted by over 90% of leading industrial companies.

Data Migration Reconciliation Lead

Job Purpose

Lead functional consultant responsible for extraction, transformation, load and reconciliation (ETLR) of commercial and financial data required to facilitate the delivery of the Finance Transformation programme, primarily into Oracle Fusion ERP but also other business applications.

Dimensions

Drive, facilitate and control ETLR lifecycles of data migration from heritage systems into Oracle Fusion ERP and influencing stakeholders as required.

Principal Accountabilities

• Agree and define the scope of the Data Migration
• Understand the commercial and financial target system data requirements (Oracle Fusion ERP)
• Conduct workshops with the business to agree source to target mappings
• Define the data extract requirements from the source systems and obtain business approval
• Define the `Transformation’ requirements and ensure that documentation is completed.
• Define the scope of data migration – Master, Standing and Transactional Data.
• Perform commercial and financial reconciliations on behalf of the business and obtain approval for deployment
• Assist with the resolution of data migration defects
  
  

• Manage and work with the technical teams to extract and validate the required data from source systems primarily but not exclusively
• SAP Business World ERP System
• Microsoft Navision Finance System
• Salesforce
  
  

• Manage the technical/financial and manual transformation of the source data
• Data Cleansing
• Data Enhancements
• Data Mapping (Technical and Financial)
  
  

• Deliver data for load to ERP
• Provide the Oracle Implementation Partner (CTS) with the data sets required for Load to the new Oracle Fusion Cloud ERP application)
• Manage the Oracle Implementation Partner (CTS) on technical reconciliation of the ETLR process
• Perform iterative commercial and financial reconciliations in line with project data migration cycles and cutover schedules.
  
  

Manage Data Defects

• Assist with the resolution of data migration defects
• Status reporting – Provide weekly updates, dashboard and statistics to facilitate the exit of programme stage gates
• Governance – Ensure business approval at all stages is obtained and evidenced to the programme PMO office.
• Business / Programme Liaison – Work closely with the Transformation Leads, and Business Readiness teams to ensure programme success.
  
  

Important Working Relationships

• Transformation Implementation Director
• Transformation team of Business Analysts
• Transformation PMO
• Systems Integrator
• Master Data Team
• UAT Team
• AVEVA Finance Systems Team/ GIS Team/
• AVEVA SAP – Finance Systems Analysts IT Team
• ERP & Other business application user base
• Change & Comms team
• BAU teams
  
  

Experience Required

The individual can demonstrate:

• Experience of complex Data migration projects (especially Oracle fusion ERP)
• Understand The Oracle Fusion Data Architecture
• Strong commercial and financial data reconciliation experience within an Oracle ERP project context
• Status report management
• Workshop organisation
• Experience of complex programmes
• Strong understanding of core finance processes
• Experience in a Finance/technology/software business an advantage
• Willingness and ability to occasionally travel internationally
• Excellent documentation and communication skills
• Strong organisational skills with an ability to manage multiple deadlines
  
  

Technical Knowledge:

• ETLR methods for Data migration within Tier 1 heritage to Oracle ERP systems
• Functional understanding of data migration components in a large transformation programme, preferably Oracle ERP
• Sound understanding of data migration, data cleansing techniques adopted
• Sound understanding of commercial and financial transformation reconciliation
• Good understanding of disparate source systems especially SQL Database and SAP from where the data will be extracted
• Sound understanding of middle-ware tools
  
  

UK Benefits include:

Flexible benefits fund, emergency leave days, adoption leave, 28 days annual leave (plus bank holidays), pension, life cover, private medical insurance, parental leave, education assistance program.

It’s possible we’re hiring for this position in multiple countries, in which case the above benefits apply to the primary location. Specific benefits vary by country, but our packages are similarly comprehensive.

Find out more: aveva.com/en/about/careers/benefits/

Hybrid working

By default, employees are expected to be in their local AVEVA office three days a week, but some positions are fully office-based. Roles supporting particular customers or markets are sometimes remote.

Hiring process

Interested? Great! Get started by submitting your cover letter and CV through our application portal. AVEVA is committed to recruiting and retaining people with disabilities. Please let us know in advance if you need reasonable support during your application process.

Find out more: aveva.com/en/about/careers/hiring-process

About AVEVA

AVEVA is a global leader in industrial software with more than 6,500 employees in over 40 countries. Our cutting-edge solutions are used by thousands of enterprises to deliver the essentials of life – such as energy, infrastructure, chemicals, and minerals – safely, efficiently, and more sustainably.

We are committed to embedding sustainability and inclusion into our operations, our culture, and our core business strategy. Learn more about how we are progressing against our ambitious 2030 targets: sustainability-report.aveva.com/

Find out more: aveva.com/en/about/careers/

AVEVA requires all successful applicants to undergo and pass a drug screening and comprehensive background check before they start employment. Background checks will be conducted in accordance with local laws and may, subject to those laws, include proof of educational attainment, employment history verification, proof of work authorization, criminal records, identity verification, credit check. Certain positions dealing with sensitive and/or third-party personal data may involve additional background check criteria.

AVEVA is an Equal Opportunity Employer. We are committed to being an exemplary employer with an inclusive culture, developing a workplace environment where all our employees are treated with dignity and respect. We value diversity and the expertise that people from different backgrounds bring to our business. AVEVA provides reasonable accommodation to applicants with disabilities where appropriate. If you need reasonable accommodation for any part of the application and hiring process, please notify your recruiter. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.