Ivernia Insurance is a specialist personal lines Managing General Agent operating across Motor, Home and Commercial Motor. The business partners closely with insurer capacity providers and operates under delegated authority, with a strong focus on underwriting discipline, pricing integrity and controlled growth.As the business scales, there is a clear need to strengthen data, MI, and performance insight to ensure growth is profitable, controlled, and aligned with portfolio and capacity expectations.The OpportunityThe Data Analyst is responsible for turning data into clear, reliable insight to support decision making across the business. The role focuses on management information, performance monitoring, analysis of trends and drivers and building confidence in the quality and consistency of reported data.A core element of the role is the enhancement, governance and ongoing ownership of an existing centralised data lake, which acts as the organisation’s single source of truth. The role will improve structure, data quality, documentation and usability, ensuring the data lake effectively integrates information across the business to support consistent reporting and analysis over time.This is a hands on role with a strong emphasis on business understanding, clear communication and practical analysis rather than advanced modelling.Key ResponsibilitiesMaster Data Lake and Single Source of TruthOwn and enhance the existing centralised data lake to support reporting, analytics and MIReview and improve current data structures, schemas and metric definitions to address gaps and inconsistenciesIngest, structure and harmonise data from multiple source systemsDefine core data entities, schemas and metric definitions to ensure consistencyImplement data refresh logic, validation checks and reconciliation controlsImprove documentation covering data lineage, definitions and business logic to strengthen trust and usabilityData Analysis and InsightAnalyse business performance across products, schemes, channels and partnersIdentify trends, movements and drivers in key metricsSupport deep dive analysis to explain performance changesTranslate data into clear, concise insights for non technical stakeholdersManagement Information and ReportingBuild, maintain and enhance management information dashboards and reportsEnsure MI is accurate, timely and consistentDevelop standard performance packs for senior management and external stakeholders where requiredSupport ad hoc reporting requests with quick turnaroundData Quality and GovernanceValidate data inputs and highlight data quality issuesWork with business users and technical teams to resolve data gaps or inconsistenciesOwn and contribute to the development of a single source of truth for reportingDocument definitions, assumptions and logic used in reportingStakeholder EngagementWork closely with underwriting, pricing, operations, finance and distribution teamsUnderstand business questions and translate them into analytical outputsPresent findings clearly and confidently, both written and verballyRequired Skills and ExperienceTechnical skills5+ years experience working with data lakes, data warehouses or centralised data platformsStrong Python and/or SQL skillsAdvanced Excel skillsSolid understanding of data structures and relational databasesComfortable working with large datasetsExperience with BI toolsAnalytical CapabilityStrong analytical and problem solving skillsAbility to interpret data and explain results clearlyGood grasp of descriptive statisticsHigh attention to detailAdvantageousPrior experience in personal lines insurance or MGA environmentPrior experience in both Python and SQLPrior experience in both Power BI and TableauPrior experience in WTW’s Radar suitePersonal AttributesStrong ownership and accountabilityComfortable working independently while collaborating closely with othersAble to prioritise and manage competing demandsCurious and questioning mindsetClear and confident communicatorWhat success looks likeStakeholders trust the data and use it in decision makingMI is readily available, consistent, and easy to interpretPerformance issues are identified early and explained clearlyThe organisation has improved visibility over its portfolio and operationsWhy join the businessOpportunity to play a meaningful role in evolving and strengthening the existing data and MI capability within a growing insurance MGA at an important stage of its developmentHigh impact position where your work directly influences portfolio insight, commercial decisions and discussions with key stakeholdersOpportunity to take an existing data foundation and bring it to the next level, rather than inheriting heavy legacy complexity.Close collaboration with pricing, underwriting, operations and senior leadership, giving strong exposure to how the business operates end to endPractical, real world data challenges with clear commercial and regulatory relevanceEnvironment that values clear thinking, ownership and high quality deliveryStrong opportunity to deepen technical, analytical and domain knowledge in insurance data, with scope to grow responsibility and influence as the data capability maturing
#J-18808-Ljbffr