Data Analyst in London

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. Using AI coding assistants (e.g. Claude Code, approved tools), alongside SQL/Python to deliver faster, reliable, well‑governed analytics solutions in a regulated environment.

What you’ll be responsible for:

• 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) rather than one‑off analysis.
• Turn recurring work into reusable components (templates, shared queries, documented metric definitions).
• Hands‑on experience with Claude Code/coding assistants and knowing how to use them safely and effectively.
• Strong SQL + Python (with a “production mindset”: clarity, performance, reproducibility).
• Comfort with Snowflake + Power BI (and cloud exposure like Azure/AWS if you want it explicit).
• Strong judgement on when to trust vs. verify AI outputs.

About you:

Key Skills:

• Ability to work autonomously and as part of a team.
• Confident at managing relationships and communicating at all levels.
• Delivery oriented and able to work under pressure in a complex business environment.
• Analytical and problem‑solving skills – apply analytical techniques to present a solution.
• Data profiling, data cleansing, and data enrichment skills.
• Data visualisation – interpret requirements and present data in a clear and compelling way.

Technical Knowledge:

• Modern Workplace, remote working, O365 Productivity stack.
• Cloud service experience - AWS and/or Azure.
• Databases – SQL Server, Oracle, NoSQL.
• SQL, Microsoft Excel.
• Data Integration tools (Talend, SSIS).
• Cloud based Big Data frameworks such as data lake, relational and NoSQL databases.
• Visualisation tools.
• Data modelling tools.
• Hands‑on experience with Claude Code/coding assistants and knowing how to use them safely and effectively.
• Strong SQL + Python (with a “production mindset”.)
• Comfort with Snowflake + Power BI (and cloud exposure like Azure/AWS if you want it explicit).
• Strong judgement on when to trust vs. verify AI outputs.

Communication and Collaboration:

• Excellent communication skills to engage with stakeholders at all levels.
• Ability to coach and support colleagues in data roles.

Our offer to you:

We offer a comprehensive remuneration package, which we review regularly, and benefits include:

• A company pension – 9% non‑contributory or 10% if you contribute 5%.
• Private medical insurance – Individual on joining, family after 1 year’s service.
• Life assurance – 8 × salary.
• Company share scheme.
• Discretionary bonus.
• Flexible holidays – purchase up to 5 additional days.
• Green Car Scheme.
• Family friendly policies – enhanced family leave for parents & carers.
• Study support – study days and funding for courses and qualifications.
• Season travel ticket loans.
• Other voluntary benefits you can choose to suit you.

Equal Opportunity:

We are committed to building a team that is made up of diverse skills, experiences and abilities and encourage applications from all backgrounds. We welcome individuals who share our values. We’re a Disability Confident Employer (level 2) under the UK Government scheme. If you require adjustments to apply for a role at Rathbones, please contact us to let us know what adjustments you may need.