Data Manager

JMG Group is a Private Equity backed insurance broking group based in Guiseley, West Yorkshire with strong regional office representation around the UK. We are a top 30 broker, growing rapidly having completed numerous acquisitions since our MBO in 2020. We place over £350m+ of Gross Written Premium into the market annually and our teams are very well respected in the market. Customer excellence is the backbone of our business, which means that our people, systems, and processes are central to our success The Role: We’re accelerating our data strategy to support sustained organic and acquisitive growth. As Data Manager, you will own the group’s data platform, governance, and analytics enablement—ensuring reliable, secure, and timely management information (MI) and unlocking value with SQL, Power BI, and applied AI. The role blends hands on technical leadership with stakeholder engagement across the Group. Our environment: You’ll work closely with colleagues across the IT team and wider Group functions; the role is hands on and outcomes-focused, supporting leadership with consistent, actionable insights as we scale. Key Responsibilities: • Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. • ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including core broking systems (e.g., Acturis) and newly acquired businesses; deliver prompt, accurate, and comprehensive integration into group reporting and propose alternative solutions to existing infrastructure where appropriate. • Power BI enablement: Own datasets, semantic models, DAX development, row-level security, gateway/configuration, and performance. Partner with BI Developers/Analysts to deliver automated, actionable dashboards for leadership and frontline teams. • AI for analytics: Introduce and steward responsible AI use to enrich insights and automate MI. • Data governance: Implement policies and controls for data quality, develop and maintain step-by-step documentation of key weekly and monthly processes, embed validation and exception reporting so errors are identified and resolved promptly. • Stakeholder management: Build strong relationships across group, including Finance, Compliance, Operations, Insurer Relations and business units; translate requirements into robust data solutions and ensure MI is understood and used. • Team leadership: Mentor, develop and utilise a small team (BI Developers/Analysts) to deliver data strategy. • Acquisition reviews: identify potential synergies. • Roadmap & delivery: Maintain a roadmap covering platform improvements, AI use-cases, new acquisitions integration, and reporting simplification; track benefits and adoption. Key Skills Required: • Advanced SQL: stored procedures, views, window functions, temp tables, CTEs, query optimisation; confident with advanced SSMS query writing. • Significant experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). • ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). • Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly within reporting workflows. • Proven track record integrating disparate systems post-acquisition and delivering reliable and consistent group MI. • Excellent communication at all levels across the business from entry level to director. • Stakeholder engagement, and the ability to translate complex data into clear business actions. • Team management experience: Confident in leading, managing and developing a small team of analysts. Nice to Have skills: • Experience with Acturis data extraction and automation of broking MI. • Microsoft Fabric/Azure experience. • Implementation, management and usage of API pipelines for reporting. • Experience of working in the insurance industry. • SSIS administration; Power BI governance at tenant level. • Project management experience. • Advanced Excel: advanced formulas, Pivot tables, Power Pivot. Qualifications: • Degree in a quantitative field (or equivalent experience). • Microsoft certifications (DP-203, PL-300) advantageous. • Evidence of continuous learning in data engineering, BI, and AI. What we offer: • Competitive salary commensurate with level of experience • Hybrid working options considered following training & probation completion • Free parking • Company Pension scheme • Generous holiday entitlement & Birthday off • Death in service scheme REF-229 439