Data Analyst

At Rathbones, we help people invest their money well, so they can live well. That means more than financial returns – it's about helping people feel confident in their decisions and supported in their future. We don't just manage money, we guide people through life's big moments, helping them stay on track and focus on what matters most.

About the Role The Data Analyst works closely with Business and Product teams to develop strategic data platforms. Possessing a balanced mix of technical and business skills, Data Analysts are responsible for defining organisational data assets, manipulating and linking datasets to support decision‑making across the firm. They use AI coding assistants (e.g.

ClaudeCode) alongside SQL/Python to deliver faster, reliable, well‑governed analytics solutions in a regulated environment. Responsibilities Work with Data colleagues and Business Data Offices to deliver strategic initiatives aligned to organisational objectives. Analyse data using statistical techniques and communicate insights effectively to senior stakeholders.

Examine and improve data quality, collaborating with change and technology teams to enhance systems and database design. Summarise and present complex data and conclusions in formats appropriate to the audience. Embed best‑practice data standards and ways of working across the organisation.

Act as a representative of the Data function, supporting a collaborative and data‑driven culture. Use AI assistants to accelerate SQL/Python development, refactoring, analysis and documentation. Apply disciplined validation (sense checks, reconciliations, peer review/testing where appropriate), especially for AI‑generated outputs.

Build repeatable, deployable outputs (curated datasets, automated reporting, dashboards), not one‑off analysis. Turn recurring work into reusable components (templates, shared queries, documented metric definitions). Hands‑on experience with ClaudeCode or other coding assistants and knowledge of how to use them safely and effectively.

Strong SQL and Python skills with a production mindset (clarity, performance, reproducibility). Comfort with Snowflake and PowerBI, and cloud exposure such as Azure or AWS. Strong judgement on when to trust versus verify AI outputs.

Qualifications Ability to work autonomously and as part of a team. Confidence at managing relationships and communicating at all levels. Deliveryoriented and ability to work under pressure in a complex business environment.

Analytical and problem‑solving skills – applying analytical techniques to present a solution. Data profiling, data cleansing, and data enrichment skills. Data visualisation – interpreting requirements and presenting data clearly and compellingly.

Technical knowledge: Modern Workplace, remote working, O365 Productivity stack, cloud services (AWS and/or Azure). Databases – SQL Server, Oracle, NoSQL, SQL, MicrosoftExcel. Data integration tools (Talend, SSIS), cloud‑based big‑data frameworks such as data lake, relational and NoSQL databases.

Visualisation tools and data‑modeling tools. Strong SQL and Python with a production mindset. Comfort with Snowflake and PowerBI, and cloud exposure (Azure or AWS).

Strong judgement on when to trust versus verify AI outputs. Excellent communication skills to engage stakeholders at all levels. Ability to coach and support colleagues in data roles.

Benefits Company pension – 9% non‑contributory or 10% if you contribute 5%. Private medical insurance – individual from joining, family after 1year of service. Life assurance – 8× salary.

Income protection – 75% of salary. Company share scheme. Discretionary bonus.Flexible holidays – purchase up to 5 additional days.

Green Car Scheme. Family‑friendly policies – enhanced leave for parents & carers. Study support – study days and funding for courses and qualifications.

Season travel ticket loans. Volunteering days. Gym discounts.

We are a Disability Confident Employer (level2) under the UK Government scheme. This means we've signed up to a set of commitments around how we recruit, retain and develop people with disabilities. #J-18808-Ljbffr