We have an exciting opportunity for a Data Migration Analyst to join our ApotheCom team on a 6-month fixed term contract basis.
ApotheCom is an exciting leader in the field of medical communications. Drawn together from several backgrounds including the pharmaceutical industry, research, marketing, medical and regulatory writing, sales, publishing, digital media and design, we have the experience and all-round ability to conceive and deliver the best quality medical communications programmes.
About The Role
Reporting to the Finance Director, the Data Migration Analyst supports the seamless and accurate migration of data from Deltek Maconomy into Oracle ERP systems. This role requires a strong understanding of financial data structures, experience in ERP systems (ideally in Maconomy and Oracle), and a methodical approach to data extraction, transformation, validation, and loading (ETL). The Data Migration Analyst will play a crucial role in ensuring data integrity, consistency, and minimal business disruption during the transition.
Key responsibilities will include:
- Leading and executing data migration activities from Maconomy to Oracle Fusion.
- Collaborating with functional and technical teams to define data migration strategy, scope, and timelines.
- Extracting, transforming, and loading (ETL) data from Maconomy, ensuring alignment with Oracle data structures.
- Collaborating with key stakeholders to cleanse, map, and validate data to meet Oracle standards and project requirements.
- Developing and maintaining detailed documentation of data migration processes, mapping logic, and validation scripts.
- Conducting data quality checks, performing reconciliation between systems, and resolving discrepancies.
- Working with stakeholders to identify legacy data to be migrated and defining data retention policies.
- Supporting testing cycles (System Integration Testing, User Acceptance Testing) with relevant data sets.
- Ensuring compliance with data governance, security, and privacy policies.
- Providing regular updates and status reports to the project team and senior stakeholders.
About you:
To succeed in this role, you will have:
- Proven experience with data migration projects in a similar role. Experience with data migration from Maconomy to Oracle ERP is desirable, but not essential. .
- Strong understanding of ERP data models, especially in finance, projects, HR, and procurement modules.
- Excellent problem-solving skills and attention to detail.
- Ability to manage multiple priorities and meet tight deadlines.
- Excellent communication and collaboration skills.
- Ability to work independently and manage multiple priorities in a deadline-driven environment.
Don't meet every job requirement? That's okay! Our company is dedicated to building a diverse, inclusive, and authentic workplace. If you're excited about this role, but your experience doesn't perfectly fit every qualification, we encourage you to apply anyway. You may be just the right person for this role or others.
