The Role:
At Canopius, our delivery teams are responsible for ensuring that business users can effectively harness data insights to drive strategic decision making. Our data strategy is centred around an enterprise Lakehouse platform on Databricks, avoiding fragmented, ungoverned silos on legacy technologies that hamper creativity and scalability. We are building a governed, interoperable data estate that enables self-service for our business teams and provides the trusted foundation for advanced analytics, machine learning and AI to accelerate change across our industry.
The Senior Data Reporting Analyst owns the provision of trusted, accurate and timely reporting, partnering directly with business stakeholders to understand requirements and deliver robust solutions. The role both produces and submits reporting/regulatory returns, helping to automate production to enable business self-serve wherever possible.
Working to fixed regulatory cycles and deadlines, the role spans regulatory and operational reporting, applying an accuracy-first mindset to every output. As a senior member of the team, you will also act as a role model and mentor to other team members, championing reporting standards, reusability and continuous improvement.
The ideal candidate is an experienced reporting analyst who is enthusiastic about using technology to accelerate change within our industry, and who takes pride in producing accurate, well-controlled outputs in a regulated environment. You will have strong SQL and advanced Excel skills as standard, with experience of Power BI and Databricks being a distinct advantage. You should be comfortable engaging stakeholders to shape requirements as you are building the solution hands-on, motivated by the opportunity to automate manual processes and enable self-service.
Responsibilities will include:
Work closely with business stakeholders to produce and submit accurate, timely and auditable regulatory and operational reporting, meeting internal standards and external regulatory requirements to fixed reporting cycles and deadlines.
Automate manual and legacy reporting processes, embedding validation, reconciliation and automated checks to ensure trusted outputs. Enhance existing automated reporting solutions.
Engage directly with business stakeholders across the business to understand and document new regulatory reporting requirements, and translate them into clear specifications.
Visualise, plan and execute the end-to-end delivery of large reporting work items, seeking clarification of ambiguous specifications and consistently delivering complex work in line with development standards. Look beyond the immediate scope of work items to ensure alignment with the wider solution and data design, proactively flagging the risk of technical debt.
Maintain documentation, data lineage and audit trails for regulated outputs, and support audit and regulatory queries with supporting evidence.
Build trusted relationships with stakeholders across delivery and business teams; proactively manage expectations, communicate trade-offs and constraints, and influence decisions with evidence and risk-based recommendations, navigating disagreement constructively and escalating appropriately.
Explain complex topics in an easy-to-understand manner for both technical and non-technical audiences.
Break complex work into deliverable increments, produce realistic estimates, and highlight dependencies and risks early. Drive clarity on scope, acceptance criteria and non-functional requirements such as performance, resilience and security.
Balance delivery momentum with quality, and demonstrate resilience when requirements change, operating effectively in uncertain or evolving environments.
Manage own task list and priorities, working confidently both within agile development squads and as a self-starter.
Act as a role model and mentor to other team members through pairing, peer review, constructive feedback and knowledge sharing, helping to raise the quality and pace of delivery across the team.
Act with integrity and accountability; champion continuous improvement and the safe, reliable adoption of new tools and capabilities to improve reporting delivery.
Skills:
Proven track record of delivering regulatory and operational reporting in a regulated environment, with an accuracy-first mindset and a keen eye for detail.
Demonstrable experience of automating manual, recurring reporting processes and embedding validation, reconciliation and control checks to ensure trusted outputs.
Strong T-SQL skills, writing and optimising queries to build and support complex reporting and data transformations.
Advanced Excel knowledge, including the ability to analyse legacy spreadsheets and convert into automated solutions.
Experience of working with Power BI and Databricks is desirable.
Experience working with business stakeholders to obtain and document requirements, translating ambiguous business needs into well-governed solutions.
Experience working in an Agile and Scrum environment, combined with the ability to work autonomously as a confident self-starter who owns their own task list.
Strong problem-solving skills with a continuous improvement mindset, and the curiosity to learn new tools, patterns and skills quickly.
Good communication skills, with the ability to explain complex topics in an easy-to-understand manner for both technical and non-technical audiences.
Experience of querying data warehouse dimensional models is advantageous.
Familiarity with Azure data technologies, version control and CI/CD tooling (e.g. Azure DevOps, Git) for managing report and pipeline assets is advantageous.
Familiarity with specialty (re)insurance or Lloyd's market data (bordereaux, delegated authority, underwriting, claims) and associated regulatory returns is advantageous.
We offer all employees a comprehensive benefits package that focuses on their whole wellbeing. This includes hybrid working, a competitive base salary, non-contributory pension, discretionary bonus, insurances including health (family) and dental cover, and many other benefits to enhance financial, physical, social and psychological health.
About Canopius
Canopius is a global specialty lines (re)insurer. We are one of the leading insurers in the Lloyd’s of London insurance market with offices in the UK, US, Singapore, Australia and Bermuda.
At Canopius we foster a distinctive, positive culture which enables us to bring our whole selves to work to flourish as people, and build a business which delivers profitable, sustainable results.
Based in incredible new offices in the heart of the City of London, Canopius operates a flexible, hybrid working model and is committed to providing an environment that challenges employees to be their best and where everyone's unique contributions are recognised, valued and respected.
We are fully committed to equal employment opportunities for all applicants and providing employees with a work environment free of discrimination and harassment. All employment decisions are made regardless of age, sex, gender identity, ethnicity, disability, sexual orientation, socio-economic background, religion or beliefs, marital or caring status, or any other status protected by the laws or regulations in the locations where we operate. We encourage and welcome applicants from all diverse backgrounds.
We make reasonable adjustments throughout the recruitment process and during employment. Please let us know if you require any information in an alternate format or any other reasonable adjustments.
Skills Required
- Proven experience delivering regulatory and operational reporting in a regulated environment
- Experience automating manual, recurring reporting processes with validation, reconciliation, and control checks
- Strong T-SQL skills, including writing and optimizing queries for complex reporting and data transformations
- Advanced Microsoft Excel knowledge, including analyzing legacy spreadsheets and converting them into automated solutions
- Experience working with business stakeholders to gather and document requirements and translate ambiguous needs into governed solutions
- Experience working in an Agile and Scrum environment
- Ability to work autonomously as a self-starter and manage personal task priorities
- Strong problem-solving skills and a continuous improvement mindset
- Ability to learn new tools, patterns, and skills quickly
- Strong communication skills, including explaining complex topics to technical and non-technical audiences
- Experience working with Power BI
- Experience working with Databricks
- Experience querying data warehouse dimensional models
- Familiarity with Azure data technologies
- Familiarity with version control and CI/CD tooling such as Azure DevOps and Git
- Familiarity with specialty insurance or Lloyd's market data, including bordereaux, delegated authority, underwriting, claims, and regulatory returns
Similar Jobs
What We Do
Canopius is a global specialty and Property & Casualty (re)insurer serving clients through offices in the UK, the US, Bermuda, Singapore and Australia. The company provides underwriting and reinsurance coverage across more than 130 countries, using its international platform and broad market reach to support customers with specialty insurance solutions. Its business is focused on delivering world-class risk-transfer capacity across global markets.
