Data Migration Specialist

Aon; Philippines; On-site; PHP 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Global Wellbeing Days

Smart Working

Job summary

Aon is seeking a seasoned IT professional with extensive data migration experience to join our distributed team across Asia, Pacific, and Europe. You will perform data runs, transform data in SQL, and collaborate with Product Owners to document and backlog changes in Azure DevOps.

Ideal candidates have 8+ years IT experience, knowledge of relational databases (T-SQL/PL-SQL), and familiarity with insurance risk domains. We value cross-cultural collaboration and clear communication.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Logical thinking

Attention to detail

Communication skills

Emotional Intelligence

Education

Bachelor’s degree or equivalent in CS/IT

Tools

Azure DevOps

Jira

Relational Databases (T-SQL/PL-SQL)

ER diagrams

Excel large data loads

API testing (Postman/SoapUI)

Job description

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.

Responsibilities

• 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.

Skills

• 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, veteran, marital, domestic partner status, or other legally protected status.

We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email [e-mail]

2583753