About the project

• Data Analyst will be conducting in-depth analyzes 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 work with an advanced technology stack, including IBM TM1, MS SQL, Azure Databricks, IBM Cognos and Power BI.

Your responsibilities

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

Our requirements

• 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.
• Italian, German, Dutch, French, Italian or Spanish language proficiency at least B2+, with the ability to communicate technical concepts effectively.