TL;DR

Data Modeller: Designing and governing Gold-layer domain-specific data models that power trusted reporting, analytics, and scalable self-service use across the organization with an accent on translating reporting requirements and business questions into robust, performant, and reusable data structures. Focus on ensuring models support both predefined reporting and ad hoc analytical exploration without rework and promoting canonical metrics and standard calculation patterns.

Location: Manchester, United Kingdom

Company

SEFE, an international energy company, ensures the security of supply and drives the decarbonisation of its customers.

What you will do

Design and maintain dimensional, denormalised, and semantic-ready Gold layer models optimised for BI, analytics, and self-service use.
Translate business concepts, KPIs, and analytical use cases into well-structured fact and dimension models.
Consume curated Silver-layer data and apply modelling patterns appropriate for Gold.
Design models that are discoverable, intuitive, and safe for business self-service users.
Introduce appropriate genericity to maximise reuse across domains.
Minimise report-specific logic by promoting canonical metrics and standard calculation patterns.

Requirements

Comfortable working to tight timescales.
Strong experience designing analytics-ready Gold models within an Azure based medallion architecture.
Deep understanding of dimensional modelling concepts.
Proven ability to design models that support both operational reporting and exploratory analytics.
Advanced SQL skills for modelling, validation, and performance optimisation.
Experience supporting self-service BI platforms (e.g. Power BI), including interaction with semantic models.

Culture & Benefits

International teams work across locations in Europe, Asia, and North America.
Passionate about energy and the important role it can play in shaping a better future.