Data Analyst (SQL & Python)
Job Summary
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 reengineered and moved to a new server including controlled updates to semantic models to reflect backend 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 Pythonbased Tableau tooling.
What youll 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 reengineered and migrated to a new server including updating connections and applying controlled changes to semantic and data models to reflect backend 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 Pythonbased Tableau tooling and agreed engineering standards
- Planning and executing comprehensive testing and reconciliation activities to validate Tableau outputs against backend 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 businessasusual 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 peerreviewed and released through approved processes
Who were 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 highvolume datasets demonstrating excellent attention to detail through robust data testing reconciliation and clear evidencing of results
- Proven expertise in developing and maintaining highquality Tableau dashboards including workbooks data sources calculations extracts performance optimisation and bestpractice 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 engineeringfocused 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. Theres 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)
- There are the many discounts we offer both for our own products and at a range of high street stores and online
- Were creating netzero carbon workplaces by 2030 by investing in our sustainable modern offices across the UK all designed to bring people together and elevate the inperson experience
Additional Information :
At L&G we believe its possible to generate positive returns today while helping to build a better future for all.
If you join us youll 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 doesnt matter if you dont 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.
Remote Work :
No
Employment Type :
Full-time
About Company
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 th ... View more