Job Vacancy Senior Data Modeller

Join Ofgem's Insight Data Architecture team within the Data & Digital function as a Senior Data Modeller and play a pivotal role in delivering organisation-wide insights. Your work will accelerate robust decision-making, drive consistency, and enable self-service across Ofgem.  

As a Senior Data Modeller, you will set the direction for designing, creating, and maintaining various metadata repositories, including data models (conceptual, logical, and physical), technical metadata (taxonomies/data dictionaries), and operational metadata (data lineage and transformation). You will also define physical table structures (e.g., DDL scripts) and semantic layers for business users (e.g., SQL views).  

We seek an analytical problem-solver who can produce scalable and flexible solutions for both operational and analytical use cases, such as transactional, streaming, data warehouse, or data science requirements. You will work as part of a cross-disciplinary team, confidently managing stakeholders, rationalising modelling decisions, and articulating best practice principles to both technical and non-technical service users.  

Data and analytics-driven insights are critical to Ofgem's regulatory aspirations and vision. As a data modeller, you will play an essential role in codifying business concepts and processes into the organisation's data foundations.  

Your key responsibilities will include supporting the data team deliverables, leading the determination of data layer requirements, setting standards for data modelling and design tools, and collaborating with senior leadership to define data strategy. You will lead the development, validation, publishing, and maintenance of data models, create and develop Ofgem's enterprise data model, and provide mentorship to other modelling practitioners. Additionally, you will design and maintain metadata repositories, define and manage data models using industry-standard tools, and support the development and evolution of data structures.  

You will ensure architectural and engineering concepts are embedded to design solutions that meet operational requirements, such as scalability, maintainability, security, reliability, and flexibility. You will also define, design, develop, and embed best practice data modelling standards into the wider architectural community.  

Join us at Ofgem and be part of a team that's shaping the future of energy. Apply now and make a difference!  

Key Responsibilities 

• To support the team deliverables, that utilise your expertise to ensure successful outcomes across team members and collaborating teams. 

• Lead the determination of data layer requirements by analysing organisational and market needs and evaluating current systems.  

• Sets standards for data modelling and design tools and techniques, advise on their application. 

• Collaborate with senior leadership to define data strategy and ensure alignment with Ofgem's Business goals. 

• Lead the development, validation, publishing, and maintenance of conceptual, logical, and physical data models to support the data knowledge requirements of Ofgem. 

• Lead on the creation and development of Ofgem's enterprise data model. 

• Provide mentorship to other modelling practitioners and guide them in best practices, modelling techniques and collaborative efforts. Validate Modelling activities across the organisation. 

• Design and maintain metadata repositories enabling the organisation to find and understand their data assets.  

• Define, manage and maintain data models using industry standard modelling and profiling tools and techniques across Ofgem's disparate data streams.  

• Support the development, integration, administration, and evolution of data structures, ensuring efficiency, scalability and quality. Continuously monitor to enhance performance and reduce latency. 

• Maintain comprehensive documentation of models, standards and best practices for reference and future enhancements. 

• Ensure architectural and engineering concepts are defined and embedded to design solutions that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.   

• Define, design, develop and embed best practice data modelling standards into the wider architectural community.  

Key Outputs and Deliverables 

• Lead the delivery of strategic assets i.e. Metadata Repositories', Enterprise Logical Data Model (LDM), Logical, Conceptual and Physical data models, best practice guidance, data flow diagrams.  

• Define and embed a consistent and coherent approach to data modelling throughout the organisation.  

• Development of principles, approaches and solutions which enable data models to be understood and used directly by business users, enabling analytical self-serve within a set of ‘guard rails'.  

• A culture that promotes data-driven decisions backed by robust and comprehensive models.  

• Delivery of a central modelling ability to ensure quality, traceability, transparency, timeliness, usability and cost-effectiveness.  

• Conduct peer reviews, develop optimisations and recommendations throughout the lifecycle of data product development from its logical design through to physical implementation and query layer consumption.   

Essential Criteria

• Strong experience developing OLAP data models. (Lead criteria) 

• Strong experience of leading the evaluation development and maintenance of metadata repositories, logical data models, physical database structures and database queries according to best practice (expert knowledge of SQL required). (Lead criteria) 

• Demonstrable experience using data modelling tools and industry standard techniques to capture and document data artefacts.  

• Strong stakeholder management with the ability to translate complex business requirements into scalable, interoperable, and flexible data models. 

• Ability to communicate in technical detail on topics of data lineage, data usage and data structures.  

Desirable Criteria

• Track record of working within a cloud-based technology landscape.  

• Experience in integrating complex, cross-organisation processes and data models, ideally within a highly regulated environment.  

We'll assess you against these behaviours during the selection process:

• Changing and Improving
• Working Together
• Delivering at Pace

We'll assess you against these technical skills during the selection process:

• Please refer to the Candidate Pack and Role Profile attached for full details.