Lead design and development of Net Zero data architecture using Microsoft Fabric, Medallion, and Kimball principles.
Design and maintain the Energy Data Warehouse and information systems.
Program Net Zero data solutions with SQL Server, Python, APIs, Power BI, and Excel.
Integrate third-party data with external partners.
Manage complex data loads for solar PV, heat pumps, and energy consumption.
Develop scalable databases and business processes for efficient data use.
Conduct advanced data analysis and dashboard design.
Support commercial models for solar PV and battery portfolios.
Produce reports on performance, forecasting, and reconciliation.
Deliver Carbon Dashboard updates for ESG reporting and manage Carbon Credit claims.
Clearly present data insights to technical and non-technical audiences.
Implement data testing strategies for quality assurance.
Lead data quality management and develop assurance models.
Support AI and innovative data solutions for improved performance and efficiency.
Collaborate with ICT and Business Intelligence teams for data visibility and usage.
Represent the organization at user groups and conferences to share insights.

Requirements

Database architecture and advanced solution/process design
Advanced data analysis, reconciliation, and dashboard development
Business model design and maintenance for investment projects
Programming in SQL, APIs, Python, and advanced Excel
Data Warehouse development and lifecycle understanding
Performance tuning and issue resolution
Report and dashboard production for monitoring and strategy
Data testing strategies and test packs implementation
Participation in energy, sustainability, or carbon projects
Data architecture principles and best practices
SQL Server database architecture and development
Complex data analysis and reconciliation methodologies
Business model and dashboard design
Application Programming Interfaces (APIs)
Skills in Python, Power BI, and advanced Excel
Data quality management and testing methodologies

Benefits

Starting salary of £40,376 per annum - Pay award pending
27 days holiday (rising to 32 over 5 years’ service) + bank holidays
Hybrid working - you will manage your week by dividing your time between working in our offices, on site and working from home. You will be required to visit our Blackburn office, located at BB1, approximately 2 days a week following the initial induction.
You will be working 37 hours per week, Monday – Friday (occasional evening or weekend working depending on business needs). Working arrangements are flexible in line with our Smart Working culture so that we deliver an excellent and accessible service for customers.
To explore the full range of our award-winning benefits, please click on the link and ensure that you review all that we have to offer - Employee Benefits Link

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonAPIsPower BIExcelData Warehouse developmentData architectureData analysisDashboard developmentData quality management

Soft Skills

LeadershipCommunicationCollaborationPresentation skillsProblem-solvingAnalytical thinkingOrganizational skillsQuality assuranceInnovative thinkingStakeholder engagement