Data Migration Specialist

Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed What the day will look like Working with Business / Product teams to understand end to end data process during requirements gathering. Work with data runs to understand the detail of data provided and enhance the existing validation scripts for improvements as required. Perform data runs into staging tables and run validation scripts and generate output reports for the owner of the source system data extracts. Assist the Product owner to add details to user stories for any enhancements to the Bulk Upload Tool as required. Provide advice around target systems to the owner of the source system data extracts. Create repeatable adhoc SQL transformations as may be required for projects. Create and maintain mapping documentation to be shared with project team. Work with Business PM and / or delivery lead to create a cadence of delivery. Work with existing data migration team to smooth the flow of work across timezones.

Participate as a member of the distributed data migration team across Asia, Pacific and Europe. Perform data runs as required and provide outputs back to the project team members. Work with the Bulk Upload Product Owner, to create product backlog stories in Azure DevOps as required for changes to Bulk Upload Tool. Create adhoc data transformations in SQL as required. Assist to maintain mapping documentation. Learn the various platforms which make up the Commercial Risk Eco System within Aon and how the data flows work. Governance & Delivery Align with the APAC and Global PMO processes and security standards as advised. E.g. Data privacy and data masking Skills and experience that will lead to success Knowledge Previous experience in data migration work. Using Azure Dev Ops or Jira for managing software development. Knowledge of Relational Data Bases & specifically Transact SQL & PL/SQL is a distinct advantage. Knowledge of using ER diagrams is an advantage. Excel knowledge for bulk data loads is an advantage Knowledge of how to test call APIs using Postman or Soap UI is an advantage.

Logical, systematic thinking. Attention to detail. Good communication. Both written and oral English. Emotional Intelligence Experience Bachelor’s degree or equivalent experience in computer science or information technology. 8+ years proven IT experience 3+ years working with data Migration Evidence of being a successful influencer across different teams and cultures. Experience of working on general insurance risk related problems is desirable. Experience within Insurance broking is a distinct advantage. How we support our colleagues In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace. Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability,