Power BI Developer

PD&MS Group; Huntly; Hybrid; GBP 32,000 - 53,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

PD&MS Group in Aberdeen seeks a BI specialist with extensive experience in the Microsoft BI stack and Microsoft Fabric to design, develop and maintain Power BI reports and data models. You will work across data warehousing efforts, ensuring data quality and secure, scalable solutions in a hybrid environment.

The role requires a degree in a relevant subject (masters preferred) and strong English communication.

Qualifications

• Requires significant experience using Microsoft Fabric and the Microsoft BI Stack (Power BI, SSAS, SSRS, SSIS).
• Demonstrable experience in data preparation, data warehousing and BI projects.
• Experience using Microsoft BI stack; knowledge of scripting languages and SQL Server is preferred.
• Excellent written and spoken English.

Responsibilities

• Leverage Microsoft Power BI to generate, operate and maintain BI applications.
• Provide actionable insights by creating coherent, useful reports from raw data.
• Collaborate with cross-functional teams and contribute to BI strategy.
• Ensure effective deployment pipelines and data warehousing solutions.
• Engage with stakeholders to understand BI requirements and align solutions with business goals.
• Design and develop data models for performance, scalability and best practices.

Education

Bachelor's degree in a relevant subject

Master's degree in a relevant discipline (preferred)

Tools

Microsoft Fabric

Power BI

SSAS

SSRS

SSIS

Tableau

SAP

SQL Server

Job description

Salary: £32,000 - 53,000 per year

Requirements:

• We require significant previous experience using Microsoft Fabric along with the Microsoft BI Stack, including Power BI, SSAS, SSRS and SSIS.
• We require a degree in a relevant subject.
• A masters degree in a relevant discipline is preferred.
• We require demonstrable experience in data preparation, data warehousing and BI projects.
• We require demonstrable experience using Microsoft Fabric.
• We require demonstrable experience with Microsoft BI stack, including Power BI, SSAS, SSRS and SSIS.
• Knowledge of other BI tools such as Tableau or SAP is preferred.
• Demonstrable experience in creating clear and concise requirement documents, user stories and process flows is preferred.
• Knowledge of scripting languages and SQL Server is preferred.
• We require excellent written and spoken English.

Responsibilities:

• We are responsible for leveraging Microsoft Power BI to generate, operate and maintain business intelligence applications.
• We provide actionable insights to the organisation by creating coherent and useful reports from raw data.
• We collaborate with cross-functional teams and contribute to BI strategy.
• We ensure effective deployment pipelines and data warehousing solutions.
• We engage with business stakeholders, data analysts and other teams to understand organisational goals, challenges and BI requirements.
• We participate in defining the overall BI strategy, including long-term vision, objectives and KPIs.
• We identify opportunities for BI enhancements, process improvements and data-driven decision-making.
• We design and develop data models ensuring optimal performance, scalability and adherence to best practices.
• We work closely with data engineers to integrate data from various sources into the BI environment.
• We implement security measures and ensure compliance with data privacy regulations.
• We optimise query performance, data refresh schedules and report rendering.
• We create interactive and visually appealing Power BI reports and dashboards.
• We write complex DAX calculations to derive meaningful insights.
• We transform raw data into usable formats, ensuring data quality and consistency.
• We set up and manage deployment pipelines for Power BI reports, ensuring seamless updates and version control.
• We configure automated data refresh schedules to keep reports up to date.
• We collaborate with ETL developers, database administrators and other technical teams to align BI solutions with overall architecture.
• We contribute to the design and maintenance of data warehouses, ensuring efficient storage and retrieval.
• We work with data lakes such as Azure Data Lake Storage to ingest and process large volumes of data.
• We understand ETL processes and their impact on BI solutions.
• We implement data governance practices within the data warehouse and data lake environments.
• We participate in cross-functional teams to provide insights and recommendations for data-related initiatives.
• We participate in training and development opportunities to enhance technical skills and domain knowledge.
• We demonstrate a safe approach in working practices and promote attention to safety.
• We maintain our professional development and complete identified competency requirements in a timely manner.
• We adhere to our integrated management system.
• We comply with quality assurance, health and safety and environmental policies.
• We demonstrate and promote our QHSE principles and lead by example.
• We ensure unsafe activities are challenged.
• We adhere to best practice standards, recommendations and processes in the undertaking of our duties.
• We demonstrate and promote our values and lead by example.

Technologies:

• Azure
• Business Intelligence
• Data Warehouse
• DAX
• ETL
• Fabric
• Power BI
• SAP
• SQL
• Security
• SSAS
• SSIS
• Tableau
• Cloud

More:

We are PD&MS Group, a flexible full-service provider engineering solutions in the energy industry and beyond since 2002. We combine innovative ideas with technical expertise to deliver high-quality project work across the full lifecycle of assets in the oil and gas, renewables and nuclear sectors. This is a full-time employee role within our DS&T Team based in Aberdeen, with a flexible hybrid working model that allows two days per week to be worked remotely. We offer an excellent salary and benefits package, and we value a culture where individual differences are respected, colleagues feel part of the team, and our voices are heard. We are committed to diversity, inclusion and socially responsible, sustainable business practices.

last updated 37 week of 2026