How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Manager | JMG Group
JMG Group is a Private Equity-backed insurance broking group based in Guiseley, West Yorkshire, with strong regional representation across the UK. As one of the top 30 brokers, we’ve grown rapidly since our MBO in 2020, placing over £350m+ in Gross Written Premium annually. Customer excellence drives our success, underpinned by our people, systems, and processes.
The Role
We’re accelerating our data strategy to support organic and acquisitive growth. As Data Manager, you’ll own the group’s data platform, governance, and analytics enablement, ensuring reliable, secure, and timely management information (MI)—while unlocking value through SQL, Power BI, and applied AI. This role blends technical leadership with stakeholder engagement across the Group.
Our environment: You’ll work closely with IT colleagues and wider business functions in a hands-on, outcomes-driven setting. You’ll collaborate with leadership to deliver 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 practices for schema design and performance tuning in SQL Server/SSMS.
-
ETL/ELT & integration
- Define and manage ETL/ELT pipelines (e.g., SSIS, Power Query) to integrate sources, including Acturis and acquired business systems.
- Ensure prompt, accurate, and comprehensive integration into group reporting, proposing improvements where needed.
-
Power BI enablement
- Own datasets, semantic models, DAX development, row-level security (RLS), gateways, and performance.
- Partner with BI Developers/Analysts to deliver automated, actionable dashboards for leadership and frontline teams.
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.
-
AI for analytics
- Introduce and steward responsible AI use to enrich insights and automate MI generation.
-
Data governance
- Implement policies and controls for data quality.
- Develop and maintain documentation for key weekly/monthly processes.
- Embed validation and exception reporting to ensure quick error resolution.
-
Stakeholder management
- Build strong relationships with Finance, Compliance, Operations, Insurer Relations, and business units.
- Translate requirements into robust data solutions and ensure MI is utilised effectively.
-
Team leadership
- Mentor, develop, and utilise a small team (BI Developers/Analysts) to deliver the data strategy.
-
Acquisition reviews
- Identify potential data integration synergies for acquired businesses.
-
Roadmap & delivery
- Maintain a structured roadmap covering:
- Platform improvements
- AI use cases
- New acquisition integrations
- Reporting simplification
- Track benefits realisation and adoption.
- Maintain a structured roadmap covering:
Key Skills Required
-
Advanced SQL expertise
- Stored procedures, views, window functions, temp tables, CTEs, and query optimisation.
- Confident in SSMS query writing.
-
Power BI proficiency
- DAX, Power Query, row-level security (RLS), and performance optimisation.
- Significant experience creating models and dashboards.
-
ETL/ELT tooling & dimensional modelling
- Experience with SSIS/Power Query and star schema approaches.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
-
Practical AI/ML exposure
- Hands-on experience with Python notebooks, Azure ML, or equivalent.
- Ability to operationalise models responsibly within reporting workflows.
-
Acquisition integration expertise
- Proven track record in integrating disparate systems post-acquisition and delivering consistent group MI.
-
Communication & stakeholder engagement
- Strong ability to explain complex data to all business levels (entry to directors).
-
Team management skills
- Confident in leading, managing, and developing a small team of analysts.
Nice-to-Have Skills
- Experience with Acturis data extraction and broking MI automation.
- Knowledge of Microsoft Fabric/Azure.
- API pipeline implementation, management, and usage for reporting.
- Experience in the insurance industry.
- SSIS administration and Power BI governance at the tenant level.
- Project management expertise.
- Advanced Excel: Pivot tables, Power Pivot, and complex formulas.
Qualifications
- Degree in a quantitative field (or equivalent experience).
- Microsoft certifications (e.g., DP-203, PL-300)—advantageous.
- Evidence of continuous learning in data engineering, BI, and AI.
What We Offer
- Competitive salary (commensurate with experience).
- Hybrid working options (post training/probation).
- Free parking.
- Company pension scheme.
- Generous holiday entitlement (including 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