Senior Data Warehouse Engineer developing ETL processes and data warehouses for hybrid working setup in Dublin. Collaborating with IT teams and stakeholders to implement strategic data solutions.
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 and utilisation.
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 in a number of technologies and the business.
Participate on projects, clarifying the business requirements, performing systems analysis, development and modification activities, as well as related maintenance & support.
Assist in planning sessions with the business users to analyse business requirements, and provide design recommendations.
Write concise and clear technical specifications based on analysis of complex business requirements.
Translate business and technical requirements into business application systems.
Requirements
Advanced knowledge of SQL including complex stored procedures, functions, query optimisation, indexing strategy.
7+ years of experience of SSIS and SQL Server Database.
Proven track record in delivering scalable and reliable Data Warehouse solutions.
Strong data modelling and dimensional modelling skills (including slowly 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, building and maintaining large/complex Data Warehouse systems is desirable.
Experience with Tableau is also desirable.
Experience of Azure Data Storage, Azure Data Lakes and Azure SQL DB is desirable.
Experience of Azure Devops (pipelines, repos, releases etc.) is desirable.
Microsoft/Azure certifications desirable
Job title
Senior Data Warehouse Engineer, SQL Server, SSIS, Azure
Data Engineer building and scaling client - facing Microsoft Fabric analytics platform to drive revenue and decision - making. Collaborating with teams to develop pipelines, optimize performance, and ensure client satisfaction.
Data Engineer role focusing on migrating legacy systems to ADA at BBVA. Collaborate with multidisciplinary teams and ensure system integrity during transitions.
Senior Data Engineer focused on modernizing enterprise data capabilities at U.S. Bank. Designing and building reusable data engineering patterns for consistent delivery across teams.
Principal Data Pipeline Lead at SS&C overseeing development of scalable data pipelines. Leading a small team and providing technical guidance for modern data platform integration.
Senior Data Engineer at SS&C building and optimizing data pipelines in a lakehouse environment. Collaborating with data architects and stakeholders in the financial services sector.
Experienced Data Architect designing and implementing scalable data architecture for a financial services and healthcare technology company. Collaborating across teams to support analytics and operational needs.
Data Architect designing scalable, secure data architectures for fraud detection and risk management at Fiserv. Collaborating with cross - functional teams and managing large datasets and pipelines.
Director of Engineering overseeing development of AI - driven data platforms at LVT. Leading teams to transform sensor data into actionable insights using modern architecture and technologies.
Senior Data Engineer at Independence Pet Holdings shaping data ecosystem by building platforms and pipelines. Collaborating with teams to enhance data analytics and operational insights.
Senior Data Engineer designing and developing scalable data pipelines for fintech company. Collaborating with stakeholders to ensure analytics - ready data formats and supporting batch and streaming processes.