Senior Data Analyst

Fexco Managed Services are currently recruiting Senior Data Analysts to join their SEAI (Sustainable Energy Authority of Ireland) team on a full-time basis, on a 24-month contract. This role can be based at one of the SEAI head offices (Dublin, Cork, Sligo or Dundalk), with options for hybrid working. This would include working 3 days remote working and 2 days onsite. About this Role: The Sustainable Energy Authority of Ireland (SEAI) was established as Ireland's national energy authority under the Sustainable Energy Act 2002. SEAI's mission is to play a leading role in transforming Ireland into a society based on sustainable energy structures, technologies and practices. The Government is investing €8 billion of Exchequer funds to 2030, and SEAI is responsible for administrating schemes in support of Governments objectives. To fulfil this mission SEAI aims to provide well-timed and informed advice to Government, and deliver a range of programmes efficiently and effectively, while engaging and motivating a wide range of stakeholders and showing continuing flexibility and innovation in all activities. SEAI's actions will help advance Ireland to the vanguard of the global green technology movement, so that Ireland is recognised as a pioneer in the move to decarbonised energy systems. What do we do? The SEAIs mission is to drive Irelands sustainable energy transformation for the benefit of society. SEAI has a key role in driving Irelands energy transformation and will ultimately play a significant part in helping Ireland to achieve the targets that have been set both in legislation and the Climate Action Plan. The Sustainable Energy Authority of Ireland delivers programmes aimed at: Guiding and supporting energy users in their own energy transition with the underpinning goal in mind of a decarbonised society Supporting Government decision-making through advocacy, analysis and evidence Driving demand reduction and providing advice to all users of energy Driving the decarbonisation of energy supply Raising standards in sustainable energy products and services Building markets based on quality, confidence and proven performance Fostering innovation and entrepreneurship Improving the coherence of Irish energy research and development Recruitment Information Candidates who apply through this competition will work within the National Retrofit Directorate as Senior Data Analysts, reporting to the business and reporting programme manager. As part of the interview process, short-listed candidates will be given a public dataset and asked to perform a data analysis. They will be required to: Analyse the dataset and identify key insights. Document the steps and methodologies used in the analysis. Present their findings and the analytical process to the interview panel. Below is a summary of the work of the National Retrofit Directorate. National Retrofit Directorate The Sustainable Energy Authority of Ireland (SEAI) has been designated as the National Retrofit Delivery Body for delivering on Irelands target of upgrading 500,000 homes to B2 by 2030, as laid out in the Programme for Government and the National Climate Action Plan 2021. This will include managing a demand generation campaign, providing advice, grants and supports to homeowners and building supply chain capacity in the market to deliver on these targets. The SEAI Retrofit Directorate is responsible for delivering energy efficiency and retrofit programmes in the residential and community sectors. This programme is aimed at upgrading the Irish housing stock to high standards of energy efficiency and renewable energy usage, thereby reducing fossil fuel usage, energy costs and greenhouse gas emissions. As part of this initiative, the SEAI is developing new schemes, supports and approaches to achieving this aim. The Senior Data Analyst Role(s) SEAI is seeking exceptional data professionals who are highly motivated and passionate about sustainability and want to help us in reducing carbon and energy use in Ireland. The successful applicant(s) will work closely with internal business teams and external stakeholders to gather business intelligence requirements, develop data models and produce insightful Power BI reports and dashboards to assist the organisation in making the key data-driven decisions required to efficiently run programmes, deliver on key objectives, and feedback into programmes design to achieve key Climate Action Targets. Over the next 2 years, SEAI are embarking on a major project to develop an Enterprise Reporting Platform based on Microsoft Fabric technology. This will replace our existing Azure Synapse Analytics reporting platform. It is envisioned that all data models and reports will run on the new platform by the end of this 2-year contract period. The successful applicant(s) will be working across both platforms in this transitional period, working with the latest Microsoft technology ecosystems, and playing an important role in driving adoption of key new technologies in SEAI. The successful applicant(s) will be self-starters with demonstrable experience in rapidly developing data models, reports and dashboards in a fast paced and diverse environment, with challenging deadlines. They will have the expertise and skills to integrate seamlessly into a small team of highly dedicated and skilled data experts. There will be opportunity to upskill in new and emerging technologies whilst also contributing to the challenging targets SEAI have been tasked to deliver under the Programme for Government and the National Climate Action Plan 2024. Key Functions of the role of Senior Data Analyst The key responsibilities of the Programme Executive will include but are not limited to the following: Partner with cross-functional programme teams to ideate, develop, and recommend business intelligence solutions. Listen to stakeholders and ask questions to clearly define business problems Extract, transform, and clean large and complex datasets from multiple sources Create advanced SQL queries to retrieve and manipulate data efficiently Develop and maintain complex data models and dashboards using Microsoft Power BI Conduct in-depth data analysis to support strategic business decision-making and communicate results of analysis. Collaborate with stakeholders to build new dashboards and analytics to improve and monitor business performance Perform predictive and statistical analysis to uncover meaningful patterns and trends Provide technical guidance to non-technical stakeholders Ensure data quality, consistency, and integrity. Develop and maintain weekly and monthly reporting as required. Work on Projects / Ad hoc tasks as required. Key Knowledge and Skills The knowledge and skills required include but are not limited to the following: Advanced SQL programming and knowledge of database management Expert-level proficiency in Microsoft Power BI, including knowledge of complex DAX measures and semantic model design. Proficient in data visualisation and storytelling ETL process and data warehousing expertise Advanced Excel and data transformation skills Excellent communication (written and oral) and interpersonal skills, including ability to communicate technical information to non-technical audiences. Strong project management and organisation skills and knowledge of business process management. Excellent problem-solving and analytical thinking Ability to work on own initiative and to deadlines/milestones. A capacity to foster a positive working relationship with colleagues and external stakeholders; to work in multi-disciplinary teams and to network effectively. Strong proactive approach to achieving results, including managing scope, time, risk assessment, cost and quality. Advanced statistical analysis and data modelling techniques Essential Requirements The successful candidate must be able to demonstrate; Level 8 qualification in Data Analytics, Statistics, Computer Science, or related field Minimum of 5 years professional experience in data analysis and visualisation Proficiency in developing dashboards and reports in Microsoft Power BI Advanced skills in writing complex SQL queries involving joins, subqueries, CTEs (Common Table Expressions), window functions, and set operations. Knowledge of Azure Synapse Analytics or comparable technologies. Experience working with diverse data sources, including on-premises databases and cloud-based systems. Strong understanding of data governance and data protection principles. Demonstrated ability to collaborate with cross-functional teams Strong attention to detail and ability to meet deadlines. Desirable Requirements Additional certifications in data analytics or related technologies (please specify) An understanding of public sector and industry environment and context Cloud data platform experience (Azure Data Factory / Synapse / Fabric) Python programming (for data analysis and manipulation) Microsoft Power BI certification There may be a requirement for the successful candidate to further develop specialist knowledge and expertise relevant to the role. Training will be encouraged (formal and informal) and supported where required.