Senior Business Analyst

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 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, cables, 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. We are currently seeking a Senior Business Analyst to join our Topside/Subsea Divisions.

Location

• Aberdeen/Liverpool, United Kingdom or Den Helder, The Netherlands.

Core Purpose

• 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 clear data, application, warehouse and reporting requirements; own divisional data mapping and architecture documentation; and support consistent, trusted management information and scalable Group reporting.

Key Responsibilities and Accountabilities

Business Process Support:

• Work with divisional process owners and key stakeholders to map and understand end-to-end operational, commercial, project and financial processes, highlighting regional or legacy variations, manual workarounds and opportunities for standardisation.

Data Mapping and Architecture:

• Own the divisional application and data architecture view, maintaining application inventories, dataflow and system-interaction maps, interfaces, systems of record, data lineage, dependencies and key data ownership across entities.

Requirements and Impact Analysis:

• Gather, challenge and document business, data and reporting requirements, business rules and acceptance criteria; assess the downstream data and reporting impact of application implementations, migrations, integrations and configuration changes.

Data Warehouse Onboarding:

• Act as the divisional business/data lead for onboarding priority applications and datasets to the Group warehouse, defining source scope, grain, history, refresh frequency, common identifiers, source-to-target mappings and transformation requirements.

Master and Reference Data:

• Support consistent definitions, hierarchies and controls for customers, projects, contracts, entities, service lines, assets/equipment, personnel and statuses, working with Data Owners, Stewards and BI to maintain agreed standards.

Reporting and KPI Framework:

• Gather and rationalise reporting needs; define KPI calculations, dimensions, frequency, ownership and drill-down requirements; and support the design, validation and adoption of Power BI dashboards and management reporting.

Data Quality and Reconciliation:

• Profile and validate critical data, define validation and exception rules, investigate root causes and reconcile outputs from source applications through the warehouse to published reports and management information.

Testing and Change Delivery:

• Coordinate business testing, UAT, defect resolution and sign-off; ensure application and process changes are assessed for data, integration, warehouse and reporting impacts before implementation.

Performance Insight:

• Support forecasting, planning and performance reviews by translating complex operational, commercial and financial information into clear analysis and actionable insight for divisional and senior leadership.

Stakeholder Engagement:

• Build strong relationships across Finance, Operations, Commercial, Applications, IT and BI/Data teams; communicate technical concepts in practical business language and support documentation, training, adoption and continuous improvement.

Skills and Experience

• Proven Senior Business Analyst, Business Systems Analyst or Data Business Analyst experience in a complex, multi-entity or project-based organisation.
• Offshore energy, engineering, subsea, topsides or comparable sector experience is advantageous.
• Strong requirements gathering, application analysis and data mapping skills, with experience in data-flow documentation and facilitating stakeholder workshops.
• Experience supporting data warehousing, BI/reporting, integration, system implementation or business transformation delivery.
• Strong practical Power BI experience, including report/dashboard requirements, KPI definition, data validation and working with semantic/data models.
• Sound understanding of relational data, master/reference data, data quality, reconciliation, testing and data governance controls.
• Able to bridge business and technical teams, challenge constructively and influence senior stakeholders across functions and locations.
• Advanced Excel; SQL, data modelling or BPMN/process-modelling knowledge is desirable.

Qualifications

• Degree or equivalent experience in business, information systems, data, engineering, finance or a related discipline.
• Relevant business analysis, process, data or Power BI qualification is desirable.

We are an equal opportunity employer committed to a fair and inclusive recruitment process for all applicants.