Data Engineer

Data Engineer

My client based in Dublin 8, are looking for an experienced Data Engineer to design, build, and maintain robust data solutions that support reporting, analytics, and operational needs across our client solutions. This role is ideal for someone with deep SQL Server expertise and strong experience working with data warehouses and complex data processes.

Key Responsibilities

• Design, develop, and maintain complex SQL Server–based data processes
• Create, optimize, and manage stored procedures, functions, and views
• Build and support reliable ETL/ELT pipelines feeding enterprise data warehouses
• Ensure data quality, integrity, performance, and scalability across all data solutions
• Collaborate with analysts, developers, and stakeholders to translate requirements into technical solutions
• Troubleshoot and resolve data issues in production environments
• Document data models, processes, and technical designs

Required Skills & Experience

• Advanced knowledge of SQL Server, including performance tuning and query optimisation
• Strong experience developing and maintaining complex stored procedures and functions
• Solid understanding of data warehouse concepts (dimensional modelling, fact/dimension tables, SCDs, etc.)
• Hands-on experience building and supporting end-to-end data pipelines
• Strong problem-solving skills and attention to detail
• Ability to work independently and manage multiple data processes simultaneously

Desirable Skills

• Experience with ETL tools or SQL-based data integration solutions
• Exposure to cloud data platforms (e.g. Azure, AWS, or similar)
• Familiarity with data governance, security, and best practices
• Experience supporting BI or analytics platforms