Strategic Portfolio Data Model SpecialistBlantyreSalary starting from £53,280 per annum plus excellent benefitsFlexible Hybrid WorkingClosing Date: 13 November 2025Help us create a better future, quickerSP Energy Networks (SPEN) will be delivering £5.4bn of investment in the Transmission network over the next 5 years. As part of this, SPT Strategic Projects will be delivering a £3bn portfolio of new overhead lines and new and upgraded substations, including design, engineering, construction and electrical works.The Data Model Specialist is a critical role within SPT Strategic Projects, they shape and manage the data architecture that underpins the successful delivery of major capital projects. As an integral member of the multi-disciplinary PMO team the Data Model Specialist is responsible for designing, implementing, and maintaining robust data models that so that high-quality, well-structured data is available for reporting, analytics, and decision-making across the Strategic Projects portfolio. The successful candidate will contribute to the broader solution architecture and bridge the gap between technical data management and the business processes underpinning project delivery and controls, ensuring data integrity, consistency, and accessibility across all project phases to support the successful delivery of high-impact major projects.What you’ll be doingIn this position, you can expect to:<ul><li>Design, build and maintain scalable, flexible, and integrated data models to support the full lifecycle of capital projects and key PMO functions such as planning &amp; scheduling, cost management, risk management, change management, commercial management, and governance and reporting.</li><li>Collaborate with reporting and PowerBI teams to make structured, reliable data available for reporting and ensure data models are optimized for use in dashboards, KPIs, and advanced analytics, including transformation and integration of complex datasets.</li><li>Work collaboratively with Project Managers, Delivery and Development teams, Engineering, Commercial, Finance, IT, external partners and other stakeholders to understand data needs and deliver fit-for-purpose solutions.</li><li>Interpret, document, and translate reporting and controls needs into engineered datasets to provide reporting on performance and identify insights on emerging issues.</li><li>Establish and maintain data governance processes to ensure data accuracy, consistency and security, and lead data quality initiatives and resolve data-related issues across teams and systems.</li><li>Contribute to the design of end-to-end data and digital solutions that integrate with project management systems (e.g., Oracle Primavera, SAP, Power BI, Cost, Risk and Contract management tools).</li><li>Contribute to the development of PMO maturity and digital transformation towards a data-driven culture by supporting the rollout of best practices.</li><li>Create and maintain data flow diagrams and data dictionaries to improve data accessibility and reliability.</li></ul>What you’ll bring<ul><li>Demonstratable experience in data modelling and engineering including data ingestion, integration, orchestration and ETL pipeline development (e.g. Azure Synapse, Delta Parquet) along with proficiency in business intelligence and visualisation tools (e.g. Power BI).</li><li>Experience delivering solutions using the Medallion Architecture (Bronze, Silver and Gold layers) and designing and implementing Dimensional data models (e.g. Star Schema).</li><li>Knowledgeable in database design, computer file structures, cloud-based and ERP systems.</li><li>Understanding of large-scale capital projects processes and PMO functions.</li><li>Strong technical data and analytics skills.</li><li>Excellent communication and interpersonal relationship skills.</li><li>Project management and organizational skills.</li><li>Creative problem solving and innovative thinking.</li><li>Adaptability to change.</li><li>Ability to learn quickly.</li><li>Ability and desire to work in a team environment.</li><li>Confidence to challenge and question where appropriate.</li><li>Leadership capabilities demonstrated through projects, volunteering and/or work experiences.</li></ul>To be successful, you will have to demonstrate (as a minimum):<ul><li>Degree-qualified in a relevant discipline (e.g., Data Science, Engineering, Computer Science or Project Management) or equivalent relevant experience.</li><li>Experience enabling data for reporting and analytics platforms</li><li>Advanced proficiency in IT systems, including Microsoft Office Suite, Azure and Power BI, with a strong understanding of integrating complex data models from various digital tools (e.g., P6 Primavera, SAP, etc).</li><li>Understanding of data structures and tools that support performance dashboards and KPIs (e.g. relational and dimensional data models, data integration and ETL tools).</li><li>Knowledge of data governance principles, data quality management, and metadata management.</li></ul><ul><li>Clear and concise communication skills, both written and verbal, to convey complex information to technical and non-technical stakeholders at all levels.</li></ul>   What’s in it for you As well as a competitive salary which is reviewed annually, you can also enjoy a number of other benefits. With our pension scheme, we’ll double match your contribution up to a company contribution of 10%. At ScottishPower, we believe it’s the little things we do in life that make a big difference. From helping you look after your family’s wellbeing, save for your future and take personal steps for climate action – our benefits are designed to help you do just that -  so that you have everything you need to take care of your world – today and tomorrow. That’s why our benefits include:<ul><li>36 days annual leave</li><li>Holiday purchase – perfect your work/life balance with extra annual leave</li><li>Share Incentive Plan and Sharesave Scheme</li><li>Payroll giving and charity matched funding</li><li>Technology Vouchers – save more and spread the cost of your technology purposes</li><li>Count us in – pledge to reduce carbon emissions and help fight climate change</li><li>Electric Vehicle Schemes – to help you transition to green/clean driving</li><li>Cycle to Work scheme and public transport season ticket loans</li><li>Options to purchase dental insurance, private medical insurance, health cash plan and annual health assessments</li><li>Life Assurance (4x salary)</li><li>Access to Savesmart financial wellbeing support</li><li>Plus shopping, leisure, restaurant and gym discounts, and unique employee deals on travel insurance and more</li></ul>Why SP Energy NetworksSP Energy Networks is part of the Iberdrola Group, one of the world’s largest integrated utility companies and a world leader in wind energy. We keep electricity flowing to homes and businesses through Central and Southern Scotland, North Wales and in the North West of England. We operate over 4000km of cables and lines that make-up the transmission network – connecting infrastructure like wind farms into the electricity system. It’s a role that puts us right at the heart of Scotland’s ambition to be Net Zero by 2044. And we’re taking it very seriously. We’re investing &gt;£5.5 billion into our transmission network, directly supporting the rapid growth needed in renewable energy. With diverse opportunities across our businesses and a commitment to invest in our own internal talent, ScottishPower can offer people real career opportunities that meet personal and professional goals, in a global organisation.Inclusion, diversity, and a social purpose are at the heart of everything we do. Together with our values, they bring us together into a stronger, more sustainable business with direct links to the communities we serve. It takes all kinds of people to build a large-scale business like ours, so whatever your background, you’ll fit right in.We are committed to providing reasonable support or adjustments in our recruiting processes for candidates with disabilities, long term conditions, mental health conditions, or who are neurodivergent or require pregnancy-related support. If you need support, please reach out to <a href="mailto:careers@scottishpower.com">careers@scottishpower.com</a>.MobilityPlease note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country. If/when required, the Company will support the employee with the necessary Immigration requirements.IMPORTANT Advert will close at 23:59 GMT the day before Job Posting End Date belowNovember-14-2025

Avangrid is a leading sustainable energy company transitioning America toward a clean and connected future headquartered in Orange, CT, and has a footprint in 24 states with $40 billion in assets. Our primary businesses are Networks, which serves 3.3 million electric and natural gas customers in the Northeast, and Renewables, the third-largest renewable energy company in the U.S. with a diverse onshore and offshore renewable energy portfolio. With more than 7,000 employees, Avangrid has built a culture that blends diversity, equity and inclusion guided by the company&rsquo;s ESG+F framework and the UN Sustainable Development Goals. This has led to recognition by JUST Capital in 2021 and 2022 as one of America&rsquo;s best corporate citizens and second in utilities for our commitment to the environment and the communities we serve. Avangrid has been named one of the World&rsquo;s Most Ethical Companies for four consecutive years by the Ethisphere Institute.

Data Model Specialist

Strategic Portfolio Data Model SpecialistBlantyreSalary starting from £53,280 per annum plus excellent benefitsFlexible Hybrid WorkingClosing Date: 13 November 2025Help us create a better future, quickerSP Energy Networks (SPEN) will be delivering £5.4bn of investment in the Transmission network over the next 5 years. As part of this, SPT Strategic Projects will be delivering a £3bn portfolio of new overhead lines and new and upgraded substations, including design, engineering, construction and electrical works.The Data Model Specialist is a critical role within SPT Strategic Projects, they shape and manage the data architecture that underpins the successful delivery of major capital projects. As an integral member of the multi-disciplinary PMO team the Data Model Specialist is responsible for designing, implementing, and maintaining robust data models that so that high-quality, well-structured data is available for reporting, analytics, and decision-making across the Strategic Projects portfolio. The successful candidate will contribute to the broader solution architecture and bridge the gap between technical data management and the business processes underpinning project delivery and controls, ensuring data integrity, consistency, and accessibility across all project phases to support the successful delivery of high-impact major projects.What you’ll be doingIn this position, you can expect to:<ul><li>Design, build and maintain scalable, flexible, and integrated data models to support the full lifecycle of capital projects and key PMO functions such as planning &amp; scheduling, cost management, risk management, change management, commercial management, and governance and reporting.</li><li>Collaborate with reporting and PowerBI teams to make structured, reliable data available for reporting and ensure data models are optimized for use in dashboards, KPIs, and advanced analytics, including transformation and integration of complex datasets.</li><li>Work collaboratively with Project Managers, Delivery and Development teams, Engineering, Commercial, Finance, IT, external partners and other stakeholders to understand data needs and deliver fit-for-purpose solutions.</li><li>Interpret, document, and translate reporting and controls needs into engineered datasets to provide reporting on performance and identify insights on emerging issues.</li><li>Establish and maintain data governance processes to ensure data accuracy, consistency and security, and lead data quality initiatives and resolve data-related issues across teams and systems.</li><li>Contribute to the design of end-to-end data and digital solutions that integrate with project management systems (e.g., Oracle Primavera, SAP, Power BI, Cost, Risk and Contract management tools).</li><li>Contribute to the development of PMO maturity and digital transformation towards a data-driven culture by supporting the rollout of best practices.</li><li>Create and maintain data flow diagrams and data dictionaries to improve data accessibility and reliability.</li></ul>What you’ll bring<ul><li>Demonstratable experience in data modelling and engineering including data ingestion, integration, orchestration and ETL pipeline development (e.g. Azure Synapse, Delta Parquet) along with proficiency in business intelligence and visualisation tools (e.g. Power BI).</li><li>Experience delivering solutions using the Medallion Architecture (Bronze, Silver and Gold layers) and designing and implementing Dimensional data models (e.g. Star Schema).</li><li>Knowledgeable in database design, computer file structures, cloud-based and ERP systems.</li><li>Understanding of large-scale capital projects processes and PMO functions.</li><li>Strong technical data and analytics skills.</li><li>Excellent communication and interpersonal relationship skills.</li><li>Project management and organizational skills.</li><li>Creative problem solving and innovative thinking.</li><li>Adaptability to change.</li><li>Ability to learn quickly.</li><li>Ability and desire to work in a team environment.</li><li>Confidence to challenge and question where appropriate.</li><li>Leadership capabilities demonstrated through projects, volunteering and/or work experiences.</li></ul>To be successful, you will have to demonstrate (as a minimum):<ul><li>Degree-qualified in a relevant discipline (e.g., Data Science, Engineering, Computer Science or Project Management) or equivalent relevant experience.</li><li>Experience enabling data for reporting and analytics platforms</li><li>Advanced proficiency in IT systems, including Microsoft Office Suite, Azure and Power BI, with a strong understanding of integrating complex data models from various digital tools (e.g., P6 Primavera, SAP, etc).</li><li>Understanding of data structures and tools that support performance dashboards and KPIs (e.g. relational and dimensional data models, data integration and ETL tools).</li><li>Knowledge of data governance principles, data quality management, and metadata management.</li></ul><ul><li>Clear and concise communication skills, both written and verbal, to convey complex information to technical and non-technical stakeholders at all levels.</li></ul> &nbsp;&nbsp;What’s in it for you As well as a competitive salary which is reviewed annually, you can also enjoy a number of other benefits. With our pension scheme, we’ll double match your contribution up to a company contribution of 10%.&nbsp;At ScottishPower, we believe it’s the little things we do in life that make a big difference. From helping you look after your family’s wellbeing, save for your future and take personal steps for climate action – our benefits are designed to help you do just that -&nbsp; so that you have everything you need to take care of your world – today and tomorrow. That’s why our benefits include:<ul><li>36 days annual leave</li><li>Holiday purchase – perfect your work/life balance with extra annual leave</li><li>Share Incentive Plan and Sharesave Scheme</li><li>Payroll giving and charity matched funding</li><li>Technology Vouchers – save more and spread the cost of your technology purposes</li><li>Count us in – pledge to reduce carbon emissions and help fight climate change</li><li>Electric Vehicle Schemes – to help you transition to green/clean driving</li><li>Cycle to Work scheme and public transport season ticket loans</li><li>Options to purchase dental insurance, private medical insurance, health cash plan and annual health assessments</li><li>Life Assurance (4x salary)</li><li>Access to Savesmart financial wellbeing support</li><li>Plus shopping, leisure, restaurant and gym discounts, and unique employee deals on travel insurance and more</li></ul>Why SP Energy NetworksSP Energy Networks is part of the Iberdrola Group, one of the world’s largest integrated utility companies and a world leader in wind energy. We keep electricity flowing to homes and businesses through Central and Southern Scotland, North Wales and in the North West of England. We operate over 4000km of cables and lines that make-up the transmission network – connecting infrastructure like wind farms into the electricity system. It’s a role that puts us right at the heart of Scotland’s ambition to be Net Zero by 2044. And we’re taking it very seriously. We’re investing &gt;£5.5 billion into our transmission network, directly supporting the rapid growth needed in renewable energy. With diverse opportunities across our businesses and a commitment to invest in our own internal talent, ScottishPower can offer people real career opportunities that meet personal and professional goals, in a global organisation.Inclusion, diversity, and a social purpose are at the heart of everything we do. Together with our values, they bring us together into a stronger, more sustainable business with direct links to the communities we serve. It takes all kinds of people to build a large-scale business like ours, so whatever your background, you’ll fit right in.We are committed to providing reasonable support or adjustments in our recruiting processes for candidates with disabilities, long term conditions, mental health conditions, or who are neurodivergent or require pregnancy-related support. If you need support, please reach out to <a href="mailto:careers@scottishpower.com">careers@scottishpower.com</a>.MobilityPlease note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country. If/when required, the Company will support the employee with the necessary Immigration requirements.IMPORTANT&nbsp;Advert will close at 23:59 GMT the day before Job Posting End Date belowNovember-14-2025

Data Model Specialist

About the Job

About the Company

Iberdrola

Similar Jobs

Analytics Engineer

Analytics Engineer

Data specialist

Data specialist

Data transformation specialist

Data transformation specialist

Confirmed Data Analyst - Daily

Confirmed Data Analyst - Daily

Engineer, Analytics

Engineer, Analytics

Data Management Specialist

Data Management Specialist

Data Analyst

Data Analyst

Analytics Engineer

Analytics Engineer

Customer Experience Lead Analyst

Customer Experience Lead Analyst

Analytics Engineer

Analytics Engineer