Data Engineer (12 Months)
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
-
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.
-
Responsible for our data infrastructure platforms including SSIS, Azure Synapse and Cloudera.
-
Responsible for building robust and scalable data models as well has helping to shape the vision and architecture of ESBs data infrastructure into the future
-
Responsible for tracking the performance of our resources and growing our capability in line with business requirements.
-
The development of Extract Transform and Load routines, modelling, queries, reports, and analysis.
Experience & Qualifications
Essential
-
Minimum of 5 years’ working experience in data engineering including hands-on development of data pipelines across multiple technologies
-
Ability to troubleshoot and work through technology challenges with external teams.
-
Working knowledge of API integrations.
-
ETL development using Microsoft SSIS or Azure Synapse or Hadoop.
-
Demonstrated strength in data modelling and data warehousing (Kimball /Inmon).
-
Experience building data products incrementally and integrating and managing data sets from multiple sources.
-
Problem solving and query performance tuning skills.
-
Excellent communication and reporting skills.
-
Demonstratable motivation to learn new development skills.
-
Ideas-driven and creative in finding solutions/ designing improved methods, systems, and processes.
-
Competent in writing Transact SQL scripts.
-
Able to work on own initiatives.
Desirable
-
Experience providing technical leadership and mentor other engineers for the best practices on the data engineering space
-
Industry experience as a Data Engineer or related specialty with a record of accomplishment of manipulating, processing, and extracting value from large data sets.
-
Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets.
-
Experience leading large-scale data warehousing and analytics projects.
-
Use of Agile software development.
-
Knowledge of big data tools, e.g. HDFS, HIVE, Sqoop, Oozie, Spark, Sentry
-
Knowledge of Azure services, e.g. Azure Blob storage, Azure Data Lake storage, Logic Apps/ Power Automate, Azure Synapse, Azure Data Factory, Azure SQL Pool, Azure Spark Pool.
-
Use of R/ Python.
-
Familiarity with SAP ERP, SAP BW, SAP Data Services.
-
Use of Microsoft Visual Studio Team Services / Azure DevOps.
-
Experience in designing and developing data visualisations through Power BI or Tableau etc
-
Professional Certification
-
Experience working on multiple parallel projects
-
Stakeholder management
-
Scrum experience
-
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?
-
Opportunity to lead Ireland’s transition to net zero carbon future
-
Progressive, hybrid working model
-
Career development through mentoring and training
-
Corporate Social Responsibility Opportunities
-
Sports and Social Clubs
-
Networking opportunities
-
Credit Union
-
Generous Pension
-
Access to staff well-being programmes
-
Generous parental leave entitlements
-
Strong values-based and inclusive culture
-
Strong commitment to diversity, equity and inclusion
-
Great team environment working to our Core Values: Courageous, Caring, Driven and Trusted
Salary
€55,500 - €65,500 depending on experience
Closing Date
8th October 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.