Data Modeller

The Data Modeller is responsible for designing, evolving, and governing Gold-layer domain specific data models that power trusted reporting, analytics, and scalable self-service use across the organisation. This role blends deep data modelling expertise with strong analytical skills - translating reporting requirements and business questions into robust, performant, and reusable data structures that balance clarity for reporting with flexibility for ad hoc data exploration. The modeller acts as a critical bridge between Silver-layer data engineering patterns and business-facing consumption, ensuring that the resulting data models are intuitive, consistent, and future-proof while remaining aligned with enterprise standards and governance. WHAT WILL YOU DO

• Gold-Layer Data Modelling & Design

• 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

• Ensure models support both predefined reporting and ad hoc analytical exploration without rework

• Balance usability with extensibility - avoiding overfitting models to single reports or tools

Medallion Architecture Alignment

• Consume curated Silver-layer data (e.g. Data Vault, 3NF, or conformed sources) and apply modelling patterns appropriate for Gold

• Clearly separate transformation concerns between Silver (integration and harmonisation) and Gold (consumption and insight)

• Ensure Gold models remain stable interfaces even as upstream sources evolve

• Contribute to architectural decisions on where business logic, calculations, and aggregations should reside

• Self-Service Enablement & Genericity

• Design models that are discoverable, intuitive, and safe for business self-service users

• Introduce appropriate genericity (e.g. conformed dimensions, shared metrics, reusable grain) to maximise reuse across domains

• Minimise report-specific logic by promoting canonical metrics and standard calculation patterns

Do you have experience in SQL?, * Comfortable working to tight timescales

• Strong experience designing analytics-ready Gold models within an Azure based medallion architecture
• Deep understanding of dimensional modelling concepts (facts, dimensions, grain, conformed dimensions)
• 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
• Understanding of how upstream modelling choices (e.g. Data Vault, Silver transformations) impact Gold design
• Ability to translate ambiguous business questions into clear, reusable data structures
• Experience working in regulated or complex data environments an advantage
• Strong documentation and communication skills - able to explain modelling decisions to technical and non-technical audiences

Securing Energy for Europe - it's a simple statement, with a bold ambition. SEFE is not just our name, but also encompasses everything that drives us. To accomplish this, we're taking immediate action to secure gas supply - but also looking forward, to explore our role in the European energy transformation and how we can contribute to a stable and sustainable future. SEFE, an international energy company, ensures the security of supply and drives the decarbonisation of its customers. SEFE's activities span the energy value chain, from origination and trading to sales, transport, and storage. Through its decades-long expertise in trading and the development of its LNG business, SEFE has become one of the most important suppliers to industrial customers in Europe, with an annual sales volume of 200 TWh of gas and power. Its 50,000 customers range from small businesses to municipalities and multinational organisations. By investing in clean energies and especially in the hydrogen ecosystem, SEFE is contributing to the energy transition. The company employs around 2,000 people globally and is owned by the Federal Government of Germany. Our international teams work across locations in Europe, Asia, and North America. We're passionate about energy and the important role it can play in shaping a better future.