Data Analyst

OEG Energy Group
Aberdeen, UK
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) Business Analytics Applications Data Analysis Microsoft Azure Business Systems Data Validation Data Infrastructure Extract Transform Load (ETL) Data Systems Data Warehousing Database Queries
+13 more
Excel Formulas Python (Programming Language) Pivot Tables Power BI Microsoft SharePoint SQL Databases Microsoft Power Automate Powerquery Microsoft Fabric Core Data Data Analytics Data Management Tools for Reporting

Job description

  • Support the delivery of key BI and IT initiatives, including master data management, data warehousing, and analyst capability development programmes.
  • Develop and maintain high-quality reporting, analytics, and data solutions using Power BI, DAX, SQL, and Excel.
  • Work closely with stakeholders across the business to understand operational and commercial challenges, translating requirements into actionable insights and solutions.
  • Build strong business knowledge and trusted relationships to evolve into a strategic business partnering role, driving data-informed decision making across the organisation., * Partner with stakeholders across OEG business units to understand reporting requirements, business processes, and performance challenges, translating these into effective data and reporting solutions.
  • Translate business questions and requirements into clear analytical outputs, reporting specifications, and practical data-driven solutions.
  • Develop, enhance, and maintain Power BI dashboards and reports that deliver actionable insights and support informed decision-making across the Group.
  • Design, develop, and maintain robust data models, relationships, measures, and calculations using DAX and Power Query to support accurate and scalable reporting.
  • Utilise Excel for data analysis, modelling, reconciliation, and the creation of stakeholder-facing reports and outputs where appropriate.
  • Provide insightful analysis and commentary to help stakeholders understand business performance, identify trends, and assess risks and opportunities.
  • Support the standardisation of reporting, KPI definitions, and business metrics to ensure consistency and alignment across the Group.
  • Identify and support the resolution of data quality issues, inconsistencies, and reporting gaps to improve the reliability of business information.
  • Collaborate with data engineers, IT, finance, and operational teams to source, transform, and integrate data from multiple systems and platforms.
  • Provide guidance and support to end users to drive adaptation and effective use of Power BI and other reporting tools across the business.
  • Identify and implement opportunities to automate manual reporting processes, reduce duplication, and improve overall reporting efficiency.
  • Act as a bridge between technical teams and business stakeholders, ensuring analytics solutions are both technically robust and commercially relevant.

QHSE Responsibilities

To have a general understanding of the areas of our QHSE Management System and OEG’s QHSE aims and objectives that are relevant to the role.

Comply with the requirements of OEG Energy Group Policies and the responsibilities within the wider QHSE Management System.

Promoting:

  • a proactive health and safety culture focussed on the prevention of work-related injury or ill health and continual improvement in our processes / performance.
  • environmental sustainability and energy efficiency whilst minimising our environmental impacts and preventing pollution.
  • a quality culture that brings values to our business, our customers and other interested parties ensuring quality issues and opportunities for improvement are identified and implemented.

Requirements

Do you have experience in SharePoint?, Do you have a Bachelor’s degree?, Required:

  • Experience in data analyst, BI analyst, reporting analyst, or similar role within a data driven environment.
  • Strong experience designing, developing and maintaining reports and dashboards in Power BI.
  • Good working knowledge of DAX, Power Query, and core data modelling principles.
  • Strong Excel skills, including data analysis, advanced formulas, lookups, pivot tables, and data validation.
  • Ability to gather, clarify, and document business requirements effectively, translating them into clear technical specifications.
  • Strong analytical and problem-solving skills with excellent attention to detail and a focus on data accuracy.
  • Ability to translate data into clear insights, actionable recommendations, and meaningful business outcomes.
  • Confident communicator with the ability to engage effectively with both technical and non-technical stakeholders.
  • Proactive, curious, and commercially aware mindset with a strong interest in understanding business performance drivers.

Desirable:

  • Experience within oil and gas, renewables, offshore services, energy, engineering, logistics, project-based, or other asset-intensive industries.
  • Familiarity with ERP, finance, project management, CRM, asset management, or other operational business systems.
  • Experience writing SQL queries to extract and analyse data.
  • Understanding of data warehousing concepts, ETL processes, and modern data platforms.
  • Experience supporting senior management reporting, KPI packs, and performance review processes.
  • Knowledge of Python, APIs, Microsoft Fabric, Azure, SharePoint, or Power Automate is advantageous., A minimum of a bachelor’s degree (or equivalent) in a relevant subject such as Computing, Data Science, or a related discipline.

About the company

OEG is a leading energy solutions business, providing mission-critical infrastructure assets and services to the global offshore energy industry. Through our specialist divisions - topside, marine, subsea, logistics and industrials, we are a pivotal link in the global offshore energy project chain, ensuring our customers’ projects are delivered safely, reliably and efficiently.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

4:21 min

Challenges of traditional mobile data synchronization

Timothy Marland · WWC 2023

56 sec

Introduction to analytical data formats for software developers

Matthias Niehoff Matthias Niehoff · WWC Europe 2026

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

2:57 min

Core data types and collection structures in Clojure

Tobias Schröder · WWC 2021

Videos

See all

Related articles

See all