ERP/EPM Data Conversion Analyst
Location: Brampton,ON
Mode: 4 days a week
The Data Conversion Analyst is responsible for extracting, profiling, transforming, validating, and loading legacy data into the target ERP/EPM platforms, working with the business and SI to deliver accurate, reconciled data through mock, cutover, and production conversions through to formal sign-off.
Responsibilities include:
- Collaborate with business stakeholders and SI to define conversion scope, data requirements, mapping rules, and timelines, and to resolve data questions and decisions
- Extract data from legacy ERP/EPM and related source systems, following approved data governance and security standards
- Perform data profiling and quality assessments to identify gaps, duplicates, and inconsistencies, and coordinate cleansing with data owners
- Transform and convert data to meet target Oracle ERP Cloud Fusion and EPM load requirements, using out-of-the-box load templates and tools wherever possible
- Perform data validation and reconciliation between source and target, investigating and resolving variances to ensure financial accuracy
- Plan and execute mock conversion cycles, capturing lessons learned, load timings, and defects to improve each subsequent cycle
- Support cutover conversion activities, including execution of the cutover plan, load sequencing, and issue resolution within the cutover window
- Support the production conversion, including final data loads, post-load validation, and resolution of conversion-related issues
- Prepare conversion reconciliation evidence and obtain business sign-off for each conversion cycle and for the final production conversion
- Create and maintain documentation, including mapping specifications, conversion runbooks, reconciliation results, and test evidence
Requirements and skills:
- Proven experience in data conversion and migration for ERP/EPM implementations, including mock, cutover, and production cycles
- Strong working knowledge of Oracle ERP Cloud Fusion data structures, load templates, and conversion tools
- Strong understanding of data profiling, data quality, and reconciliation concepts, particularly for financial balances and master data
- Experience with SQL and data transformation
- Experience with Alteryx
- Experience working with system integrators and business stakeholders
- Good communication skills are necessary
- Self-starter, motivated and results oriented collaborator
- Detail oriented, strong analytical and problem-solving skills and have an ability to find creative solutions
- Strong teamwork skills, but ability to work independently
- Familiar with Office 365 (intermediate skills in Excel preferred)
- Preferably working knowledge of Oracle EPM and Oracle Cloud Financials
- Preferably Oracle certification, but not necessary