LiftmyCVLiftmyCV

Client Reporting Analyst

transamericaOn-siteEdinburgh, GB
AI job summary

Aegon Asset Management is seeking a Client Reporting Analyst to support the production of client, fund, and regulatory reporting for UK and US clients. This role involves utilizing SQL, Snowflake, and Power Query to improve reporting processes and working closely with stakeholders to ensure the accuracy and efficiency of reporting. The position requires strong analytical skills and attention to detail, with responsibilities including data analysis, automating reporting processes, and supporting client onboarding activities. Opportunities for continuous improvement and a collaborative work environment are emphasized.

Job description

Job Description Summary Job Description 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 Aegon Group 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)

We also offer private medical cover, life assurance, critical illness cover, enhanced parental leave and a variety of lifestyle benefits to help our staff live their best lives, including retail discount vouchers, cycle2work scheme, subsidised restaurant and online GP appointments. At Aegon Asset Management, we are committed to fostering a diverse workforce and an inclusive culture. We are more than a global Asset Management firm – we are a people business, and we recognise that delivering excellent client outcomes, comes from embracing diverse perspectives. We value diversity in the full range of human uniqueness without limitation including race, gender, ability, language, culture, beliefs, age, origin, background, perspectives and experiences. We are open to considering flexible working practices. Please talk to us about what this means for you.We serve a diverse, ever-changing world. It's tough, but we work tirelessly to leave things better than we find them. If that sounds like the sort of place you'd like to work, hit the "Apply" button.

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. Additional Job Description

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

Job details

Published
October 29, 2026
Apply by
November 15, 2026
Job source
myworkdayjobs
Workplace
On-site · Edinburgh, GB
First seen
October 30, 2026

Benefits

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 and a variety of lifestyle benefits including retail discount vouchers, cycle2work scheme, subsidised restaurant and online GP appointments.

Skills mentioned in this job

SQLSnowflakePower QueryExcel

LiftmyCV exclusive data

transamerica hiring intelligence

transamerica currently has 12 active jobs tracked by LiftmyCV. 12 new jobs in the past 7 days.

Active openings

12

Currently tracked by LiftmyCV

New in 7 days

12

12 new jobs in the past 30 days

Published salaries

83%

Median disclosed salary: $121,250

Average opening age

1 days

Across 12 active openings

Workplace breakdown

Remote0%
Hybrid8%
On-site92%

Hiring countries

United States of America
Netherlands

Top hiring cities

Cedar Rapids
Philadelphia
Schiphol
Denver

Most in-demand roles

  • • Director, DC Operations
  • • Intermediate Analyst - SCD Operations
  • • Lead Business Analyst
  • • Lead Development Engineer
  • • Master Process Engineer
  • • Regional Manager - Branch Supervision

Frequently requested skills

AWS
MS Excel
NoSQL
Python
SQL
Agile
Business Process Modeling
cash management

Median disclosed salary: $121,250 · 83% of jobs publish a salary

As of November 17, 2026

Hiring insights calculated from active jobs tracked by LiftmyCV.

AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at transamerica

Similar jobs from this company

Across the market

Similar jobs from other companies

Related job searches

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.