Senior Data Analyst
hace 2 días
City of London
Role: Senior Data Analyst - Broking Data Migration & Analytics Location: London / Hybrid (2–3 days on-site per week) Dept: Data & Analytics Reports to: Head of Data / Chief Product Officer Salary: £75,000 - £90,000 p/a + package We’re transforming how commercial insurance brokers work - helping them eliminate re-keying, connect seamlessly to insurer APIs, and make smarter, data-driven decisions. Our platform modernises broker operations by capturing, enriching, and analysing data to unlock efficiencies and insight across the broking lifecycle. We’re looking for a Senior Data Analyst with deep experience in broking data migration and analytics to help us build robust data foundations and deliver valuable insights for brokers, insurers, and internal teams. Role Overview: You’ll play a key role in designing, managing, and delivering data migration and analytics initiatives across our client implementations and platform development. Working closely with product, engineering, and customer success teams, you’ll ensure broker data is migrated accurately, transformed intelligently, and leveraged for meaningful analysis and reporting. This is a hands-on, highly collaborative role that combines technical expertise with strong business understanding of broking operations, policy lifecycle, and insurance data models. Key Responsibilities: Data Migration & Integration • Lead end-to-end data migration projects for new broker clients, ensuring accuracy, consistency, and completeness., • Analyse legacy broking system data structures (e.g. Acturis, Open GI, Applied Epic, SSP, TAM, etc.) and map them to Recorder’s data model., • Define transformation logic and reconciliation procedures to validate migrated data., • Collaborate with engineers on ETL design and ensure smooth data onboarding into production environments., • Develop quality assurance processes and data validation scripts to identify anomalies and drive resolution. Data Analytics & Reporting • Develop and maintain dashboards and reports for brokers, insurers, and internal teams using tools like Power BI or Looker., • Translate business requirements into data queries, KPIs, and metrics — such as conversion rates, renewal performance, risk profiles, and brokerage growth trends., • Conduct deep-dive analyses on client portfolios to surface insights and opportunities for efficiency or profitability., • Support the creation of APIs and data products for broker and insurer analytics., • Partner with product teams to design data-driven features, ensuring new functionality is measurable and reportable. Governance & Improvement • Define and document data standards, mappings, and lineage across broking and analytics systems., • Advocate for data quality, integrity, and best practice within the business., • Support automation and process improvement across data migration and reporting workflows. Essential Experience: • 5+ years in data analysis, business analysis, or migration roles — ideally within insurance or broking software., • Proven experience managing broking system data migrations from legacy platforms (Acturis, Open GI, SSP, Applied, TAM, etc.)., • Strong SQL skills for data extraction, transformation, validation, and reconciliation., • Experience with BI / reporting tools such as Power BI, Looker, or Tableau., • Understanding of insurance data structures, including clients, policies, risks, premiums, claims, and bordereaux., • Comfortable working with structured and semi-structured data from multiple systems., • Strong communication skills — able to translate data findings into actionable insights for technical and non-technical stakeholders. Desirable Skills: • Experience working with ETL tools or scripting languages (Python, dbt, Alteryx, SSIS, etc.)., • Familiarity with cloud data environments (AWS, Azure, GCP)., • Knowledge of data governance, privacy (GDPR), and regulatory requirements in insurance., • Exposure to API-based data integrations and data-as-a-service solutions. What You’ll Get: • Opportunity to shape the future of data at a fast-growing Insurtech., • Work closely with brokers and insurers to solve real-world data challenges., • Competitive salary and benefits package., • Hybrid, flexible working culture that values collaboration and innovation.