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 MigrationUnderstand the commercial and financial target system data requirements (Oracle Fusion ERP)Conduct workshops with the business to agree source to target mappingsDefine the data extract requirements from the source systems and obtain business approvalDefine 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 deploymentAssist 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 exclusivelySAP Business World ERP SystemMicrosoft Navision Finance SystemSalesforceManage the technical/financial and manual transformation of the source dataData CleansingData EnhancementsData Mapping (Technical and Financial)Deliver data for load to ERPProvide 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 processPerform iterative commercial and financial reconciliations in line with project data migration cycles and cutover schedules.Manage Data DefectsAssist with the resolution of data migration defects

Status reporting – Provide weekly updates, dashboard and statistics to facilitate the exit of programme stage gatesGovernance – 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 DirectorTransformation team of Business AnalystsTransformation PMOSystems IntegratorMaster Data TeamUAT TeamAVEVA Finance Systems Team/ GIS Team/AVEVA SAP – Finance Systems Analysts IT TeamERP & Other business application user baseChange & Comms teamBAU teams

Experience Required

The individual can demonstrate:

Experience of complex Data migration projects (especially Oracle fusion ERP)Understand The Oracle Fusion Data ArchitectureStrong commercial and financial data reconciliation experience within an Oracle ERP project contextStatus report managementWorkshop organisationExperience of complex programmesStrong understanding of core finance processesExperience in a Finance/technology/software business an advantageWillingness and ability to occasionally travel internationallyExcellent documentation and communication skillsStrong organisational skills with an ability to manage multiple deadlines

Technical Knowledge:                                                         

ETLR methods for Data migration within Tier 1 heritage to Oracle ERP systemsFunctional understanding of data migration components in a large transformation programme, preferably Oracle ERPSound understanding of data migration, data cleansing techniques adoptedSound understanding of commercial and financial transformation reconciliationGood understanding of disparate source systems especially SQL Database and SAP from where the data will be extractedSound 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.