LegalAndGeneral
Data Analyst (SQL & Python)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Company Description
Legal & General (L&G) is a leading UK financial services group and major global investor.
We’ve been safeguarding people’s financial futures since 1836, and strive to build a better society, while improving the lives of our customers and creating value for shareholders.
We are one of the world’s largest asset managers and provide powerful asset origination capabilities. Together, these underpin our retirement and protection solutions: we are an international player in pension risk transfer, in UK and US life insurance, and in UK workplace pensions and retirement income.
Our Group Functions provide the services that all areas of the business need. This requires a talented and diverse team behind the scenes, who enable everyone at L&G to do what they do best.
Joining us means helping to improve the lives of our customers and contributing to the success of the business every day.
Job Description
We are seeking a skilled Data Analyst to support the GDFP IFRS 17 reporting platform, focusing on the development, maintenance, and enhancement of Tableau dashboards and data models within a highly controlled reporting environment.
The role will lead the migration of Tableau workbooks and data sources as Snowflake platforms are re‑engineered and moved to a new server, including controlled updates to semantic models to reflect back‑end changes. A strong emphasis will be placed on testing, reconciliation, and documented assurance to ensure reports align with governed data and reporting requirements.
You will work within established SDLC and change processes, producing required artefacts, and contribute to the maturation of Tableau development practices, including the introduction of CI/CD using Git/GitHub and Python‑based Tableau tooling.
What you’ll be doing:
- Designing, developing, and maintaining Tableau dashboards, data sources, and extracts on the GDFP IFRS 17 platform, ensuring outputs are accurate, performant, and aligned to governed reporting standards
- Delivering Tableau migration activities as Snowflake data sources are re‑engineered and migrated to a new server, including updating connections and applying controlled changes to semantic and data models to reflect back‑end updates
- Contributing to the advancement of Tableau development practices by helping implement stronger SDLC controls, including version control (Git/GitHub), CI/CD pipelines, and deployment automation using Python‑based Tableau tooling and agreed engineering standards
- Planning and executing comprehensive testing and reconciliation activities to validate Tableau outputs against back‑end data, producing clear, auditable evidence and required artefacts such as test scripts, reconciliation results, and Test Completion Reports
- Collaborating closely with the wider IFRS 17 platform teams, including data engineering, QA, governance, and business stakeholders, to gather requirements, triage issues, and deliver change through defined processes and timelines
- Providing business‑as‑usual support for Tableau dashboards and data sources, including monitoring, incident and defect investigation, performance optimisation, and timely resolution in line with operational expectations
- Using SQL (Snowflake) and Tableau best practices to design and maintain robust datasets and data models, including joins, aggregations, and calculations, to enable consistent reporting and scalable dashboard development
- Operating effectively within a controlled and audited environment by adhering to governance and security standards, maintaining comprehensive documentation and artefacts (e.g. Change Requests, Implementation Plans, runbooks, user guides), and ensuring all changes are traceable, peer‑reviewed, and released through approved processes
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.
Who we’re looking for:
- A degree in a technical or numerate discipline, a Level 4 apprenticeship in a relevant field, or equivalent professional experience, with a focus on data analysis and visualisation
- Strong experience working with high‑volume datasets, demonstrating excellent attention to detail through robust data testing, reconciliation, and clear evidencing of results
- Proven expertise in developing and maintaining high‑quality Tableau dashboards, including workbooks, data sources, calculations, extracts, performance optimisation, and best‑practice visual design
- Experience designing and maintaining reporting datasets and data models (e.g. star or semantic layers) using SQL, with the ability to adapt models as upstream Snowflake data sources evolve
- Demonstrated ability to improve and automate analytics and reporting delivery processes, including repeatable deployments, standardised testing, and reusable components, to reduce manual effort and operational risk
- Strong technical capability across SQL (ideally Snowflake) and advanced Tableau features; experience with Python, Git/GitHub, CI/CD concepts, or data preparation tools (e.g. Alteryx) is advantageous
- Comfortable working across multiple datasets and environments in a controlled and governed delivery model, collaborating effectively with data engineering and business stakeholders
- A disciplined, engineering‑focused mindset, able to manage workload independently while contributing proactively to standards, peer reviews, testing, documentation, and continuous improvement
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Benefits
Whatever your role, we reward performance and behaviour with a package that looks after all the things that are important to you. Here are some of the benefits we offer:
- The opportunity to participate in our annual, performance -related bonus plan and valuable share schemes
- Generous pension contribution
- Life assurance
- Healthcare Plan (permanent employees only)
- At least 25 days holiday, plus public holidays, 26 days after 2 years’ service. There’s also the option to buy and sell holiday
- Competitive family leave
- Participate in our electric car scheme, which offers employees the option to hire a brand-new electric car through tax efficient salary sacrifice (permanent employees only)
- Discounts on our own products and at a range of high street stores and online
- We’re creating net‑zero carbon workplaces by 2030 by investing in our sustainable, modern offices across the UK, all designed to bring people together and elevate the in‑person experience
Additional Information
At L&G, we believe it's possible to generate positive returns today while helping to build a better future for all.
If you join us, you’ll be part of a welcoming, inclusive culture, with opportunities to collaborate with people of diverse backgrounds, views, and experiences. Guided by leaders with integrity who care about your future and wellbeing. Empowered through initiatives which support people to develop their careers and excel.
We care passionately about outcomes rather than attendance and are therefore open to discussing all kinds of flexible working options including part-time, term-time and job shares. Although some roles have limited flexibility due to customer demand, we accommodate requests when we can.
It doesn’t matter if you don’t meet every single criterion in this advert. Instead, think about what you excel at and what else you can bring in terms of strengths, potential and connection to our purpose.
Permanent/Regular or Fixed Term Contract/Temporary: Fixed Term Contract (UK and ROW) / Temporary (US)
L&G Business Unit: Legal & General Group IT & Digital
L&G sub Business Unit: GROUP COO1
Primary Location: London, One Coleman Street
Job Family: IT & Change
“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