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 Intern building and maintaining data pipelines for AI - driven financial insights. Opportunity to work at forefront of technology in a collaborative start - up environment.
Data Architect responsible for designing and maintaining data architecture at Uriage & Apivita. Leading data management efforts to support analytics and ensure high - quality data flows across systems.
Data Engineer at Flip building and maintaining scalable data pipelines for ingestion into BigQuery and collaborating with data analysts to enable insights.
Senior Data Engineer building scalable data pipelines and supporting analytics for insurTech platform. Collaborating with cross - functional teams to drive data - driven decisions and improve services.
Senior Data Engineer developing and maintaining data solutions while ensuring data governance for the organization. Collaborating with teams using Microsoft Azure technologies in a hybrid work environment.
Lead Data Engineer in charge of designing and optimizing cloud - based data platforms for healthcare. Collaborating with teams while implementing scalable, secure solutions.
Senior Fabric Data Engineer designing and optimizing data solutions using Microsoft Fabric for diverse clients. Collaborating with teams and mentoring junior engineers in data platform initiatives.
Senior Data Architect responsible for defining scalable data architectures, supporting analytics, and collaborating with engineering, cloud, and security teams for a client.
Enterprise Data Architect at Togetherwork responsible for AWS - native data strategy and architecture. Design and implement scalable data solutions to support multi - product SaaS portfolio.