Data Engineer (12 Months)

ESB is a purpose led company striving to create a brighter future for the customers and communities we serve, leading the transition to reliable, affordable, low-carbon energy. Today, we operate one of the most progressive electricity systems in the world, with activities spanning electricity generation, transmission, distribution and supply in Ireland, Northern Ireland and Great Britain, and an international energy consulting business. With almost 8,000 employees we invested €1bn in infrastructure last year, contributed over €2bn to the economies we operate in and distributed over €2m across a range of community initiatives. This requires us to bring the best of our capabilities together to deliver innovative and value-driven solutions that enable our customers to live low-carbon lives. ESB strives to foster an effective and inclusive culture where people engage, challenge and feel connected to our purpose, colleagues, customers and community.

Position Description

The data function within ESB operates in a Hub and Spoke model, with the Hub acting as a Centre of Excellence, supporting the individual Spokes which sit directly within five business units across ESB. The Data Engineering team is an integral part of the Analytics Hub. This team has been set up to re-invent how ESB uses its data. It will be involved in the design, build, integration, and subsequent productionising of data pipelines from various sources across all business units to facilitate the optimal use of this data by appropriate analytics consumers such as Data Scientists, Data Analysts etc.

Key Responsibilities

1. Ensuring the successful delivery of all assigned Data Engineering work on projects across all ESB business units and their successful deployment to production, including use cases developed by our Data Science & Analytics team.
2. Responsible for our data infrastructure platforms including SSIS, Azure Synapse, Cloudera.
3. Responsible for building robust and scalable data models as well as helping to shape the vision and architecture of ESB's data infrastructure into the future.
4. Responsible for tracking the performance of our resources and growing our capability in line with business requirements.
5. The development of Extract Transform and Load routines, modelling, queries, reports, and analysis.

Experience & Qualifications

1. Minimum 3 years relevant experience with at least 3 years’ working experience in data engineering including hands-on development of data pipelines.
2. ETL development using Microsoft SSIS or Azure Synapse or Hadoop.
3. Demonstrated strength in data modelling and data warehousing (Kimball/Inmon).
4. Experience building data products incrementally and integrating and managing data sets from multiple sources.
5. Query performance tuning skills.
6. Excellent communication and reporting skills.
7. Demonstratable motivation to learn new development skills.
8. Ideas-driven and creative in finding solutions/ designing improved methods, systems, and processes.
9. Competent in writing Transact SQL scripts.
10. Experience providing technical leadership and mentoring other engineers for best practices in the data engineering space.
11. Industry experience as a Data Engineer or related specialty with a record of accomplishment of manipulating, processing, and extracting value from large data sets.
12. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets.
13. Experience leading large-scale data warehousing and analytics projects.
14. Use of Agile software development.
15. Knowledge of big data tools, e.g. HDFS, HIVE, Sqoop, Oozie, Spark, Sentry.
16. Use of R/Python.
17. Familiarity with SAP ERP, SAP BW, SAP Data Services.
18. Use of Microsoft Visual Studio Team Services / Azure DevOps.
19. Experience in designing and developing data visualisations through Power BI or Tableau.
20. Professional Certification.
21. Working in Agile methodology/sprints.

Location

This position will be based in ESB Head Office, F27, Dublin 2. ESB is committed to smart working – combining digital tools with a culture of trust and empowerment to enable flexible ways of working. The successful candidate may work flexibly within their jurisdiction with attendance at the workplace for in-person collaboration on at least one anchor day per week. All smart working arrangements are subject to manager approval and ongoing review, based on the operational requirements of the role, the team, and the individual.

Reporting to

The successful candidate will report to the Data Engineering Manager, Analytics, CIO, ESB Enterprise Services.

Why Work with Us?

1. Opportunity to lead Ireland’s transition to net zero carbon future.
2. Progressive, hybrid working model.
3. Career development through mentoring and training.
4. Corporate Social Responsibility Opportunities.
5. Sports and Social Clubs.
6. Networking opportunities.
7. Credit Union.
8. Access to staff well-being programmes.
9. Generous parental leave entitlements.
10. Strong values-based and inclusive culture.
11. Strong commitment to diversity, equity and inclusion.
12. Great team environment working to our Core Values: Courageous, Caring, Driven and Trusted.

Closing Date

26th September 2024. Note: Applicants who anticipate requiring assistance or reasonable accommodations for any part of the application or interview process may contact, in confidence, recruitment@esb.ie. If you have any queries in relation to this job, please contact recruitment@esb.ie. Your application will be held in reserve for 6 months should you be suitable for the role. #J-18808-Ljbffr