Senior Data & BI Analyst - Offshore Energy

OEG; Aberdeen City; On-site; GBP 60,000 - 90,000; Full time

Job summary

OEG is seeking a Senior Business Analyst to join the Topside/Subsea Divisions, based in Aberdeen/Liverpool (UK) or Den Helder (Netherlands). You will bridge Finance, BI and IT, translating business needs into data requirements, maintaining data architecture and leading reporting improvements.

The role focuses on data onboarding, KPI framework development, data quality and stakeholder engagement across multiple entities, supporting group reporting and strategic decision making.

Qualifications

• Degree or equivalent experience in business, information systems, data, engineering, finance or related discipline.
• Power BI qualification with business analytics focus is desirable.

Responsibilities

• Act as the key link between the Subsea or Topside business, Finance leadership, application owners and BI/Data teams.
• Translate operational, commercial and financial needs into data, application, warehouse and reporting requirements; own divisional data mapping and architecture documentation; support consistent management information and scalable Group reporting.
• Map and understand end-to-end operational, commercial, project and financial processes; highlight regional variations, manual workarounds and opportunities for standardisation.
• Own the divisional application and data architecture view, maintain inventories, dataflow maps, interfaces and data lineage across entities.
• Gather and document business, data and reporting requirements; assess downstream impact of implementations, migrations, integrations.
• Onboard priority applications/datasets to Group warehouse; define source scope, grain, history, refresh frequency, identifiers, mappings and transformation needs.
• Define consistent master/reference data for customers, projects, contracts, entities, services, assets and personnel; work with data owners and BI teams.
• Gather and define KPI calculations, dimensions, frequency, ownership and drill-down requirements; support Power BI dashboards and management reporting.
• Profile and validate critical data; define validation rules; investigate root causes and reconcile outputs through warehouse to reports.
• Coordinate testing, UAT, defect resolution and sign-off; assess data, integration, warehouse and reporting impacts before implementation.
• Translate complex data into actionable insight for divisional and senior leadership; support forecasting and performance reviews.
• Build relationships across Finance, Operations, Commercial, Applications, IT and BI; communicate technical concepts in business language.

Skills

Requirements gathering

Data mapping

Power BI

SQL

Data modelling

Stakeholder mgmt

Excel advanced

Process mapping

Data governance

Education

Degree or equivalent

Power BI qualification desirable

Tools

Power BI

Excel

SQL

Job description

OEG is seeking a Senior Business Analyst to join the Topside/Subsea Divisions, based in Aberdeen/Liverpool (UK) or Den Helder (Netherlands). You will bridge Finance, BI and IT, translating business needs into data requirements, maintaining data architecture and leading reporting improvements.

The role focuses on data onboarding, KPI framework development, data quality and stakeholder engagement across multiple entities, supporting group reporting and strategic decision making.