Senior Data Modeller
Recruiter
Ofgem
Listed on
14th January 2022
Location
London
Salary/Rate
London £46,250 - £83,640 Glasgow/Cardiff £43,650 - £76,800 which includes a 20% uplift on salary for exceptional candidates
Salary Notes
London £46,250 - £83,640 Glasgow/Cardiff £43,650 - £76,800 which includes a 20% uplift on salary for exceptional candidates
Type
Permanent
Start Date
ASAP
This job has now expired please search on the home page to find live IT Jobs.
Ofgem works on behalf of energy consumers to ensure that every household and business in the UK can rely on a safe, affordable and environmentally sustainable energy supply. We are playing a vital part in accelerating the transition to Net Zero and a carbon neutral energy system - a goal that everyone wants to achieve. Whatever your role, you'll be playing your part in creating new energy solutions that are great for customers, and great for the environment. We offer a diverse range of flexible working career opportunities: roles that are stimulating and rewarding, where you can get involved in ground-breaking work. And it's important to us that we recruit from a wide range of professional and personal backgrounds - bringing different perspectives and experiences to our work.Effective use of data is vital to what we do - it accelerates robust decision making, ensures consistency and supports self-service across Ofgem. As a Senior Data Modeller, you will play a key role in the design, creation and maintenance of various metadata repositories. These will include data models (conceptual, logical and physical), technical metadata (taxonomies/data dictionaries) and operational metadata (data lineage and transformation). You will also define physical data structures such as DDL scripts and semantic layers such as SQL views for use by business users. We're looking for someone who can bring an analytical approach to their work and support the development of scalable and flexible solutions that are tailored to organisational need.
We expect that you will already have experience of leading the evaluation development and maintenance of metadata repositories, logical data models, physical database structures and database queries according to best practice - developing an expert knowledge of SQL as a result. You'll be accustomed to working with data modelling tools and industry standard techniques to capture and document data artefacts and be knowledgeable on topics such as data lineage, data usage and data structures. It's important that you have excellent stakeholder management and communication skills, enabling you to advise on analytic process concepts and technologies, adapting your approach to different audiences. As a senior member of the team, it's also important that you can coach and mentor others - offering sound technical advice and guidance to colleagues. Job Description: The Analytics and Assurance (A&A) directorate is Ofgem's centre of excellence across specialist disciplines, these include subjects such as Regulatory Finance, Research and Economics, Engineering and, Data & Digital Insights (D&DI). The teams in this directorate advise and support Ofgem's regulatory work across the organisation and provide expert leadership to the energy sector.
The Senior Data Modeller role is in the Insight Data Architecture team within the Data & Digital function and is core to delivering organisation wide insights to help accelerate robust decision making, drive consistency and enable self-service across Ofgem.
The Senior Data Modeller will be responsible setting the functions direction for the design, creation, and maintenance of various metadata repositories such as data models (conceptual, logical and physical), technical metadata (taxonomies/data dictionaries) and operational metadata (data lineage and transformation). They will also define physical table structures (eg. DDL scripts) and semantic layers for use by business users (eg. SQL views).
The ideal candidate will take an analytical approach to problem solving and will produce scalable and flexible solutions appropriate to the either operational or analytical use cases ie. transactional, streaming, data warehouse or data science requirements.
The successful candidate will work as part of a cross-disciplinary team and will be confident in stakeholder management, able to rationalise modelling decisions and articulate best practice principles to both technical and non-technical service users.
Data and analytics driven insights are critical to Ofgem and an essential part of delivering its regulatory aspiration and vision, data modellers will play an important role in enabling this by codifying business concepts and processes into the data foundations of the organisation.
This role works closely with the Chief Analytics Officer and the Insights Data Architecture team as well as the DDAT delivery teams. Responsibilities 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
Manage the investigation of Ofgems data modelling requirements
Lead the development, validation, publishing, and maintenance of conceptual, logical, and physical data models to support the data knowledge requirements of Ofgem.
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 the data ecosystem.
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.
Build and maintain strong relationships with key internal and external stakeholders, helping to further good data management and enable data analytics within Ofgem. We welcome candidates from all backgrounds, and especially welcome individuals from underrepresented groups. While this is a full-time role, flexible working patterns and job shares are welcome. Further details relating to the role and application process can be found in the candidate pack. Ofgem can offer you a comprehensive and competitive benefits package which includes; up to 30 days annual leave. Excellent training and development opportunities. The opportunity to join the Civil Service pension arrangements which include a valuable range of benefits. Flexible working hours and family friendly policies. Restaurant and subsidise gym (London only). Interest free season ticket loan.
