Data Manager

JMG Group; Guiseley; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Hybrid working options

Free parking

Company Pension scheme

Generous holiday entitlement &Birthday

Job summary

JMG Group is seeking a Data Manager to own the group’s data platform, governance and analytics enablement, ensuring reliable MI and unlocking value with SQL, Power BI, and applied AI. The role blends hands-on technical leadership with stakeholder engagement across the Group.

You’ll work with colleagues across IT and wider Group functions; the role is hands-on and outcomes-focused, supporting leadership with consistent, actionable insights as we scale.

Qualifications

• Degree in a quantitative field or equivalent experience.
• Experience leading BI/analytics teams and delivering management information.
• Proven ability to translate requirements into robust data solutions.

Responsibilities

• Own the data platform, governance and analytics enablement for the group.
• Define and manage ETL/ELT pipelines and data integration post-acquisition.
• Deliver Power BI dashboards, semantic models and secure data access.
• Introduce responsible AI use to enrich insights and automate MI.
• Mentor a small team of BI Developers/Analysts and drive the roadmap.

Skills

Advanced SQL

Power BI

ETL/ELT tooling

Dimensional modelling

AI/ML exposure

Data governance

Stakeholder engagement

Team leadership

Education

Degree in a quantitative field

Tools

SSIS

Power Query

Acturis data extraction

Python notebooks

Job description

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.

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.
• 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.
• Implementation, management and usage of API pipelines for reporting.
• Experience of working in the insurance industry.
• SSIS administration; Power BI governance at tenant level.
• Advanced Excel: advanced formulas, Pivot tables, Power Pivot.

Qualifications:

• Degree in a quantitative field (or equivalent experience).
• 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