Power BI Developer

Globalenergynetwork; Aberdeen City; Hybrid; GBP 40,000 - 64,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

PD&MS Group in Aberdeen invites a skilled Power BI Developer to join the DS&T Team on a full-time basis. You will design and maintain Power BI dashboards, model data, and provide actionable insights from diverse data sources.

Collaborating with data engineers and stakeholders, you will drive BI strategy, support data warehousing and ETL processes, and ensure robust deployment pipelines within a flexible hybrid work model offering two remote days per week.

Qualifications

• Degree-qualified in a relevant subject.
• Masters degree preferred.

Responsibilities

• Engage with stakeholders to define BI requirements and KPIs.
• Develop Power BI reports and dashboards and optimise data models.
• Set up and manage deployment pipelines and automated data refresh schedules.
• Collaborate with data engineers and DBAs to integrate data sources.
• Contribute to BI strategy and governance.

Skills

Power BI

SSAS/SSRS/SSIS

SQL

Data warehousing

ETL

Education

Bachelor's degree

Master's degree preferred

Tools

Tableau

SAP

Job description

About The Role:

PD&MS Group are now looking for an experienced Power BI Developer to join our DS&T Team on a full-time, employee basis. An excellent salary + benefits package is available for the successful candidate, full details in link below. We offer a flexible hybrid working model where 2 days per week can be worked remotely.

Role summary:

The Power BI Developer is responsible for leveraging Microsoft's Power BI to generate, operate, and maintain business intelligence (BI) applications. Provide actionable insights to the organisation by creating coherent and useful reports from raw data. Collaborate with cross-functional teams, contribute to BI strategy, and ensure effective deployment pipelines and data warehousing solutions.

Responsibilities:

BI Strategy and Planning

• Engage with business stakeholders, data analysts, and other teams to understand organisational goals, challenges and BI requirements.
• Participate in defining the overall BI strategy, including long-term vision, objectives, and key performance indicators (KPIs).
• Identify opportunities for BI enhancements, process improvements, and data-driven decision-making.

Strategic Planning

• Design and develop data models ensuring optimal performance, scalability and adherence to best practices.
• Work closely with data engineers to integrate data from various sources (both structured and unstructured) into the BI environment.
• Implement security measures and ensure compliance with data privacy regulations.
• Optimise query performance, data refresh schedules and report rendering.

Tactical Planning and Implementation

• Create interactive and visually appealing Power BI reports and dashboards.
• Write complex Data Analysis Expressions (DAX) calculations to derive meaningful insights.
• Transform raw data into usable formats, ensuring data quality and consistency.
• Set up and manage deployment pipelines for Power BI reports, ensuring seamless updates and version control.
• Configure automated data refresh schedules to keep reports up-to-date.
• Collaborate with ETL developers, database administrators, and other technical teams to align BI solutions with overall architecture.

Data Warehousing and Data Lakes

• Contribute to the design and maintenance of data warehouses, ensuring efficient storage and retrieval.
• Work with data lakes (such as Azure Data Lake Storage) to ingest and process large volumes of data.
• Understand ETL (Extract, Transform, Load) processes and their impact on BI solutions.
• Implement data governance practices within the data warehouse and data lake environments.

General

• Participate in cross-functional teams to provide insights and recommendations for data-related initiatives.
• Participate in training and development opportunities to enhance technical skills and domain knowledge.
• Demonstration of safe approach in working practises.
• Encouragement of attention to safety.
• Responsible for ensuring professional development is maintained and identified competency requirements are undertaken in a timely manner.
• Adherence to the company integrated management system.
• Compliance with quality assurance, health and safety and environmental policies.
• Demonstrate and promote PD&MS QHSE principles and lead by example.
• Ensure unsafe activities are challenged.
• Adherence to the requirements of the best practice standards recommendations and processes in the undertaking of duties.
• Demonstrate and promote PD&MS values and lead by example.

About You

Qualifications:

• Degree qualified in a relevant subject
• Masters degree in relevant discipline (preferred)

Experience / competence:

• Demonstrable experience in data preparation, data warehousing and BI projects
• Demonstrable experience with Microsoft BI stack, including Power BI, SSAS, SSRS and SSIS
• Knowledge of other BI tools such as Tableau or SAP (preferred)
• Demonstrable experience in creating clear and concise requirement documents, user stories and process flows (preferred)
• Knowledge of scripting languages and SQL server (preferred)
• Excellent written and spoken English

Personal attributes:

• Go the extra mile
• Empower our people
• Never get complacent
• Engage our partners
• Step up and deliver

If this sounds like you, then you could be a perfect fit.

About Us

PD&MS has been engineering solutions in the energy industry and beyond since 2002, our ability to combine innovative ideas with technicalexpertisesets us apart. A flexible, full-service provider committed to supporting the energy transition, we deliver high-quality project work across the entirelifecycle of assets within the oil and gas,renewablesand nuclear sectors. But whoever we work with, it's the energy, professionalism and purpose of our people that really makes the difference.

Be who you're meant to be, with PD&MS

Wefirmly believein a work culture in which: individual differences are a source of collective strength and pride; everybody can perform to the best of their abilities and on a level playing field; and all colleagues feelthey're part of our team and their voices will be heard.We'realready heartened by the diversity within our organisation, but we recognise that there'salways more we can do to improve further.We welcome applications from all persons regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteranor disability status.

We'reenergised by the prospect ofoperatingsuccessfully today,tomorrowand far into the future. Butwe'realso driven to ensure that our business activities are conducted in socially responsible, morallyacceptableand sustainable ways.

Tagged as: IT Support / Infrastructure