How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Lockton Data Analyst Role
As Lockton’s continued investment in Data and MI the appetite for data is only increasing and is highly valued by senior management. As a result, we are looking to recruit the appropriate data individual to join the team.
First and foremost, the right candidate must fit in with Lockton’s culture. At Lockton we value the following principles:
- Client first
- Results and impact driven
- Self-motivated
- Continuous improvement
Role Responsibilities
- Partner with business stakeholders to gather, challenge, and translate reporting and analytics requirements.
- Extract, transform, analyse, and interpret data from multiple sources to support business decision-making.
- Design, develop, and maintain Power BI reports and semantic models.
- Write efficient, scalable SQL queries to support reporting.
- Deliver insights and recommendations that help stakeholders understand trends, performance, risks, and opportunities.
- Collaborate with technical and non-technical teams to promote a data-driven culture across the organisation.
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.
Candidate Profile
We are seeking a proactive and analytical individual who enjoys solving complex data challenges and turning information into valuable business insight.
- Comfortable working in a fast-paced environment where priorities can evolve quickly and will demonstrate the ability to manage multiple stakeholders and competing demands.
- A strong desire to learn, develop, and continuously improve is essential.
Must have skills:
-
Power BI
- End-to-end development of Power BI solutions, including:
- Data ingestion and transformation (Power Query)
- Data modelling
- DAX development and optimisation
- End-to-end development of Power BI solutions, including:
-
SQL & Data Analysis
- Strong SQL development skills, including query optimisation and troubleshooting.
- Solid understanding of relational database design and data modelling principles.
- Experience analysing large and complex datasets to identify trends and business opportunities.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
- Excel
- Advanced Excel skills, including:
- Power Query
- Power Pivot
- Complex formulas and modelling techniques
- Advanced Excel skills, including:
Preferred Skills:
- Experience working with Databricks in a modern data platform environment.
- Knowledge of dbt (Data Build Tool) for data transformation and modelling.
- Familiarity with cloud-based data platforms, particularly Microsoft Azure.
- Experience working with data engineering or ETL pipelines.
- Exposure to version control and collaborative development practices (e.g., Git/GitHub).
- Experience working within financial services, insurance, or other highly regulated industries.
“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
Location