Data Modeller at SEFE, Manchester, £Contractor Rate

IN SHORT

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

WHAT WILL YOU BRING

• 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

ABOUT US

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.