Associate Analyst, Data & Analytics

AXA; Hong Kong; On-site; HKD 600,000 - 900,000; Full time

Job summary

AXA Hong Kong and Macau is seeking a data engineer to lead cross‑functional data projects, design and maintain ETL/ELT pipelines on Microsoft Azure and optimize SQL for performance and reliability. You will mentor junior team members, collaborate with data modelers, coordinate with Group Office tech teams, and contribute to data quality initiatives while leveraging Agile tools such as JIRA and Confluence.

The role requires 5+ years hands-on experience in ETL/ELT, Databricks, and insurance domain

Qualifications

• Over 5 years of hands‑on experience with ETL/ELT tooling, Databricks, SQL, and stored procedures.
• Solid domain knowledge on Insurance
• Strong SQL tuning/optimization skills.
• Experience with Azure Data Factory and Databricks; familiarity with Azure SQL or SQL Managed Instance.
• Working knowledge of Azure DevOps (Repos, CI/CD pipelines).
• Understanding of data modeling and normalization.
• Experience with Agile methodologies and collaboration tools (JIRA, Confluence, Kanban).
• Vendor management: coordinating with external vendors and managing SLAs.

Responsibilities

• Lead and collaborate with cross-functional teams to deliver data-driven projects that support business objectives.
• Gather, analyze, and interpret complex data sets to identify trends, patterns, and insights.
• Design, develop, and maintain ETL/ELT pipelines on Microsoft Azure (Azure Data Factory, Databricks, Azure SQL / Azure SQL Managed Instance).
• Optimize SQL queries and stored procedures for performance, scalability, and reliability.
• Collaborate with data modelers to understand data structures, normalization, and data quality requirements.
• Implement CI/CD pipelines and deployment strategies using Azure DevOps (Repos, pipelines, release management).
• Monitor, troubleshoot, and improve data pipelines; address data quality issues and incidents.
• Support the Data Tech Lead and internal AXA teams with technical discussions and development work.
• Mentor junior team members and provide guidance on data analysis techniques and best practices.
• Coordinate with Group Office tech team and other local IT teams (architects, BAs, etc.) as needed.
• Participate in Agile ceremonies and use collaboration tools (JIRA, Confluence, Kanban boards).

Skills

ETL/ELT tooling

Databricks

SQL tuning

Stored procedures

Insurance domain

Azure Data Factory

Azure DevOps

Tools

Azure Data Factory

Databricks

Azure SQL

SQL Managed Instance

Azure DevOps

Job description

Responsibilities:

• Lead and collaborate with cross-functional teams to deliver data-driven projects that support business objectives.
• Gather, analyze, and interpret complex data sets to identify trends, patterns, and insights.
• Design, develop, and maintain ETL/ELT pipelines on Microsoft Azure (Azure Data Factory, Databricks, Azure SQL / Azure SQL Managed Instance).
• Optimize SQL queries and stored procedures for performance, scalability, and reliability.
• Collaborate with data modelers to understand data structures, normalization, and data quality requirements.
• Implement CI/CD pipelines and deployment strategies using Azure DevOps (Repos, pipelines, release management).
• Monitor, troubleshoot, and improve data pipelines; address data quality issues and incidents.
• Support the Data Tech Lead and internal AXA teams with technical discussions and development work.
• Mentor junior team members and provide guidance on data analysis techniques and best practices.
• Coordinate with Group Office tech team and other local IT teams (architects, BAs, etc.) as needed.
• Participate in Agile ceremonies and use collaboration tools (JIRA, Confluence, Kanban boards).

Qualifications:

• Over 5 years of hands‑on experience with ETL/ELT tooling, Databricks, SQL, and stored procedures.
• Solid domain knowledge on Insurance
• Strong SQL tuning/optimization skills.
• Experience with Azure Data Factory and Databricks; familiarity with Azure SQL or SQL Managed Instance.
• Working knowledge of Azure DevOps (Repos, CI/CD pipelines).
• Understanding of data modeling and normalization.
• Experience with Agile methodologies and collaboration tools (JIRA, Confluence, Kanban).
• Vendor management: experience coordinating with external vendors, managing deliverables, and tracking SLAs; ability to engage vendors for data platform needs.

About AXA Hong Kong and Macau

AXA Hong Kong and Macau is a member of the AXA Group, a leading global insurer with presence in 52 markets and serving 92 million customers worldwide. Our purpose is to act for human progress by protecting what matters.

As one of the most diversified insurers in Hong Kong, we offer integrated solutions across Life, Health and General Insurance. We are the largest General Insurance provider and a major Health and Employee Benefits provider. Our aim is to not only be the insurer to provide comprehensive protection to our customers, but also a holistic partner to the individuals, businesses and community we serve. At the core of our service commitment is continuous product & service innovation and customer experience enrichment, which is achieved through actively listening to our customers’ needs and leveraging and investing in technology and digital transformation.

We embrace our responsibility to be a driving force against climate change and a force for good to create shared value for our community. We are proud to be the first to address the importance of mental health through different products and services and thought leading iconic research. Our overall Sustainability Strategy, with emphasis on climate strategy and biodiversity commitment, is developed based on TCFD recommendations. We are committed to integrating environmental, social and governance factors across our business and strive to contribute to a sustainable future through 3 distinct roles - as an investor, an insurer and an exemplary company.

AXA is an equal opportunity employer. We are committed to promoting Inclusion and Diversity (I&D) by creating a work environment where all employees are treated with dignity, respect, and where individual differences are valued. We welcome and treasure diverse profiles to join our big family, and to build an inclusive culture together which allows everyone to maximise their personal potential.

Our people strategies are designed to enhance employee well-being and professional growth, ultimately empowering them to excel within the company.

Click here to learn more about our Benefits (https://www.axa.com.hk/en/benefits), Culture (https://www.axa.com.hk/en/culture-and-values), & Career Development (https://www.axa.com.hk/en/career-development).