JSS
Business Intelligence Analyst

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job title: Data & Business Intelligence Analyst
Location: London (ideally)
Department: IT / Operations
Reporting to: Chief Operating Officer
The Opportunity
We are looking for an experienced Data & Business Intelligence Analyst to join a growing and dynamic organisation within the insurance sector. This is a highly visible role with the opportunity to help shape the organisation’s data and BI capabilities. Working closely with the COO, business leaders and a third-party BI team, you will take ownership of data structures, reporting and analytics, helping turn complex business data into meaningful insights that support better decision-making.
You’ll be equally comfortable getting into the detail of data schemas, SQL and reporting as you are working with senior stakeholders to understand business challenges and translate them into practical BI solutions.
What You’ll Be Doing
You will play a key role in developing and managing the organisation’s data and business intelligence capabilities, including:
- Understanding complex entity relationships within the insurance domain and translating them into effective, scalable data schemas.
- Managing the relationship with a third-party BI team to develop and maintain a robust data warehouse capable of supporting complex reporting requirements.
- Designing and developing intuitive reports and dashboards using Microsoft Power BI.
- Working with teams across the business to define reporting requirements and ensure data is accurate, consistent and meaningful.
- Managing role-based reporting and developing appropriate data models for different user groups.
- Analysing complex datasets to identify trends, patterns, risks and opportunities.
- Presenting findings and insights clearly to both technical and non-technical stakeholders.
- Developing and implementing processes that improve data management, reporting and decision-making.
- Conducting root cause analysis to identify issues and opportunities for improvement.
- Establishing and maintaining data governance frameworks to support data quality, integrity and security.
- Managing and optimising data sources, ETL processes and data warehousing solutions.
- Partnering with business leaders to understand their objectives and provide strategic, data-led recommendations.
- Conducting ad-hoc analysis to answer key business questions and support continuous improvement.
- Contributing to the organisation’s longer-term BI strategy and roadmap.
Reasons to use Rodeo
I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?
Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.
Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.
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.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.
See breakdownIt 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.
Why you're a good match
You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.
Experience fit
Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.
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.
What We’re Looking For


Get help with your application
Your very own career expert that helps elevate your application to the next level.
You will have:
- 5+ years’ experience in Business Intelligence, Data Analysis or a related role.
- Insurance industry experience, with a strong understanding of insurance terminology, data and business processes.
- Strong SQL skills and experience working with complex datasets.
- Hands-on experience with data visualisation and BI tools, ideally Microsoft Power BI. Experience with Tableau, SSRS or similar platforms will also be valuable.
- Experience working with data warehouses, ETL processes and data modelling.
- A strong understanding of data governance, data quality and data management principles.
- Familiarity with cloud-based data and BI environments such as Azure or AWS.
- Excellent analytical and problem-solving skills, with the ability to turn complex information into clear, actionable insights.
- Strong communication and presentation skills, including the ability to explain technical concepts to non-technical audiences.
- The confidence to work with senior stakeholders and external technology partners.
“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
Location