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 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.
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.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 disciplines2-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 SQLOracle 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.
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.
#J-18808-Ljbffr