We are Centrica! We’re so much more than an energy company. We’re a family of brands revolutionising a cleaner, greener future. Working here is #MoreThanACareer - we’re powered by purpose. Together we can make an impact that will truly change tomorrow. Whether you’re developing cutting-edge green tech, helping customers on the front line or simplifying operations behind the scenes.

Your work here isn’t just a job – it’s a mission. We all play a vital role in energising a greener, fairer future.

Junior Developer – Data Warehouse

Reference: R0063660

EM&D - Dublin

Permanent

Reporting to: Data Warehouse Manager

Bord Gáis Energy is one of Ireland’s leading energy and service companies. We supply gas, electricity, and energy services to over 700,000 homes and businesses across the country, offering excellent customer service as well as the best value possible. Bord Gáis Energy is uniquely positioned to drive positive change and we have an opportunity, as well as a responsibility, to reshape our future. We’re powered by our purpose, and we all play a vital role in energising a greener, fairer future. While there are challenges ahead, we are dedicated to supporting our consumers and colleagues, to rethinking power generation, and to supporting an affordable and fair transition for all.

Role Purpose

The purpose of this job is to provide technical support for the Azure (Cloud) data warehouse. The main task will be to support the ETL and day to day operations on the Azure data warehouse with some support work on the on prem Oracle data warehouse.

Key Accountabilities

• Monitor ETL loads.
• Re-run the ETL loads from the point of failure.
• Investigate/fix data reconciliation issues (SR’s).
• Impact Analysis for changes to source systems through DCR’s or Config changes.
• Performance tuning of ETL Loads and SQL scripts.
• Support for Incidents, Service Requests, Change Requests & Projects.
• Support projects for new ETL Load Development and deployment.
• Support Auditors/Governance team on data related queries.
• Keep abreast of the changes to the data warehouse to ensure that competency is maintained.
• Translate business requirements into functional and technical specifications which will effectively convey meaning to both technical and non-technical audiences.

Knowledge, Skills & Experience

• Bachelors degree in Computer Science, Software Engineering, Mathematics or similar disciplines
• At least 1 year of experience in data related projects with focus on data integration and ingestion.
• Will need to quickly understand the data structures of the software systems (Oracle Utilities, Salesforce, MS Dynamics etc.) used by the business.
• Fundamental understanding of data modelling.
• Some experience in working on large databases with multiple tables and stored procedures/packages.
• Good knowledge of SQL
• Good knowledge of Azure Data Factory, Azure Databricks, Azure Synapse
• Consistently demonstrates clear and concise written and verbal communication.
• Excellent interpersonal and team working skills.
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements.

Nice to have skills

• Experience with Qlik Replicate, Compose.
• Oracle PL/SQL (develop ETLs, complex procedures and packages).
• Experience with a visualisation tool such as Power BI.

In return, you’ll receive a competitive salary, generous annual leave allowance, and a host of other benefits, including volunteering days with our charity partner, Focus Ireland. You’ll also enjoy our friendly and collaborative culture, flexible ways of working, and you’ll be making a key contribution to Bord Gáis Energy’s commitment to environmental sustainability.

Climate change is one of the greatest challenges facing society and the energy sector has a key role to play in helping the world transition to net zero. As one of Ireland’s leading energy and services companies, we’re on a journey of transformation; to accelerate our positive impact and bring our customers on this journey with us. As we look to the future we're transforming our energy supply, services and solutions in order to become a leading net zero business in Ireland by 2045 and to help our customers reach net zero by 2050. Our ambition is to use our services, footprint and propositions to better both people and planet

Bord Gáis Energy are committed to placing equality, diversity, care and respect at the heart of our policies and everyday practices. We encourage everyone to take part in our active employee networks, including the Women's network, REACH (Race, Ethnicity, & Cultural Heritage) network, Neurodiversity network, and BRÓD, our LGBTQ+ network. We're proud of the work our networks and allies do to help us promote a culture of inclusion, empowering our colleagues to be themselves and do their best work. Our vision is to employ a diverse mix of people who reflect the societies we work in and the customers we serve, so we welcome applications from people of all backgrounds and perspectives. 

Our Flexible First working model empowers our people to find a better balance between home and office working. You can enjoy the convenience of working from home combined with time spent onsite in a way that works for our customers, our business and you. Our office is used as a place to connect and collaborate with colleagues, rather than your default place of work each day. 

Here in Bord Gáis Energy we’re helping to create a more sustainable and inclusive future that supports our communities, our planet – and each other. The prevention of family homelessness in Ireland is an area where we believe we can make a real difference and through our partnership with Focus Ireland, we have been working on making this a reality since 2015. We encourage all colleagues to get involved in the partnership, with everyone receiving 2 days' volunteering leave to participate in initiatives or events supporting Focus Ireland. 

Our Values

care | delivery | collaboration | agility | courage

The closing date for applications is the 26th of August 2024

PLEASE APPLY ONLINE by hitting the 'Apply' button.

Applications will ONLY be accepted via the ‘Apply’ button.

This role is being handled by the Centrica recruitment team and NO agency contact is required.