Senior EDW Data Engineer

What is the opportunity?

Join our exciting data engineering team on our journey of data and digital transformation! We are a data led organisation where we play a pivotal role helping our business and customers make critical financial decisions.

This is an exciting time for Data Engineering in BOI as we progress implementing our cloud strategy, pivoting from the traditional on-prem data landscape to a modern cloud-based data lake and warehouse platform, taking advantage of AI opportunities and transitioning workloads to that new cloud Enterprise Data Lake platform.

The EDW Data Engineers will work with our agile delivery teams, engineering high quality solutions on our on-prem Teradata Enterprise Data Warehouse platform. You will gain experience building and maintaining data pipeline solutions on our Teradata EDW platform and be instrumental in driving a future transition to a cloud-based data warehousing platform. We work in a very collaborative environment with a learning culture.

In this Role, you will

• Provide technical leadership and guidance to other Data engineers
• Take the lead in enabling the builds of complex data flows and process's leveraging our on-prem Teradata Enterprise Data Warehouse.
• Make decisions on engineering frameworks, tooling, and patterns
• Advocate and drive Automation and the adoption of processes such as TDD.
• Be naturally curious and have experimented with the use of AI to enhance data engineering processes.
• Solve complex technical problems and provide creative solutions from your experience or through a rational problem-solving process.
• Ensure teams are following engineering best practices, our engineering standards and process's while driving improvements in parallel

What Will Make You Stand Out

We are seeking a leader with enthusiasm and a growth mentality who prioritises collaboration with others. You are proactive to achieve the necessary outcome while improving processes, people, and tooling along the way!

You have a proven track record as a Senior Data Engineer in the Enterprise Data Warehouse domain with a preference for Teradata. You have deep technical knowledge of ETL / ELT data pipelines, GCFR, TPT, Stored Procedures, Data Lake, Cloud Technologies, and Architecture, preferably AWS (Amazon Web Services).

Further technical knowledge and/or experience in the below are necessary to apply:

• Proficiency in SQL (DDL & DML), Python.
• Strong knowledge of the Teradata Platform, GCFR, TPT and stored procedures.
• Knowledge of data flow integrations using Informatica.
• Knowledge of Kimball and Inmon data warehousing concepts.
• Strong experience in building and managing different data load patterns i.e. CDC, API and streaming data.
• Expertise in building / supporting platforms to enable processing of large datasets, streaming data, and unstructured data.
• Workflow orchestration skills using either Oozie, Airflow, Ctrl-M.
• Familiar with AI concepts and willingness to explore LLM's, Generative AI and Machine Learning.
• Knowledge in Metadata Management, Governance frameworks (Atlas, Collibra), and Reporting tools (Tableau, PowerBI, Observability, Looker, Qlikview).
• DataOps expertise including Bitbucket, Jenkins, Terraform.
• Scrum/Kanban, CI/CD, DevOps, SAFe delivery methodologies.
• Jira and Confluence

Experience with any of the following will help you to stand out but is not necessary in order to apply for this role:

• Teradata certification.
• Migrating on-prem data warehouses to the cloud, preferably AWS.
• Building data solutions on AWS.
• Other Cloud data platforms like Cloudera, Databricks, Redshift, Snowflake and Synapse.
• Modern IDE, debugging and linting tooling.
• Demonstrable ability to derive and share Data-Driven insights with Business and Technical teams
• Demonstrated ability of identifying and introducing process optimizations

Essential Qualifications

There are no specific qualifications or minimum educational requirements needed for this role.

More About The team

Our growing and exciting Data Engineering team provides the engineering services for the Group's Enterprise Data Warehouse and Enterprise Data Lake. We sit within the Group Data & Analytics Office which is the core team for all things data in the bank.

We deliver the data elements to support Digital, Customer, Regulatory and other change initiatives that drive the Group's transformation agenda.

We have fully embraced agile software engineering and a DevOps mentality and operate in a highly collaborative team environment.

This is a hybrid role and can be done anywhere in the Republic of Ireland with the primary office location as Dublin. Travel will be required for in person collaboration exact frequency to be agreed with manager.

#li-hybrid #ij-hybrid

Why work with us?

The Bank of Ireland company culture prioritises work-life balance with an opportunity for flexible working, along with 25 days annual leave and excellent pension contributions. Family can mean different things to different people; we offer 6 months paid maternity leave, an innovative fertility and surrogacy policy and working parent supports.

Your wellbeing is important to us; we have an employee assistance program, WebDoctor and financial wellbeing coaches available. We also encourage and support staff to pursue educational and professional qualifications to grow and enhance your career!

Flexible working matching promise

We know how important flexible working arrangements are to our colleagues, and we promise to try to match your current flexible working arrangement in this new role (all existing working arrangements considered!)

Key Competencies

• Customer Focused - People Manager
• One Group, one team - People Manager
• Champion Transformation - People Manager
• Accountable - People Manager
• Manage Risk - People Manager

Where Agency assistance is required Bank of Ireland Recruitment Team will engage directly with suppliers. Unsolicited CVs / profiles supplied to Bank of Ireland by Recruitment Agencies will not be accepted for this role.

We're on a continuous journey to build an inclusive and diverse workplace. We welcome applications from people of all backgrounds, lived experience, abilities and perspectives. Reasonable accommodations are offered at every stage of our recruitment process. If you require any assistance, please complete this form and one of our recruitment team members will be in touch via email. Any information provided will be treated as confidential within the recruitment team and used only for the purpose of determining and providing appropriate accommodations for the application and recruitment process.