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.
Location
- Dyce, Aberdeen, United Kingdom.
Core Purpose
- 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.
Key Responsibilities and Accountabilities
- 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.
Skills and Experience
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.
Qualifications
A minimum of a bachelor’s degree (or equivalent) in a relevant subject such as Computing, Data Science, or a related discipline.
We are an equal opportunity employer committed to a fair and inclusive recruitment process for all applicants.
