> Markdown version of [/jobs/ext/2668175-data-consultant-insurance](https://www.wearedevelopers.com/jobs/ext/2668175-data-consultant-insurance). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Consultant - Insurance - **Company:** Morson Group - **Location:** London, UK - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Analysis of Variance (ANOVA), Microsoft Azure, Extract Transform Load (ETL), Data Mart, Data Structures, Data Warehousing, Operational Data Store, Power BI, DataOps, SQL Databases, Sql Optimization, Snowflake - **Published:** September 2, 2026 - **Apply:** https://www.totaljobs.com/job/data-consultant/morson-edge-job107922396 ## About the Role We are working with a UK-based General Insurance business seeking a Senior Data Engineer / Data Consultant to join its established data function. This is a broad, hands-on role covering insurance data operations, Snowflake engineering, data quality, financial reconciliation, governance and BI. The successful candidate will need a strong technical background combined with practical experience working with insurance data, particularly bordereaux and delegated authority business. Essential Insurance Experience Insurance experience is essential for this role. You should have hands-on experience working with insurance operational data, ideally within a carrier, MGA, broker, insurtech or specialty insurance environment., * Snowflake - data warehousing, schema and data mart development/maintenance * Advanced SQL - ingestion, extraction, transformation, reconciliation and optimisation * Data modelling and ETL/ELT processes * Azure cloud environments * Power BI - dashboard and management information development Experience with Metabase would be advantageous. ## Description Relevant experience includes: * Bordereaux processing and management * MGA / delegated authority data * TPA and third-party insurance data * Policy and claims data * Premium and exposure reporting * Insurance data and financial reconciliation * Working with external insurance partners and resolving data submission issues, * Manage the monthly collection, validation and ingestion of policy, claims and quote bordereaux from MGAs, TPAs and other distribution partners. * Work with external partners to resolve data quality issues and manage non-standard data submissions and manual interventions. * Develop, maintain and enhance Snowflake data structures, schemas and data marts. * Build and optimise SQL queries as the underlying data model and business requirements evolve. * Investigate and resolve data issues across the full reporting lifecycle. * Perform end-to-end reconciliation from Raw through Core to MART, including control totals, roll-forwards, variance analysis and materiality assessment. * Support the delivery of accurate and trusted data outputs to Finance and wider business stakeholders. * Support the onboarding of new MGAs, TPAs and distribution partners, defining data requirements and ensuring relevant underwriting and rating factors are captured. * Develop and improve data quality controls, governance, lineage and traceability. * Support the remediation of existing audit and control findings, helping to embed more preventative controls earlier in the data lifecycle. * Build and maintain Power BI reporting and dashboards, supporting self-service reporting across the business. * Work closely with Finance, Underwriting, Distribution, MGA relationships and internal Data & Technology teams. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Software Engineer Salary in The UK](https://www.wearedevelopers.com/magazine/231-software-engineer-salary-in-the-uk) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)