Risk Automation and Data Solutions Specialist in Edinburgh

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.

You will play a key part in modernising and streamlining risk processes by designing and delivering robust data solutions across the risk function. In this role, you will gather and translate business requirements into clear data specifications, build and maintain data models and tables that integrate information from multiple sources such as Snowflake and Excel and develop dynamic Power BI dashboards that enhance insight and support decision‑making.

You will ensure high standards of data quality and governance while collaborating closely with stakeholders to create effective, scalable, and user‑focused technical solutions that reduce manual effort and strengthen analytical capabilities across the team.

• Gathering and documenting data requirements, producing clear and detailed data specifications.
• Designing and building data tables and models, integrating data from multiple sources (e.g., Snowflake, Excel).
• Developing and maintaining dynamic Power BI dashboards and reports to support business objectives.
• Ensuring data quality, consistency and compliance with data governance standards.
• Collaborating with stakeholders to understand business needs and translate them into effective technical solutions.

• Advanced proficiency in Power BI, including data modelling, DAX and visualisation best practices.
• Experience with Snowflake or similar cloud data platforms.
• The ability to integrate and manipulate data from diverse sources, including Excel.
• Solid understanding of data architecture and ETL concepts.
• Excellent analytical and problem-solving capabilities.
• Strong communication skills with the ability to engage stakeholders effectively.
• Experience in financial services or risk management (preferred).
• Familiarity with project delivery frameworks and agile methodologies is a plus.

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, and 27 days leave per year (plus bank holidays, pro-rated for part-time) are offered. We also provide 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.

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.