Senior Data Analyst

Hiscox Underwriting Group Services Ltd Portugal (HUGS PT); Lisboa; In loco; EUR 55.000 - 75.000; Tempo pieno

Descrizione del lavoro

Hiscox in Lisbon is seeking a Senior Data Analyst to join the Group Data Team. You will translate European requirements into clear data and reporting specifications, own data modelling, and support adoption of a global reporting framework across business units.

You will collaborate with Data Engineers, Power BI developers and business stakeholders to deliver reliable analytical products, maintain documentation and data definitions, and ensure European needs are represented in the global solution.

Competenze

• 5+ years in Data Analytics, BI or related role.
• Strong SQL skills and experience with dimensional data modelling and data reconciliation.
• Experience producing designs and technical documentation (Confluence).
• Hands-on Power BI experience is a plus.
• Ability to translate business needs into clear requirements.
• Experience with backlog management and prioritisation (JIRA).
• Strong analytical, communication and stakeholder management skills.
• Experience with Azure and Databricks is desirable.
• Fluent in English; degree in relevant field preferred.

Mansioni

• Design and maintain dimensional data models including fact tables and conformed dimensions.
• Produce source-to-target mappings and data contracts with shared models and definitions.
• Define data quality checks and reconciliation against European reporting.
• Maintain data model documentation and mapping specifications.
• Gather European requirements for the Group Data initiative.
• Bridge Group and Europe Data Product Managers to align demand.
• Consolidate European demand and align backlogs from prioritisation to delivery.
• Define requirements, user stories, acceptance criteria and data validation activities.
• Work with Data Engineers, Power BI developers and stakeholders to deliver analytical products.
• Support testing, issue resolution, adoption and continuous improvement in Europe.

Conoscenze

Five+ years in Data Analytics

SQL

Dimensional Data Modelling

Data Reconciliation

Confluence

Power BI

Backlog Management

JIRA

Stakeholder Management

English Fluency

Formazione

Bachelor’s degree

Master’s degree (preferred)

Strumenti

Azure

Databricks

Descrizione del lavoro

Job Type: Permanent

About Hiscox

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

We’re a global, specialist insurer headquartered in Bermuda and listed on the London Stock Exchange. With 3,000 employees and 32 offices in 12 countries we’re a business with lots of opportunity for people with talent, spark and lots of ambition.

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.