Back to search

Senior Data Analyst

Senior Data Analyst responsible for designing and maintaining dimensional data models, source-to-target mappings, and supporting a strategic Group Data initiative across Europe.

  • Lisbon, Lisbon District, Portugal
  • Full-time
  • Posted Nov 11, 2026
INDUSTRYFinance & AccountingInsurance

Responsibilities

  • Design and maintain dimensional data models, including fact tables and conformed dimensions
  • Produce source-to-target mappings and data contracts
  • Define source-to-target reconciliation and data quality checks
  • Maintain data model documentation and mapping specifications
  • Gather and document European business, data and reporting requirements
  • Act as main point of contact for European needs
  • Consolidate European demand and align backlogs
  • Define requirements, user stories, acceptance criteria and data validation activities
  • Work with Data Engineers, Power BI developers and business stakeholders to deliver analytical products
  • Support testing, issue resolution, adoption and continuous improvement

Requirements

  • Bachelor’s degree
  • Master’s degree
  • Experience in a Insurance

Skills

SQLdimensional data modellingsource-to-target mappingdata reconciliationPower BIConfluenceJIRAAzureDatabricksPower BIConfluenceJIRAAzureDatabricks

Full description

Job Type: Permanent 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

Senior Data Analyst at Hiscox | Referso Jobs