Canopius Group
Senior Analytics Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Analytics Engineer
Senior Analytics Engineer (Power BI & Databricks)
About the Role
At Canopius, our delivery teams ensure business users unlock data insights to drive strategic decision-making. Our enterprise Lakehouse platform—built on Databricks—eliminates fragmented, ungoverned data silos, enabling self-service analytics, advanced analytics, and AI-powered change across our industry.
This Senior Analytics Engineer role demands expertise in analytics engineering, data modelling, and visualisation, combining hands-on development with technical leadership. You’ll design, build, and optimise trusted analytics solutions using Power BI, paginated reports, and Databricks, while mentoring junior engineers and collaborating with senior stakeholders.
The ideal candidate is an experienced analytics engineer eager to accelerate change in financial services. You thrive in multi-disciplinary teams, bridging business needs with cloud-native, scalable solutions while upholding rigorous technical standards. This role sits at the heart of Canopius’ data strategy, transforming a governed Lakehouse architecture into a self-service analytics foundation.
Key themes:
- Technical leadership in analytics and reporting
- Cloud-native migration of legacy systems
- Mentorship and knowledge sharing within the team
- Capability development in AI, automation, and data governance
Responsibilities
Core Delivery
- Provide technical leadership across analytics engineering, reporting, and Databricks initiatives, aligning with Canopius’ cloud-native, Lakehouse strategy.
- Collaborate with business stakeholders to define trusted insights, ensuring solutions align with strategic priorities.
- Design, optimise, and maintain semantic models, datasets, and reporting solutions in Power BI, paginated reports, and Databricks, adhering to team standards.
- Tune data models, DAX calculations, queries, and refresh strategies for performance, scalability, and reliability.
- Implement data validation, reconciliation, and automated testing to ensure analytics accuracy, security, and governance compliance.
- Refactor and modernise legacy reporting solutions, supporting their migration onto Databricks and Power BI.
- Problem-solve for production operations, defining processes for documentation, monitoring, refresh, logging, access control, and incident response.
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.
Technical Governance & Evolution
- Lead the evolution of team standards (e.g., modelling conventions, naming, testing, deployment) to enhance consistency, maintainability, and scalability.
- Rationalise technical debt, balancing legacy system preservation with progressive adoption of modern BI tech.
- Drive adoption of AI-assisted development and automation to improve delivery outcomes.
Stakeholder & Team Leadership
- Communicate technical solutions and trade-offs clearly to non-technical stakeholders, influencing decisions with evidence-based reasoning.
- Participate in product vision and analytics roadmap sessions alongside Product Owners, Business Analysts, and Solution Architects.
- Mentor junior team members through code reviews, pairing, knowledge sharing, and constructive feedback.
- Act as a cross-functional leader, balancing dependencies, risk, and realistic delivery timelines.
Requirements & Skills
Essential Experience
- 5+ years in analytics engineering, specialising in databases, ETL, dimensional modelling, or BI development.
- Advanced Power BI expertise, including DAX, semantic models (tablular), paginated reports, and performance tuning (proficiency with Performance Analyzer, DAX Studio, VertiPaq Analyzer).
- SQL proficiency for building scalable, well-optimised data transformations.
- Azure DevOps/Git experience (branching, CI/CD pipelines, release strategies).
- Agile/Scrum methodology with a track record of driving delivery in cross-functional teams.
- Excellent analytical and problem-solving skills, with a continuous improvement mindset.
- Technical communicator who can bridge gaps between business stakeholders and engineering teams.
- Operations experience (e.g., monitoring, logistics, process automation) in BI/data environments.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Nice-to-Have
- Specialty insurance/reinsurance background (e.g., bordereaux, delegated authority, underwriting, claims data).
- Databricks hands-on experience in medallion architecture/Lakehouse models.
- Advanced techniques in AI-driven analytics, data observability, or automation.
- Familiarity with Tabular Editor for semantic model management.
Benefits
At Canopius, we champion a comprehensive well-being philosophy with practical perks:
- Competitive salary, pension (non-contributory), discretionary bonus
- Hybrid working model in our cutting-edge London offices
- Comprehensive insolvances: health + dental (covers families)
- Supporting employee growth with learning development and career progression
About Canopius
Canopius is a global specialty reinsurer with a presence in Lloyd’s of London and markets worldwide, including: 📍 United Kingdom 📍 United States 📍 Singapore 📍 Australia 📍 Bermuda
Our Culture
We build sustainable profit through an inclusive, evolving culture that encourages: ✅ Psychological safety – bringing your whole self to work ✅ Collaboration – diverse teams thriving through open dialogue ✅ Innovation – driving change in (re)insurance with agile, modernised tech ✅ Complete equity – equal opportunity for all, regardless of background, gender, disability, or identity
Our Commitment
We foster an inclusive workplace where everyone’s contributions matter. If you need accommodations or require information in an alternative format, please inform us. We’re invested in supporting all phases of the hiring process.
Apply Now — Inquire at apply@canopius.com and/or follow our careers page [here (link pending, should not be included per format rules)]**.
“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