BI Developer

at  EP UK Investments

The BI Developer will play a critical role in the design, development, and implementation of business intelligence solutions leveraging a Microsoft Azure SQL Managed Instance and SSIS. Reporting to the BI Manager and working closely with a Data Analyst. The BI Developer will engage stakeholders across the business the translating business requirements into efficient and reliable technical solutions, ensuring the effective delivery of actionable insights to drive strategic decision-making. They will be responsible for creating and optimising data processes, designing data models, and building scalable BI solutions that allow users to query, analyse and visualize data effectively.

Key Responsibilities

• Develop and maintain a suite of packages using SSIS to extract, transform, and load data from various sources into Azure SQL Managed Instance, ensuring data quality, integrity, and reliability.
• Design, develop, and optimize data models and the data warehouse to support business reporting and analytics requirements, utilising best practices for performance and scalability.
• Support Data Analysts in the creation of interactive and visually compelling reports and dashboards using Power BI to present insights derived from data analysis, enabling stakeholders to make informed decisions.
• Collaborate with cross-functional teams to understand business needs, gather requirements, and translate them into technical specifications for BI solutions.
• Monitor and troubleshoot BI solutions, proactively identifying and resolving issues to ensure the availability and reliability of data for decision-making.
• Stay updated on best practice and emerging trends and technologies in business intelligence and data analytics.

Skills, Knowledge and Expertise

Qualifications

• Qualifications in Computer Science, Information Systems, or related fields would be desirable.
• Relevant certifications in Microsoft Azure, Power BI, or SQL Server such as Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Data Analyst Associate are highly desirable.

Experience

• Proven experience in developing and implementing BI solutions using the Microsoft BI stack.
• Hands-on experience with ETL processes and tools, particularly those native to SSIS.
• Experience in data modelling, data warehouse design, and optimization, including index management and incremental loading.
• Previous exposure to agile development methodologies and working with stakeholders.

Skills

• Proficiency in Microsoft Azure and services, including Azure SQL Managed Instance and SQL Coding.
• Experience with SQL Server Integration Services (SSIS) for ETL processes and data integration. VB or C# experience would be attractive.
• Working understanding of data warehousing, indexing, logical modelling and querying.
• Experience of sourcing data from a large variety of origins including APIs, SFTPs, database and file share sources.

Knowledge

• Strong understanding of data warehousing concepts and methodologies.
• Knowledge of dimensional modelling and data mart design, particularly Kimball principles.
• Familiarity with data visualization and techniques.
• Understanding of cloud computing principles and architectures.

About EP UK Investments Ltd
EPUK Investments Ltd (EPUKI) is the UK division of Energetický a průmyslový holding (EPH), a leading energy group of over 70 companies that owns and operates assets across Europe. EPH group employs circa 24,000 people internationally, owns €30.5bn of assets, generating €37.1bn of revenue and an EBITDA of €4.3bn.
EPUKI was established in 2015 as the strategic platform for expanding the EPH group into the UK energy market. Since launching, EPUKI has made several acquisitions and developed a number of new opportunities and now owns multiple renewable and flexible power generating assets in the UK and Ireland.
EPUKI has grown rapidly to revenues ~£3.5bn and EBITDA ~£300m. We pride ourselves on an entrepreneurial culture and flat leadership structure where individuals (wherever they are in the organisation) can make a real impact on our business.

Our aim is to enable the UK and Ireland low carbon transition through provision of flexible and reliable energy supply. To achieve this, we will:

• develop, construct and acquire the right assets to support the transformation of the energy system;
• invest in our people and our assets to best respond to the changing needs of our sector;
• continuously challenge ourselves to identify opportunities, build our knowledge and develop innovative solutions.

EPUKI is one of the largest independent generators in the UK and Ireland, with an asset base that covers multiple technologies and a range of revenue streams; these include fully merchant baseload and peaking plant and index traded baseload plants, providing a range of system services across the energy and balancing spectrum.
Despite its significant market presence, EPUKI has a flat structure with fast paced decision-making ability enabling better optimisation of market positions. The market continues to evolve and develop as the UK and Irish governments drive towards Net Zero with increasing challenges of renewables penetration, introduction of hydrogen and other new technologies.

• Develop and maintain a suite of packages using SSIS to extract, transform, and load data from various sources into Azure SQL Managed Instance, ensuring data quality, integrity, and reliability.
• Design, develop, and optimize data models and the data warehouse to support business reporting and analytics requirements, utilising best practices for performance and scalability.
• Support Data Analysts in the creation of interactive and visually compelling reports and dashboards using Power BI to present insights derived from data analysis, enabling stakeholders to make informed decisions.
• Collaborate with cross-functional teams to understand business needs, gather requirements, and translate them into technical specifications for BI solutions.
• Monitor and troubleshoot BI solutions, proactively identifying and resolving issues to ensure the availability and reliability of data for decision-making.
• Stay updated on best practice and emerging trends and technologies in business intelligence and data analytics