Skip to main content
Back to jobs

Data Analyst (SQL & Python)

External
Legalandgeneral logoLegalandgeneral · Cardiff, UK
Full-timeOn-site1d ago
CI/CDData AnalysisDocumentationGitGitHubPython
Cover LetterConnect

Prepare for this interview

Elite

AI-generated questions, company research, and talking points tailored to this role


Responsibilities

  • 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
  • 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
  • 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

Benefits

Health insurancePerformance bonus

Additional Information

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.


Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Legalandgeneral? Share your experience

Interested in this role?

Apply on the company's website.

Cover LetterConnect