Senior Power BI Developer – Investments Technology Services, Aberdeen
As a Senior Power BI Developer within the Investments team, you will lead the design, development, and optimisation of BI solutions that deliver actionable insights to support strategic investment decisions. You will play a key role in shaping our BI architecture and mentoring others in best practices.
About The Department
Investments Technology Services forms part of the Operations division within Aberdeen. Its key function is to provide global technology services that, when combined with the intellectual capital within Aberdeen, create value for our clients. It achieves this by developing and maintaining a technology strategy and architecture that is aligned to the company’s operating model and designed to enable the implementation of business strategy. Investments Technology Solutions also contains the capabilities necessary to execute against that strategy, to provide robust and appropriate solutions, all within a context of positive assurance ensuring activities are conducted in line with standards, policies and commercial targets.
About The Role
As a Senior Power BI Developer within the Investments team, you will lead the design, development, and optimisation of BI solutions that deliver actionable insights to support strategic investment decisions. You will play a key role in shaping our BI architecture and mentoring others in best practices.
Key Responsibilities
* Design and develop interactive Power BI reports and dashboards, determine optimal data loading methods (memory, Fabric, DirectQuery), re-use existing data flows and datasets, and build robust data models using DAX and visualization techniques.
* Integrate data from multiple sources, ensure accuracy and consistency, and develop and maintain ETL processes to streamline data flow into Power BI.
* Maintain an inventory of reusable Power BI components including Fabric Shortcuts, Models, Datasets, and Dataflows.
* Collaborate with investment analysts, portfolio managers, and other stakeholders to understand data needs and deliver tailored BI solutions, aligned with the wider BI team’s strategy and best practices.
* Optimize Power BI reports and dashboards for performance and usability, implementing best practices for data visualization and user experience.
* Provide training and consultancy to business users on Power BI tools, and support self-service BI by assisting users in developing their own reports and dashboards.
* Stay current with Power BI features and industry trends, continuously seeking opportunities to enhance BI solutions and processes.
About The Candidate
The ideal candidate will possess the following:
* Proven experience as a Power BI Developer, ideally within the Investments sector.
* Experience working with stakeholders to understand requirements.
* Strong proficiency in Power BI, including data modelling, DAX, and Power Query.
* Experience with SQL and data integration techniques.
* Experience with Alteryx is desirable.
* Excellent analytical and problem-solving skills.
* Strong communication and collaboration abilities.
* Commitment to continuous learning and professional development.
We are proud to be a Disability Confident Committed employer. If you have a disability and would like to apply to one of our UK roles under the Disability Confident Scheme, please notify us by completing the relevant section in our candidate questionnaire. One of our team will reach out to support you through your application process.
Our Benefits
There’s 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 performance-based bonus (where applicable), private healthcare and a range of flexible benefits – including gym discounts, season ticket loans and access to an employee discount portal.
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.
An inclusive way of working
Whatever way you like to work, if you have the talent and commitment to join our team, we’d like to hear from you. Aberdeen supports a blended working approach with flexibility for working from home where appropriate. We are committed to an inclusive culture where diverse perspectives drive our actions. If you need assistance with your application or an adjustment to interview arrangements due to disability or other needs, please let us know and we’ll help.
We’re committed to a diverse, inclusive workplace free from unfair or unlawful treatment. We value meritocracy, fairness and transparency and welcome enquiries from everyone.
Seniority level
* Mid-Senior level
Employment type
* Full-time
Job function
* Information Technology
#J-18808-Ljbffr