Level 3- Senior Data Engineer

Date: 13 Sep 2023

Location: Dublin, IE

Company: Allied Irish Bank

Role: Senior Production Support Data Engineer and Analyst – Data and Analytics


Location: Central Park, Leopardstown / Hybrid


This role is being offered on a Permanent basis.


  • Do you have significant experience in Ab Initio ETL tool?
  • Can you recognise opportunities to automate performance monitoring?
  • Have you lead the investigation and build of data and processes fixes?
  • Can you optimise the code to ensure processes perform optimally?


Data and Analytics in AIB

AIB is a dynamic, diverse, and fun place to work. We are changing from the inside out to become a bank people can believe in. And by people, we mean our employees as well as our customers. We back our customers and employees’ dreams and ambitions! We are investing in the future with a heavy focus on expanding the Data & Analytics Centre of Excellence – so it’s a great time to join and help shape and grow this function, as we become a data driven bank with best-in-class analytical capabilities. Within Data & Analytics you’ll experience a diverse workforce where everyone has the opportunity to reach their potential. We work in an agile environment that empowers its people, where your voice is heard and where you’ll be invested in to learn and grow along the way.


About the Role:

A Senior Production Support Data Engineer is responsible for the successful completion of the overnight ETL batches loading to the Enterprise Data Warehouse, within the agreed SLA’s. This provides the business timely access to accurate data flows for their reporting commitments.

This role will involve working closely with the Operational teams within the CTO such as Problem and an incident management, IT Operations and Batch Management to ensure a collaborative approach to managing the extensive Data Engineering batch.

The Ab Initio Production Support team forms part of the Data Engineering and Architecture area within the Centre of Excellence for Data and Analytics at AIB.

Our Production Support Data Engineering Team plays a key role in enabling timely access to accurate data, by monitoring the performance and failures in the overnight batch and intervening when necessary to ensure its completion.


Skills needed for this role.

  • Communication skills. You know how to communicate to and between technical and non-technical stakeholders as well as facilitate discussions within a multidisciplinary team, with potentially difficult dynamics. You can advocate for the team externally. You know how to manage different perspectives.
  • Data analysis and synthesis. You know how to undertake data profiling and source system analysis and can present clear insights to colleagues to support the end use of the data.
  • Data development process. You can design, build, and test data products that are complex or large-scale. You know how to build teams to complete data integration services.
  • Data innovation. You understand the impact of emerging trends on the organisation in data tools, analysis techniques and data usage.
  • Data integration design. You know how to select and implement the appropriate technologies to deliver resilient, scalable, and future-proofed data solutions.
  • Data modelling. You understand the concepts and principles of data modelling and can produce relevant data models across multiple subject areas. You know how to reverse-engineer data models from a live system. You understand industry-recognised data modelling patterns and standards and when to apply them. You can compare and align different data models.
  • Metadata management. You can design an appropriate metadata repository and present changes to existing metadata repositories. You understand a range of tools for storing and working with metadata. You can provide oversight and advice to more inexperienced members of the team.
  • Problem resolution. You know how to respond to problems in databases, data processes, data products and services as they occur. You can initiate actions, monitor services, and identify trends to resolve problems. You can determine the appropriate remedy and assist with implementation of it as well as preventative measures.
  • Programming and build. You know how to use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations. You can collaborate with others to review specifications where appropriate.
  • Technical understanding. You understand core technical concepts related to the role and can apply them with guidance.
  • Testing. You can review requirements, specifications and define test conditions. You can identify issues and risks associated with work while being able to analyse and report test activities and results.



Key Responsibilities Include:

  • Recognise opportunities to automate performance monitoring.
  • Lead the investigation and build of data and processes fixes.
  • Optimise the code to ensure processes perform optimally.
  • Lead work on database management.



What you will bring:


  1. Minimum of bachelor’s degree in a discipline incorporating: information management related disciplines or quantitative analytical techniques, e.g., Software Engineering, Data and Analytics, Mathematics, Statistics.
  2. 4+ years’ experience as a production support developer in a relevant area, with knowledge of dependency analysis investigations.
  3. 4 + years’ Experience in Ab Initio ETL tool.
  4. Excellent analytical and problem-solving skills with expertise and knowledge of data integration technologies such as ETL (Extract, Transform and Load).
  5. Database experience on Teradata or other Databases (Oracle, DB2, Hive, Impala, Kudu, MS SQL Server, MongoDB, Cassandra).
  6. Experience in managing complex scheduled batch processes within an Enterprise Scheduler such as TWS (Tivoli)
  7. Knowledge of the data quality challenges and impacts financial services organisations face and of solutions to sustainably address these. 
  8. Awareness of relevant financial services regulations such as BCBS, FATCA etc.
  9. Strong communication skills with a proven track record of articulating complex concepts/results in simple language.
  10. Experience of leading junior team members a plus.



Life at AIB


At AIB, we have a clear purpose - to back our customers to achieve their dreams and ambitions. We want to be at the heart of our customers’ financial lives by giving them an exceptional experience. That goes for our employees too.

We are building a culture that breaks the conventions of what our customer and employees expect of a bank.


We are committed to offering our colleagues choice and flexibility in how we work and live.  Our hybrid working model enables our people to balance their time between working from home and their designated office, subject to their role, the needs of our customers and business requirements.  More details on our hybrid working arrangements and expected office attendance for your role will be provided to you during the recruitment process.


AIB is an equal opportunities employer, and we pride ourselves on being the first bank in Ireland to receive the Investors in Diversity Gold Standard accreditation from the Irish Centre for Diversity. We celebrate diversity and believe in a culture of inclusion where all our employees can succeed. We welcome applications from people of diverse backgrounds and abilities. We are committed to providing reasonable accommodations for applicants and employees. Should you have a reasonable accommodation request please email the Talent Acquisition team at careers@aib.ie.


If you feel you have what it takes, click apply and fill in the online application form. If you would like more information, please contact the Talent Acquisition Team at careers@aib.ie



By when?  Closing date is Wednesday 27th September 2023



Unsolicited CVs sent to AIB by Recruitment Agencies will not be accepted for this position. AIB operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our recruitment partners.

Job Segment: Test Engineer, Testing, Recruiting, ERP, Database, Engineering, Technology, Human Resources