Client Reporting Analyst

Transamerica Corporation; City of Edinburgh; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Private medical cover

Cycle2work scheme

27 days leave

Job summary

Aegon Asset Management in Edinburgh is seeking a Client Reporting Analyst for a 12-month fixed-term contract to produce high-quality client, fund and regulatory reporting for UK and US clients. You will use Snowflake, SQL, Power Query and Excel to automate data extraction, validation, and reporting, collaborating with Client Services and other business teams and supporting onboarding of new clients.

Join a team focused on delivering exceptional client experiences while driving efficiency and

Qualifications

• Bachelor's degree in Finance, Business Administration, Investment Management or equivalent experience.
• Experience in client or fund reporting within asset management or financial services.
• Strong stakeholder management and communication skills across teams.
• Proficient SQL, Snowflake and Power Query for data extraction and reporting.
• Advanced Excel skills and handling large datasets.

Responsibilities

• Contribute to accurate and timely client, fund and regulatory reporting for internal and external stakeholders.
• Automate data extraction, transformation, validation and reporting with SQL, Snowflake and Power Query.
• Perform data analysis and QA to ensure reporting accuracy and completeness.
• Collaborate across Client Services, Investments, Operations, Risk, Compliance and Technology.
• Support onboarding of new clients and new reporting requirements.
• Participate in continuous improvement projects to enhance reporting processes and automation.

Skills

Stakeholder management

Communication

Attention to detail

Education

Bachelor's degree in Finance

Tools

SQL

Snowflake

Power Query

Excel

Job description

Job Description Summary

Client Reporting Analyst – 12 month Fixed Term Contract.

Location: Edinburgh. Closing date: 15 November 2026.

Aegon Asset Management is a leading global investor, our employees work from 13 locations across Europe, the Americas and Asia. We advise on assets for a global client base of pension plans, public funds, insurance companies, banks, wealth managers, family offices and foundations. We share a common belief in fundamental, research-driven active management, underpinned by effective risk management and a commitment to responsible investment. Our people are our greatest asset, and we want Aegon Asset Management to be a place where they can bring their authentic self to work and do all they can to deliver on our strategic promises to our customers. We help people live their best lives. We help them with the big stuff, for the moments that matter.

The Role

We are seeking a Client Reporting Analyst who is looking to build and develop a career within asset and investment management. This role offers exposure to a broad range of stakeholders, including AegonGroup clients, fund administrators, external auditors, regulators and multiple internal teams. You will join the Client Reporting team, which is responsible for delivering high-quality client, fund, and regulatory reporting across an international client base.

The team is focused on providing an exceptional client experience while continuously driving operational efficiency and innovation. This role supports the production and oversight of client, fund, and regulatory reporting for our UK and US clients.

You will utilise a range of tools and applications, including Snowflake, SQL, Power Query, Excel and Clearwater Prism, to produce, automate, and review a variety of client and fund reports prior to distribution. Working closely with Client Services and other business stakeholders, you will also support the implementation of new reporting requirements and client onboarding activities.

Key responsibilities for the role include:

• Contribute to the accurate and timely production of client, fund, and regulatory reporting for internal and external stakeholders.
• Leverage SQL, Snowflake, and Power Query to automate data extraction, transformation, validation, and reporting processes, improving efficiency, scalability, and data quality.
• Perform data analysis and quality assurance activities to ensure reporting accuracy and completeness.
• Collaborate with stakeholders across Client Services, Investments, Operations, Risk, Compliance, and Technology to deliver high-quality reporting solutions and maintain strong client outcomes.
• Support the onboarding of new clients and the implementation of new reporting requirements.
• Participate in business change initiatives and continuous improvement projects to enhance reporting processes, controls, and automation capabilities.
• Identify opportunities to streamline workflows and reduce manual processes through technology and process optimisation.
• Assist in investigating and resolving reporting issues, ensuring timely communication and resolution.

We’d love to hear from you if you have:

• A Bachelor's degree in Finance, Business Administration, Investment Management, or a related field, or possess equivalent professional experience.
• Have experience in client reporting, fund reporting, performance reporting, or regulatory reporting within the financial services or asset management industry.
• Demonstrate strong stakeholder management and communication skills, with the ability to build effective working relationships across multiple teams.
• Possess strong SQL skills, including query development, optimisation, complex data analysis, and data validation.
• Have hands‑on experience using Snowflake and Power Query to develop and maintain reporting and data transformation solutions.
• Have advanced Excel skills and experience working with large datasets.
• Are highly organised, detail‑oriented, and able to manage multiple deadlines in a fast‑paced environment.
• Have a continuous improvement mindset and a passion for leveraging technology and automation to enhance reporting processes.

It would also be beneficial to have:

• Asset management industry knowledge.
• Experience with asset management platforms such as Clearwater Prism and/ or Alladin.

What’s in it for you?

• A competitive salary, depending on the experience you can bring
• A non‑contributory pension between 9%-13%
• A discretionary bonus, depending on personal and company performance
• 27 days leave per year (plus bank holidays, pro‑rated for part‑time)
• Private medical cover
• Life assurance
• Critical illness cover
• Enhanced parental leave
• Retail discount vouchers
• Cycle2work scheme
• Subsidised restaurant
• Online GP appointments

Equal Opportunity Employer:

We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age.

We serve a diverse, ever‑changing world. It's tough, but we work tirelessly to leave things better than we find them.

Aegon Asset Management is a global, active investment manager. We use our investment management expertise to help people achieve a lifetime of financial security, with a focus on excellence, trust and partnership. Our clients benefit from the extensive international research capabilities and in‑depth local knowledge.

Aegon Asset Management is part of Aegon Group, one of the world's leading financial services organizations, providing life insurance, pensions and asset management.

People are fundamental to the success of our business. By promoting individual accountability and strong teamwork, we’re able to give all of our people the freedom to get on with doing so, whether the individual’s function is financial, technical or creative.

Join our diverse teams around the world in a relaxed and professional working environment.

The reward? Great benefits and the recognition you deserve.

California residents may find additional information about the processing of their personal data HERE, including information about their right to opt out of the sale or sharing of personal information, and may submit an opt‑out request HERE.

The legal bits

We’ll need you to confirm you have the right to work in the UK. If we offer you a job and you accept, there are some checks we need to complete before you can start with us. This will include a credit and criminal record check, as well as providing satisfactory references.