TEKenable is hiring for an experienced Senior Data Warehouse Engineer in Dublin, Ireland.
This is a B2B contracting opportunity with a hybrid working arrangement for a key customer.
We are hiring for this opportunity in Ireland only.
This role offers an excellent opportunity for an experienced Data Warehouse Developer to join our growing IT team, contributing to the development and support of our mission-critical applications.
As a key member of the DWH Development Team, the successful candidate will bring a strong passion for Data Warehousing, hands-on experience across the full Software Development Life Cycle, and an active interest in emerging DW/BI technologies.
The position involves designing and developing data warehouses, ETL processes, and data marts across both on-premise and public cloud environments.
It also requires close collaboration with stakeholders and management to deliver strategic solutions and ensure new developments align effectively with existing legacy reporting.
Responsibilities
Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensure data is verified and quality is checked.
Collaborate with business and technology stakeholders in ensuring data warehouse architecture development andutilisation.
Work with business analysts and project managers to develop and refine reporting and analytics requirements.
Work on complex projects that require both depth and breadth of knowledge ina number oftechnologies and the business.
Participate on projects, clarifyingthe businessrequirements, performing systems analysis,developmentand modification activities, as well as related maintenance & support.
Assistin planning sessions withthe businessusers to analyse businessrequirements, andprovide design recommendations.
Write concise and clear technical specifications based on analysis of complex business requirements.
Translate business and technical requirements into business application systems.
Advanced knowledge of SQL including complex stored procedures, functions, query optimisation, indexingstrategy.
7+ years of experienceofSSIS and SQL Server Database.
Proventrack recordin delivering scalable and reliable Data Warehousesolutions.
Strong data modelling and dimensional modelling skills (includingslowly changing dimensions).
Experience with data quality and data profiling.
ETL/ELT design and development experience.
Strong communication and self-starter ability
Ability to work effectively in a team environment.
Superb oral/written communication skills.
Experienced in designing,buildingandmaintaininglarge/complexData Warehousesystems is desirable.
Experience with Tableau is also desirable.
Experience of Azure Data Storage, Azure Data Lakes and Azure SQL DB is desirable
Experience of AzureDevops(pipelines, repos, releases etc.) is desirable
Microsoft/Azurecertifications desirable
#J-*****-Ljbffr