Data Analyst

Company Overview

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.

• Dyce, Aberdeen, United Kingdom.

• 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.

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.

• 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…