How your CV stacks up
Upload your CV to see how well it fits this job role
?%
JMG Group
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location