Senior Database/Data Warehouse Consultant - contract

Location: Dublin / Hybrid Working

Contract Type: Fixed-Term Contract / Daily Rate Engagement

Reporting To: Senior BI Architect

We are seeking an experienced Senior Database/Data Warehouse Consultant (Integration Lead) to lead the design and implementation of enterprise-scale data integration solutions supporting a modern Microsoft Fabric platform.

The role will focus on building scalable integration frameworks, ETL/ELT processes, hybrid cloud architectures, and data quality capabilities that support critical operational and analytical workloads.

Key Responsibilities

Lead the design and implementation of enterprise data integration solutions.

Develop scalable Microsoft Fabric Data Factory and Azure Data Factory pipelines.

Design and support enterprise integration frameworks and standards.

Implement robust ETL/ELT solutions across cloud and on-premises environments.

Build data ingestion, transformation, orchestration, and monitoring capabilities.

Design and implement:

Data quality frameworks

Validation controls

Reconciliation processes

Logging and alerting mechanisms

Support batch and near real-time data integration patterns.

Optimise integration performance, scalability, and reliability.

Document architecture, interfaces, pipelines, and data flows.

Provide technical mentorship and knowledge transfer to internal teams.

Requirements

7+ years' experience in data integration, data engineering, or data warehouse consultancy.

Proven experience delivering enterprise-scale data integration solutions.

Strong experience with:

Microsoft Fabric

Fabric Data Factory

Azure Data Factory

Azure SQL

SQL Server

Lakehouse and Warehouse architectures

Extensive ETL/ELT design and implementation experience.

Experience integrating hybrid cloud and on-premises platforms.

Strong SQL and data engineering skills.

Experience implementing monitoring, logging, and exception-handling frameworks.

Deep understanding of data quality, governance, and integration best practices.

Preferred Qualifications

Degree in Computer Science, Data Engineering, Information Technology, or related field.

Microsoft Azure Data Engineer certification or equivalent.

Microsoft Fabric certification.

Key Skills

Microsoft Fabric

Fabric Data Factory

Azure Data Factory

Azure SQL

SQL Server

ETL / ELT

Data Engineering

Data Integration

Data Warehousing

Data Quality & Governance