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
