ETL Data Engineer

ETL Data Engineer
Dublin / Hybrid Permanent Hybrid Negotiable Ref:

Job Description

My client is currently recruiting for an ETL Data Engineer to join the team. This role will be working off a hybrid model.

My client is currently recruiting for an ETL Data Engineer to join the team. This role will be working off a hybrid model. The ETL Data Engineer will be responsible for designing & driving the data integration of data, data warehouse design and delivery of BI Solutions.

Job Responsibilities

  • You will design & integration of new data feeds & migration of new data sets as they are identified or are acquired as the business grows.
  • You will determine optimal solutions for integrating data from a variety of sources into a common data warehouse normalised structure, within an ETL Framework
  • You will be doing ongoing DWH modelling in a normalised star schema structure, along with de-normalised reporting data marts
  • You will implement, maintain & monitor batch & stream data pipelines with best practice quality controls
  • Performance optimisation of data processing e.g. parallel processing, RAM & CPU usage as well as storage & growth monitoring & ongoing engagement with DBA’s
  • You will work closely and collaboratively in an Agile environment with the broader Data Team to analyse issues & find new insights that help drive business performance.
  • You will do ongoing unit testing, system integration testing & data reconciliations. Coordination & support for UAT
  • Automate the application of master data management transformations.
  • Day to day operational support of data infrastructure & services
  • Definition & Implementation of data security & compliance policies & regulations e.g. GDPR
  • Help define, implement and lead on robust data management data quality processes across the company
  • You will support the creation & maintenance of documentation deliverables including, but not limited to architecture diagrams, data flow diagrams, metadata, data dictionary, entity-relationship diagrams, data mapping documents, and other data design artifacts that define technical data specifications and transformation rules.
  • You will design & build best in class processes to clean & standardise data
  • You will support KPI definition process & hold custody of historic knowledge of data and meaning
  • Identify and help standardise the use and governance of data

Experience Required

  • Have a min of 5 years development experience in ETL, SQL Programming, large scale systems data integration and Data Warehousing environments
  • Experience in data management frameworks; Data Quality Profiling, Metadata Management, Master Data Management, cleansing/standardising, analysing
  • Deep knowledge of SQL, database model design (Fact & Dim tables) and all other data warehousing concepts
  • Proven experience with SSIS and Azure Data Factory essential
  • Expert familiarity with market leading data integration technologies.
  • Strong command of relevant programming/scripting languages: e.g. Java, Scala, Python, R
  • Strong understanding of Business Intelligence strategies/design as it relates to Data analysis.
  • Financial services or Insurance experience strongly desired.
  • Good project management skills; experience managing projects / requests with multiple senior stakeholders

Essential and Desirable Skills

  • Proven experience with SSIS and Azure Data Factory essential

Educational Requirements

  • Bachelor’s degree in computer science/information systems

Working Hours & Benefits

  • 37 Hour Working Week
  • 24 Days Annual Leave
  • Hybrid Working
  • PHI Benefit
  • Pension 5% / 5%
  • Maternity Leave
  • 10% Bonus
  • Sport & Social Club

Consultant Details

Nicola Byrne's Profile Picture
Name: Nicola Byrne
Title: Senior IT Recruitment Consultant
Apply for Job Call me now Add to Shortlist

How to Apply

If you are interested in this role, then please Apply along with your updated CV and I will be in touch with you to discuss your application in more detail, otherwise feel free to connect with me by whichever medium you are most comfortable with be that Linkedin, Email or Telephone. Remember we have limited our site to a maximum of 200 Jobs so if this Role is not a 100% match to your requirements please be sure to connect with us as we will most likely have another role which you may find more suitable.

Apply for Job

Not what you're looking for?

If this isn't the job for you then why not reach out to one of our consultants today and send us your CV so we can find the one that is?

Reach out to a Consultant Upload your CV

Email Job Details

  • Enter your details below to email this job to yourself or a friend.

  • In order to submit this form you'll need to agree with our Privacy Policy

Apply for Job

  • Enter your details below to apply for this job, the consultant will then contact you as soon as possible.

  • Accepted file types: pdf, doc, docx, odt, Max. file size: 4 MB.
    Friendly advice to all candidates - ‘Keep it Simple’. We use an automatic scanner to capture your CV, and key details. We then transfer this info to our database. Automated scanners are not compatible with CV’s drafted on powerpoint or with images, or excessive in design. Please use where possible standard word documents for CV formatting and submission where possible. This will maximise your details being retrieved in searches for job roles that fit with your skills and experience. Thank you.
  • In order to submit this form you'll need to agree with our Privacy Policy

Upload your CV

  • Send us your CV and we'll be in touch with jobs relevant to you.

  • Accepted file types: pdf, doc, docx, Max. file size: 10 MB.
    Friendly advice to all candidates - ‘Keep it Simple’. We use an automatic scanner to capture your CV, and key details. We then transfer this info to our database. Automated scanners are not compatible with CV’s drafted on powerpoint or with images, or excessive in design. Please use where possible standard word documents for CV formatting and submission where possible. This will maximise your details being retrieved in searches for job roles that fit with your skills and experience. Thank you.
  • In order to submit this form you'll need to agree with our Privacy Policy
× Speak with our team