freehire launches on Product Hunt on 26 August.

Follow →

Senior Database/Data Warehouse Microsoft Fabric Consultant - contract

Open 34d

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

What this application asks

workable

First name, Last name, Email, Phone, Address, LinkedIn, Experience, Resume, Cover letter

  • Please summarise your experience designing and delivering enterprise-scale data integration solutions. In your response, include examples of projects involving batch, near real-time, or event-driven architectures, and describe your role in establishing integration standards, frameworks, governance controls, and technical best practices. (Required) written answer
  • Please summarise your experience working with Microsoft Fabric, including Data Factory, Data Pipelines, Lakehouse and Warehouse architectures. Include examples of end-to-end data pipelines and orchestration workflows you have delivered, the technologies used, and the business outcomes achieved. (Required) written answer
  • Please summarise your experience designing and implementing ETL/ELT solutions using technologies such as Azure Data Factory and Microsoft Fabric. In your response, include examples of integrating cloud and on-premises systems, implementing data synchronisation, replication, secure data movement mechanisms, and managing complex enterprise integration requirements. (Required) written answer
  • Please summarise your experience implementing data quality frameworks, including data profiling, cleansing, validation, reconciliation, monitoring, logging, and alerting. Include examples of how you identified, investigated, and resolved data integration, pipeline, or processing issues. (Required) written answer
  • Please summarise your experience working with enterprise data platforms such as Azure SQL, SQL Server, Synapse Analytics, or similar technologies. In your response, provide examples of designing scalable data integration solutions, optimising performance, and applying advanced SQL and data manipulation techniques to support business and analytics requirements. (Required) written answer

See also

Tailor your CV for this role?

We couldn't check your fit for this role — add a CV to your profile to see it next time.

A new version of freehire is available