Data Warehouse Developer

Join us, be part of more.

We’re so much more than an energy company. We’re a family of brands revolutionising how we power the planet. We're energisers. One team of 21,000 colleagues that's energising a greener, fairer future by creating an energy system that doesn’t rely on fossil fuels whilst living our powerful commitment to igniting positive change in our communities. Here, you can find more purpose, more passion, and more potential. That’s why working here is #MoreThanACareer. We do energy differently - we do it all. We make it, store it, move it, sell it, and mend it.

About your team:

We’re the pride of Ireland. Bord Gáis Energy have been powering the nation’s homes and businesses for almost 40 years. But now, we’re so much more than just gas and electric. Through our unique combination of household heroes and energy assets, we’re at the heart of the energy transition in Ireland, strengthening the country’s energy security and helping customers get ready for a net zero future.

About your role:

We’re looking for a skilled Data Warehouse Developer to join our Data Centre of Excellence. 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-premise Oracle data warehouse.

Your duties will include:

• 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

Here's what we’re looking for:

• BS in Computer Science, Software Engineering, Mathematics or similar disciplines
• 2+ years of experience in data related projects with focus on data integration and ingestion

Required Skills

• Good understanding of data modelling
• Experience in working with large databases with hundreds of tables and stored procedures/packages
• Expert knowledge of SQL
• Expert knowledge of Azure Data Factory, Azure Databricks, Azure Synapse

Nice to have skills

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

#LI-Hybrid

Why should you apply?

We’re not a perfect place – but we’re a people place. Our priority is supporting all of the different realities our people face. Life is about so much more than work. We get it. That’s why we’ve designed our total rewards to give you the flexibility to choose what you need, when you need it, making sure that you and your family are supported not only financially, but physically and emotionally too. Visit the link below to discover why we’re a great place to work and what being part of more means for you.

https://www.morethanacareer.energy/bordgais

If you're full of energy, fired up about sustainability, and ready to craft not only a better tomorrow, but a better you, then come and find your purpose in a team where your voice matters, your growth is non-negotiable, and your ambitions are our priority.

Help us, help you. We would love for you to share any information about yourself throughout our recruitment process so that we can better understand you and help shape your journey.