Client Reporting Engineer
3 days ago
Glasgow
Company description: At Rathbones, we help people invest their money well, so they can live well. That means more than financial returns its about helping people feel confident in their decisions and supported in their future. We dont just manage money, we guide people through lifes big moments, helping them stay on track and focus on what matters most. Were proud to be one of the UKs leading wealth managers, with over £109bn* in assets under management and 20+ offices across the UK and Channel Islands. Were a FTSE 250 company with national reach and a local feel and were growing. *As of June 2025 Job description: Role Title: Client Reporting Engineer Division: Group Technology Location: Glasgow, Liverpool or London Contract: Permanent Working pattern: Hybrid About the Role Be part of how Rathbones brings client data to life. As a Client Reporting Engineer, youll convert complex financial and valuation information into polished, visually engaging, client-ready reports that reflect the quality of our brand. This is a hands-on role blending technical expertise with attention to detail, where youll build robust data solutions, optimise performance, and deliver high-impact reporting to tight deadlines within a leading wealth management firm. What youll be responsible for Build and modify reporting layouts in client reporting layout building tools, including introduction pages, charts, tables, and performance pages. Write and optimize SQL queries, macros, and functions to perform complex data transformations. Monitor and optimise data build tool models and transformations for performance, including query optimisation Create and maintain comprehensive data documentation, including ETL/ELT processes, models, and business logic. Monitor and troubleshoot data build tool jobs and pipelines to ensure they run efficiently and meet SLAs. Translate valuation models and financial data into clear, structured narratives and visuals. Ensure correct alignment, colour palettes, branding, and layout structure across all output pages and ensure that they are applied consistently. Manage report timelines to meet client reporting deadlines. Support time critical mass report production runs. About you If you meet some of these criteria and are excited about the role, we encourage you to apply Experience in designing and producing professional client reports with strong document design and layout skills. Experience with data build tools, SQL and stat modelling techniques. Hands on experience with cloud-based data platforms (AWS, Azure). Knowledge of data pipelines, ETL/ELT frameworks, and data orchestration tools Experience in Snowflake data warehouse, Power BI and Alteryx reporting tools is desirable. Ability to present complex financial information clearly. Strong written skills required to produce documentation that is concise and accurate. Excellent verbal communication skills with the ability to communicate with a varying level of stakeholders both IT and business to develop strong professional relationships. Strong Service focus, looking to increase benefit to internal customers and clients through service excellence. We offer: Our offer to you We want everyone at Rathbones to fulfil their potential, in an environment where you are proud to work and feel like you belong. 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 years service Life assurance - 8 x salary Income protection 75 % salary Company share scheme Flexible holidays purchase up to 5 additional days Discretionary bonus 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 Volunteering days Gym discounts Other voluntary benefits you can choose to suit you Our employees can choose to take part in various social groups and communities to support their wellbeing, growth, development and sense of community.These include: Sports & Social Committees , such as cricket, football, netball, running, yoga, quiz nights, charity bake sales and much more. Inclusion Networks that help us drive change within the organisation such as Gender Balance, Multicultural, Abilities Count, Pride, Social Mobility, Generations, Take a moment to pause (Menopause) and Armed Forces. The NextGen IM Network , which brings together a community of trainees from across the UK, who are all at the early stages of their careers and offers development opportunities, exposure across the business as well as peer support and connection. Life at Rathbones We aim to become an employer of choice for the wealth management sector, to achieve this we are working hard to build a diverse, equal, and inclusive workplace that motivates, develops and embraces the strengths of all our colleagues. Being part of Rathbones means you will join a team of passionate professionals in a successful culture that cares for its people. At Rathbones, we provide meaningful work, opportunities, and a voice to all. 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. Were a Level 1 Disability Confident employer under the UK Government scheme. This means weve signed up to a set of commitments around how we recruit, retain and develop people with disabilities. Find out more about the Government Scheme online. If you feel there are any reasonable adjustments that would make the process easier for you and help you to perform at your best whether that is due to disability, neurodiversity or other protected characteristic, just let us know by emailing us at Mission We believe in playing the long game. That means building consistent results, earning trust and doing the right thing for our clients, our colleagues and the communities were part of. Our values shape how we work: - We aim high - We get it done - We show we care - We do the right thing These arent just words on a wall. They guide how we treat each other, how we make decisions and how we build relationships that last. We will close this advert once we have received enough applications for the next stage. Please submit your application as soon as possible to ensure you dont miss out. TPBN1_UKTJ