Rodeo
Get started

Chartered Insurance Institute

Data Analyst/Engineer

London
£75k/yr
Posted about 22 hours ago
Sign up to applySee more jobs like this

How your CV stacks up

1Upload CV
2Analyse CV
3Improve CV

Upload your CV to see how well it fits this job role

?%

The Vacancy

Data Analyst/Engineer

Hybrid, London - City

Full time, 12 Month FTC

Salary: Up to £75,000

Job Purpose

The Data Analyst will play a pivotal role in ensuring the integrity, accessibility, and usability of our data systems while contributing to the broader strategic goals of the organisation and will report to the Data Architect.

The directorate delivers outstanding services to members, customers and the wider sector through a modern, customer-centric approach. By leveraging innovative technology, it provides an exceptional customer and member experience; harnesses the power of data to generate meaningful insights that create value for the Institute and its members; and delivers impactful programmes of work that drive sustainable value, operational excellence and meaningful outcomes for stakeholders.

Key Responsibilities

Data Analysis and Reporting

  • Conduct detailed analysis of large datasets to identify trends, anomalies, and actionable insights.
  • Collaborate with business units to understand data requirements and deliver solutions that align with their goals.
  • Ensure data models support accurate and scalable reporting, by configuring data integrity exception models and insights.
  • Develop and maintain Power BI dashboards, reports, and visualisations to provide insights for stakeholders.

Data Engineering

  • Assist the Enterprise or Data Architect in designing, building, and maintaining scalable ingestion data pipelines for the integration of diverse systems.
  • Optimise data workflows and processes to ensure efficiency and reliability.
  • Collaborate on database design and support database optimisation to enhance performance and scalability.

Data Governance and Compliance

  • Support the implementation of data governance frameworks to ensure data quality, consistency, and regulatory compliance.
  • Work alongside the Data Architect to ensure data security measures align with GDPR and organisational policies.
  • Monitor and maintain data accuracy through validation processes and cleansing activities.
  • Assist in the management of data subject access requests and breach notifications, as needed.
  • Work with DPO to build Records of Processing Activity.
  • Assist the Data Architect with building data flow maps for business processes.

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.

P

Graduate Consultant — 2026 Scheme

PwC·London, UK
£35,000/yr

Why you're a good match

Strong

Your 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 breakdown
Save jobNot relevant
View details

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.

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.

See breakdown
Strong

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.

See breakdown
Strong

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.

Collaboration and Stakeholder Engagement

  • Work closely with the Data Architect to align data solutions with strategic organisational goals.
  • Collaborate with IT, project managers, and business analysts to support data-driven projects and ensure effective data utilisation.
  • Work with business stakeholders to ensure effective data process maps are established for “as is” and “to be” states.
  • Train business users on self-service analytics tools, including Power BI, to promote data literacy across the organisation.

Innovation and Continuous Improvement

  • Identify opportunities to enhance data processing and reporting capabilities using modern tools and technologies.
  • Stay up-to-date on emerging trends and best practices in data analysis, engineering, and visualisation.
  • Proactively suggest and implement improvements to current data workflows and reporting processes.

Key Requirements

Educational Background

  • Required, certifications in Power BI, Azure, Data Analytics or related data technologies
  • Desirable bachelor's degree in data science, Computer Science, Mathematics, Statistics, or a related field.

Essential Skills And Experience

  • Proven experience in data engineer and analysis and reporting, including advanced Power BI / MS Fabric/Power platform skills.
  • In-depth knowledge of SQL for querying and managing relational databases.
  • Hands-on experience with ETL/ELT processes, data pipelines, and database technologies (e.g., SQL Server, Azure SQL, My SQL, DB2).
  • Hands-on experience with big data technologies.
  • Knowledge of data modelling and schema design for both structured and unstructured data.
  • Strong knowledge of GDPR compliance and data governance best practices.
  • Proficiency in integrating and working with various systems, including CRM and ERP platforms such as Microsoft Dynamics 365.
  • Experience working in Agile and DevOps environments.

Desirable Skills

  • Basic understanding of cloud data management services (e.g., Azure, AWS).
  • Knowledge of data migration processes and legacy system integration.

Personal Attributes

  • Strong analytical and problem-solving skills with a keen eye for detail.
  • Excellent communication and interpersonal skills for cross-functional collaboration.
  • A proactive mindset, able to manage multiple priorities in a dynamic environment.
  • A commitment to delivering high-quality results while ensuring compliance and data security.

Get help with your application

Your very own career expert that helps elevate your application to the next level.

Get help applying for this job

Interview Process

We understand that taking time to prepare for and to attend interviews is a big commitment and want the process to be as transparent as possible.

You Can Expect The Following Process From Us

  • A short, introductory phone call from our Talent Acquisition team.
  • A formal 1st Stage Teams interview with the representatives of Data and Business Solutions & Programme Delivery teams.
  • A formal 2nd Stage (Teams/In-person TBC) interview with leadership representatives of the Business Solutions & Programme Delivery Team.

Application Deadline

We will review applications on a rolling basis, and the position will close once we have secured a shortlist.

Next Steps

If you would like to explore this opportunity with us for the next step in your career, we look forward to receiving your application through the Apply feature at the top of this advert.

If you have any queries or you would like to see the full JD, please get in touch on ukjobs@cii.co.uk.

We are an inclusive employer and welcome applications from all backgrounds. If you require any reasonable adjustments during the recruitment process, please let us know. We are committed to ensuring all candidates have equal access and opportunity, in line with the Equality Act 2010.

Please note: At the CII, we work with a carefully selected Preferred Supplier List (PSL) for recruitment. We do not accept speculative CVs and kindly request that agency recruiters do not contact our managers directly, to ensure a consistent and properly coordinated recruitment process.

If you are interested in working with us in the future, please contact ukjobs@cii.co.uk. We review our PSL at set intervals and are happy to retain details for consideration when opportunities arise.

Agencies who do not follow this process will be excluded from any future opportunities to work with us, including PSL reviews.

Trusted by 25,000+ job seekers

“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

Get help applying for this job

Skills

Data Analysis
Data Engineering
Power BI
SQL
ETL/ELT
Data Pipelines
Data Modelling
Schema Design
GDPR Compliance
Data Governance
Microsoft Dynamics 365
Azure
MS Fabric
Agile
DevOps
Data Visualisation

Location

London, England, United Kingdom

Sign up to applySee more jobs like this