Data Warehouse Developer

Posted:
8/21/2024, 5:00:00 PM

Location(s):
Leinster, Ireland ⋅ Dublin, Leinster, Ireland

Experience Level(s):
Junior ⋅ Mid Level ⋅ Senior

Field(s):
Data & Analytics

Workplace Type:
On-site

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.

Data Warehouse Developer

Reference: R0063639

Energy Marketing & Data – Dublin

Permanent

Reporting to: Data Warehouse Operations 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.

About the Role:

Development Support

  • Create Functional Design (FDD) & Technical Design (TDD) documents.
  • Review Oracle PL/SQL code to develop similar ETL jobs on the Azure platform.
  • Unit Test ETL jobs and support the test team in their UAT work.

Operational Support

  • 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.

Role Components

  • Initially, the role will require comprehensive training to familiarise the candidates with BGE and the energy industry.
  • Within 2 months, the candidate will support the Azure Datawarehouse ETL development work (using ADF, Databricks).
  • Within 4 months, the candidate will understand and support all the ETL elements of the Azure Data Lake based data warehouse.
  • Train and mentor other members of the team.
  • Identify problems, analyse information, and make evaluative judgements to recommend and implement solutions.
  • Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements.
  • Consistently demonstrates clear and concise written and verbal communication.
  • Excellent interpersonal and team working skills.
  • Has the ability to operate with a limited level of direct supervision.
  • Ability to translate business requirements into functional and technical specifications which will effectively convey meaning to both technical and non-technical audiences.
  • Strong interpersonal/team skills to deliver an excellent level of customer service.
  • Willingness to own issues and chase them through to completion, communicating effectively and in a timely manner, throughout.

Knowledge, Skills & Experience

  • BS in Computer Science, Software Engineering, Mathematics or Similar disciplines
  • 2-4 years of experience in data related projects with focus on Azure Databricks and ADF based data integration and ingestion.
  • Good understanding of data modelling.
  • Experience in working with large databases that has hundreds of tables and stored procedures/packages.
  • Expert knowledge of SQL
  • Expert knowledge of Azure Data Factory, Azure Databricks, Azure Synapse.
  • Oracle PL/SQL knowledge (develop ETLs, complex procedures and packages)

Nice to have skills

  • Experience with Qlik Replicate, Qlik Compose.
  • 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 5th of September 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.