Role: Senior ETL Data Engineer
Job Type: Permanent
Location: Letterkenny (Hybrid – 2/3 days per week in office)
Ready to utilise your skills in Data Engineering?
Are you passionate about helping customers modernize and execute their data strategies?
Join us as a Senior ETL Data Engineer and be part of a collaborative Data Engineering team to develop end-to-end solutions as well as take on a fantastic career growth opportunity!
The Role
This role involves working with High Performing Agile teams in enabling a large financial Institution to execute on their Cloud/Data journey, reinventing core functionality on Legacy infrastructure and developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meet best-in-class standards offering high performance.
Key responsibilities:
* Develop Solutions to enable our client to migrate data from “Golden” sources and deliver data to various consumers such as Product Underwriting, Financial Actuarial systems, and CDO strategic platforms to meet requirements for business data processing, Data Analytics, Reporting and Machine Learning.
* Help with Data Modernization strategy migrating legacy Data Warehouses to Cloud.
* Participate in Program Increment (PI) planning sessions as part of a Scaled Agile team.
Your Profile
Key skills/knowledge/experience:
* Extensive experience with developing Batch ETL/ELT processes using SQL Server and SSIS.
* Strong experience writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.
* Extensive experience in designing and building complete data pipelines, moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using SQL Server Integration Services (ETL) or other related technologies.
* Strong experience Implementing Data Warehouse solutions (Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS, or other related technologies.
* Extensive experience with large-scale data processing and query optimization techniques using TSQL.
* Solid experience with implementing audit, balance, and control mechanism in data solutions.
* Solid experience with any source control repos like GIT, TFVC or Azure DevOps, including branching and merging and implement CICD pipelines for database and ETL workloads.
* Strong understanding of DW concepts including 3NF and Dimensional data models.
* In-depth knowledge of ETL Design Patterns, Optimal Data Flow mechanisms and SQL development best practices.
Next Steps
Due to a high volume of applications, we will be unable to contact each applicant individually on the status of their application. If you have not received a direct response within 30 days, then it should be deemed unsuccessful on this occasion.
Join us and do more of what matters. Apply online now.
#J-18808-Ljbffr