Job Information

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 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
  
  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. Empowering you with pioneering tech AVEVA is a global leader in industrial software. 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're the first software business in the world to have our sustainability targets validated by the SBTi, and we've been recognized for the transparency and ambition of our commitment to diversity, equity, and inclusion. We've also recently been named as one of the world's most innovative companies. If you're a curious and collaborative person who wants to make a big impact through technology, then we want to hear from you! Find out more at AVEVA Careers (https://www.aveva.com/en/about/careers/) .