Data Analyst

Data Analyst Data Analyst wiell be conducting in-depth analyses to meet business needs.You will work closely with internal colleagues to develop data flows and ETL processes that facilitate data exchange between AON and insurance companies, particularly with Zurich.Furthermore, this role plays a key part in ensuring the effective management of reconciliation flows and collaborating with software vendors for continuous improvement. You will will work with an advanced technology stack, including IBM TM1, MS SQL, Azure Databricks, IBM Cognos and Power BI. 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 Design, develop, and maintain data pipelines, ensuring smooth data flow between systems. Perform data extraction, transformation, and loading (ETL) processes to support data integration efforts. Understand and analyze business needs related to data exchange between internal applications. Collaborate with internal teams to develop data flows and ETL processes that support integration between One PMS and Affinity & Health. Perform functional analyses to enhance and optimize existing processes. Oversee the maintenance of applications used for reconciliation and data management. Ensure business continuity by effectively managing and resolving operational issues. . Skills and Experience That Will Lead to Success 5+ years in development or maintenance of data pipelines (ETL). Proficiency in two or more of: SQL, Python with Databricks, Workato, StreamSets, SSIS, SFTP. Experience in Agile tooling and practices relating to code, branch and release management. Azure cloud support experience desirable Experience in ITIL Service Management. ITIL or DataOps certification a distinct plus. Effective technical writing skills to describe issues, root cause, workarounds etc. Familiarity with NIST cybersecurity framework and DORA/DOX-related processes is a plus College degree in IT-related discipline. 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 ReasonableAccommodations@Aon.com #technology&security #LI-JB3 #technology&security #LI-JB3 2555584


Data Analyst Data Analyst wiell be conducting in-depth analyses to meet business needs.You will work closely with internal colleagues to develop data flows and ETL processes that facilitate data exchange between AON and insurance companies, particularly with Zurich.Furthermore, this role plays a key part in ensuring the effective management of reconciliation flows and collaborating with software vendors for continuous improvement. You will will work with an advanced technology stack, including IBM TM1, MS SQL, Azure Databricks, IBM Cognos and Power BI. 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 Design, develop, and maintain data pipelines, ensuring smooth data flow between systems. Perform data extraction, transformation, and loading (ETL) processes to support data integration efforts. Understand and analyze business needs related to data exchange between internal applications. Collaborate with internal teams to develop data flows and ETL processes that support integration between One PMS and Affinity & Health. Perform functional analyses to enhance and optimize existing processes. Oversee the maintenance of applications used for reconciliation and data management. Ensure business continuity by effectively managing and resolving operational issues. . Skills and Experience That Will Lead to Success 5+ years in development or maintenance of data pipelines (ETL). Proficiency in two or more of: SQL, Python with Databricks, Workato, StreamSets, SSIS, SFTP. Experience in Agile tooling and practices relating to code, branch and release management. Azure cloud support experience desirable Experience in ITIL Service Management. ITIL or DataOps certification a distinct plus. Effective technical writing skills to describe issues, root cause, workarounds etc. Familiarity with NIST cybersecurity framework and DORA/DOX-related processes is a plus College degree in IT-related discipline. 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 ReasonableAccommodations@Aon.com #technology&security #LI-JB3 #technology&security #LI-JB3