Job Description

At Aberdeen our ambition is to be the UKs leading Wealth & Investments group.

Strengthening talent and culture is one of our strategic priorities. We strive to make Aberdeen a great place to work so that we can attract and retain the industrys best talent. Our people put our stakeholders at the heart of everything they do by helping us to make a positive difference to the lives of our clients customers colleagues shareholders and society. We are focused on growing our direct and advised wealth platforms and repositioning our specialist asset management business to meet client demand. We are committed to providing excellent client service supported by leading technology and talent.

Aberdeen comprises three businesses interactive investor (ii) Investments and Adviser each of which focuses on meeting and adapting to our clients evolving needs:

• interactive investor the UKs second largest directtoconsumer investment platform enables individuals in the UK to plan save and invest in the way that works for them.

• OurAdviserbusiness provides financial planning solutions and technology for UK financial advisers enabling them to create value for their customers.

• OurInvestmentsbusiness is a specialist asset manager that focuses on areas where we have both strength and scale to capitalise on the key themes shaping the market through either public markets or alternative asset classes.

About the Department

The Data Insights Team within the Data & Analytics department is dedicated to standardizing reporting processes establishing best practices and contributing to the development of a Centre of Excellence that enables scalable highquality analytics across the organization.

About the Role

As a PowerBI Developer you will be responsible for designing developing and optimizing Power BI reports and dashboards ensuring robust data models and seamless data integration. You will work closely with stakeholders to standardize reporting processes establish best practices and contribute to the development of a Centre of Excellence.

Key Responsibilities

• Data Modelling & Integration:Design and implement scalable efficient data models within Power BI. Define and enforce best practices for data modelling design and optimization. Collaborate with data engineering teams to establish a consistent and wellgoverned data architecture.

• Centre of Excellence Development:Define and document best practices governance frameworks and standardized methodologies for Power BI development. Promote data literacy and help teams leverage Power BI effectively while maintaining data integrity and security.

• Performance Optimization & Governance:Optimize DAX queries data refresh schedules and report performance. Implement data security controls user permissions and compliance standards in alignment with financial regulations.

• Continuous Improvement & Innovation:Stay updated with Power BI developments financial analytics trends and emerging technologies. Identify opportunities to streamline reporting processes and improve data accessibility.

• Dashboard & Report Development:Create userfriendly insightful Power BI dashboards that support business decisionmaking. Ensure reports follow best practices in data visualization and performance optimization.

• Collaboration & Engagement:Engage with team and business stakeholders to support best practice development and usage. Apply critical thinking to evaluate dashboard development requirements and ensure outcomes meet business needs.

About the Candidate

The ideal candidate will possess the following:

• Proven experience as a PowerBI Developer preferably in financial services banking or a related industry.

• Expertise in data modelling and integration with a deep understanding of star schema data transformations and Power Query.

• Strong proficiency in Power BI including DAX report/dashboard design and performance optimization.

• Knowledge of BI governance data security and compliance.

• Familiarity with SQL Python or R.

• Excellent stakeholder management and communication skills.

• Experience in establishing or contributing to a Centre of Excellence is desirable.

• Microsoft Power BI certification is desirable but not required.

We are a Disability Confident Committed employer and are happy to provide adjustments to the recruitment process to support candidates.

Our benefits

Theres more to working life than coming home with a good salary. We have an environment where you can learn get involved and be supported.

When you join us your reward will be one of the best around. This includes 40 days annual leave a 16 employer pension contribution a discretionary performancebased bonus (where applicable) private healthcare and a range of flexible benefits including gym discounts season ticket loans and access to an employee discount portal. You can read more about our benefitshere.

Our business

Enabling our clients to be better investors drives everything we do. Our business is structured around three distinct areas our vectors of growth focused on our clients changing needs. You can find out more about what we dohere.

An inclusive way of working

Whatever way you like to work if you have the talent and commitment to join our team wed like to hear from you.

At Aberdeen weve adopted a blended working approach. This approach combines the benefits of facetoface collaboration coaching and connecting in our offices with the flexibility of working from home. It enables colleagues to find a balance that works for their roles their teams our clients and our business.

An inclusive culture where diverse perspectives drive our actions is at the core of who we are and what we do. If you need assistance with your application or a reasonable adjustment to your interview arrangements for example because you are neurodivergent or have a physical sensory cognitive mental visible or invisible disability please let us know and well be happy to help.

Were committed to providing an inclusive workplace where all forms of difference are valued and which is free from any form of unfair or unlawful treatment. We define diversity in its broadest sense this includes but is not limited to our diversity of educational and professional backgrounds experience cognitive and neurodiversity age gender gender identity sexual orientation disability religion or belief and ethnicity and geographical provenance. We support a culture that values meritocracy fairness and transparency and welcomes enquiries from everyone.

If you need assistance or an adjustment due to a disability please let us know as part of your application and we will assist.