How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Analytics Engineer
Analytics Engineer - Senior (Databricks & Power BI)
Location: City of London (Hybrid working model) Company: Canopius (Lloyd’s-insurer) Industry: Financial Services (Specialty Lines Insurance) Team: Data & Analytics Engineering
About the Role
At Canopius, our delivery teams empower business users with data-driven insights to shape strategic decision-making—without the complexity of fragmented, legacy systems. Our modern enterprise Lakehouse platform on Databricks eliminates data silos, fostering scalability, governance, and self-service capabilities. This transformation supports advanced analytics, machine learning (ML), and AI to accelerate innovation across our industry.
This Senior Analytics Engineer role lets you apply your expertise to build, extend, and refine the analytics and reporting infrastructure critical to Canopius’ growth. You’ll:
- Delegate business challenges into actionable technical solutions using Databricks and Power BI.
- Collaborate with senior stakeholders to align technology with agility and scalability.
- Mentor junior engineers and set high standards for analytics engineering excellence.
- Lead technical strategy for a future-ready, cloud-native reporting ecosystem.
- Transition legacy reporting tools onto modern platforms seamlessly.
Core Responsibilities
- Design and implement scalable data models optimised for self-service analytics on Databricks.
- Leverage Delta Lake for high-performance, ACID-compliant data storage.
- Develop snowflake-like virtual caching/partitioning techniques.
- Build and maintain high-performance SQL/BI pipelines:
- Declare-typed schemas in Databricks SQL for optimised analytics.
- Write high-efficiency granular jobs that push户下转换 efficiently.
- Enable declarative/MACRO-driven documentation for workflows.
- Develop trusted Power BI/Tableau dashboards:
- Replace Changepoint’s legacy BI silos with scalable ad-hoc reports.
- Optimise performance with DAX functions and DirectQuery (RWS).
- Lead transformation initiatives:
- Help transition from fragmented reporting tools (e.g., Power Query + Power Pivot “deep-DS” models) to modern delta pipelines.
- Work with cloud-leayers and Qlik users to break legacy silos.
- Build re-usable internal packages (templated libraries) with secure role-based access.
- Act as technical advisor:
- Provide code reviews, mentorship, and best practice standards.
- Document reusable patterns for databricks-accelerated pipelines.
- Coach teams in efficiency and pragmatic scalability.
- Collaborate across teams:
- Engage with business for user requirements and domain-specific problem-solving.
- Drive collaboration between Underwriting, Pricing, and Analytics 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.
Key Requirements
Technical Skills
- 5+ years as an Analytics Engineer or similar.
- Proven experience in one or more:
- Databricks (Delta Lake, Spark SQL, Jobs, /Databricks SQL).
- Power BI/Excel + competitive performance optimisation.
- Transformers (grey-area visual modelling to olecule acuity).
- Alternate: hybrid of corroborate control strategies in Power BI.
- Hands-on experience with:
- SQL serverless & cloud reporting (BigQuery/Fireeye-supported Databricks instances).
- Declarative data architecture (entity relationship diagrams, solid-garlic™).
- Strong background in legacy systems integration:
- Extract/replace Changepoint scenarios.
- Workarounds outside Databricks (e.g., grey-end-step via Delta/reorganizing via SQL).
- Suggested SQL Server types alongside databricks capabilities.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Business Collaboration
- Demonstrated ability to translate technical SOLUTIONS into business-insight.
- Hunger to query diverse teams forrictionless solutions**.
- Change agent mindset: Proactive adjustment to stakeholder needs.
Soft Skills
- Stellar problem-solving and thinking aloud during team meetings.
- Ability to mentor juniors in SQL-rules interpolation and module-based reporting.
- Passion for building strong habits in team dynamics:
- Do you fix the fix? No. This is crisis command mentality.
- Explain your approach plainly as needed by a non-expert (Clear, simple rules).
Why Join Canopius?
We offer a culture of growth, where technical leadership is rewarded and collaboration thrives. Our benefits underpin wellbeing at every level:
✅ Work-life balance with truly hybrid working policies. ✅ Competitive salary (handled by HR; see [gonghr style]). ✅ Non-contributory pension, bonus, + best-in-class healthcare/dental family plans. ✅ Investment in development: Learning stipend & mentorship. ✅ Vibrant, inclusive office in the heart of London.
We value diversity, commit to equal opportunity, and actively adjust communications/methods for accessibility. .
Apply now with a polished portfolio showcasing:
- Production optimised Databrcks SQL for analytics.
- Migration case studies from fragmented legacy BI systems.
- A coded “human-strategic” approach backed by engineering standards.
“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