Senior Data Analyst

Job Type:

Build a brilliant future with Hiscox

About Hiscox

Hiscox is an international specialist insurer with a collaborative and inclusive culture, helping customers and businesses manage complex risks.

The Role

This role sits within the Group Data Team, reports to a Data Product Manager and is based in Lisbon, embedded in the Europe Data Team.

The Senior Data Analyst will be fully dedicated to a strategic Group Data initiative aimed at creating a consistent reporting framework across Hiscox. The initiative brings together common data, KPI definitions and analytical capabilities to provide comparable performance reporting across Business Units and support better business decisions.

The role will represent Europe within the initiative, ensuring that European business requirements, data structures and reporting needs are reflected in the global solution. Working across Group Data, Europe Data and business teams, the analyst will translate requirements into clear data and reporting specifications, own data modelling, source-to-target mapping and documentation, and support reconciliation, testing and adoption. The analyst will also be the main point of contact for European needs on the initiative, aligning demand between the Group and Europe Data Product Managers.

Key Responsibilities

• Design and maintain dimensional data models, including fact tables and conformed dimensions, and produce low-level solution designs.

• Produce source-to-target mappings and data contracts aligning source data with the initiative’s shared models, metrics and definitions.

• Define source-to-target reconciliation and data quality checks, and reconcile outputs with existing European reporting.

• Maintain data model documentation, mapping specifications and data definitions, and contribute to architecture standards and impact analysis.

• Gather and document European business, data and reporting requirements for the Group Data initiative.

• Act as the main point of contact for European needs on the initiative, bridging the Group and Europe Data Product Managers.

• Consolidate European demand and align the Europe and initiative backlogs, from prioritisation to delivery.

• Define requirements, user stories, acceptance criteria and data validation activities.

• Work with Data Engineers, Power BI developers and business stakeholders to deliver reliable analytical products.

• Support testing, issue resolution, adoption and continuous improvement of the initiative in Europe.

Skills and Experience

• Around five or more years’ experience in Data Analytics, Business Intelligence or a related role.

• Strong SQL skills and proven experience in dimensional data modelling, source-to-target mapping and data reconciliation.

• Experience producing solution designs and technical documentation (e.g. Confluence).

• Hands-on Power BI experience is a plus

• Ability to translate business needs into clear functional and technical requirements.

• Understanding of backlog management and demand prioritisation (e.g. JIRA).

• Strong analytical, communication and stakeholder management skills, including aligning Group and Business Unit priorities.

• Experience with Azure, Databricks, insurance or financial services is desirable.

• Fluent in English; a relevant bachelor’s or master’s degree is preferred.

Person Specification

• Collaborative, pragmatic and comfortable working across Group and Business Unit teams.

• Able to work independently and represent European requirements confidently.

• Structured, detail-oriented and comfortable with ambiguity and changing priorities.

Work with amazing people and be part of a unique culture