Our client is embarking on a strategic data modernization initiative and is seeking a senior Microsoft Fabric consultant to help establish a modern enterprise data platform. This is a greenfield opportunity to design and implement the foundation that will centralize data from numerous internal and external sources, creating a scalable, reliable source of truth for the organization.

Working closely with technical and business stakeholders, you will lead the discovery, architecture, and implementation of a Microsoft Fabric solution capable of ingesting, transforming, and organizing large volumes of structured and semi-structured data.

What You'll Be Doing

• Lead the design and implementation of a Microsoft Fabric data platform.
• Conduct discovery sessions with internal stakeholders to understand current data sources, architecture, and future reporting requirements.
• Design scalable ingestion pipelines for data from approximately 30 external partners and internal systems.
• Build processes to ingest, validate, and transform large XML datasets into structured, analytics-ready formats.
• Develop robust ETL/ELT pipelines using Microsoft Fabric Data Factory, Lakehouse, and related Fabric services.
• Design and implement a modern data model that consolidates information from multiple systems into a single source of truth.
• Integrate data from SQL Server-based data warehouses, third-party vendors, and additional external data sources.
• Create reliable processes for handling inconsistent or imperfect source data while maintaining data quality and integrity.
• Collaborate with business and technical teams to support future reporting, commission, and analytics initiatives.
• Provide recommendations on Microsoft Fabric architecture, governance, security, and best practices. 

Required Experience

• Extensive experience implementing Microsoft Fabric in enterprise environments.
• Strong knowledge of Microsoft Fabric Lakehouse, Data Factory, OneLake, notebooks, pipelines, and semantic models.
• Experience designing modern cloud-based data platforms and enterprise data warehouses.
• Strong ETL/ELT development experience moving data from multiple heterogeneous sources.
• Experience ingesting and transforming large XML datasets into relational or analytical models.
• Advanced SQL skills and experience working with SQL Server.
• Experience designing scalable data models and establishing a single source of truth across multiple business systems.
• Strong understanding of data architecture, data governance, and integration best practices.
• Excellent communication skills with the ability to lead technical discovery sessions and advise stakeholders.

Nice to Have

• Experience within financial services, insurance, or wealth management.
• Experience integrating data from third-party APIs, legacy systems, or vendor file exchanges.
• Knowledge of Canadian insurance industry data standards or ACORD/CLHIA standards.
• Experience handling high-volume file processing and semi-structured data.
• Familiarity with Microsoft Azure data services.

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.

Questions? Call your local office at 1.888.490.4429. All applicants applying for Canadian job openings must be authorized to work in Canada.

Only job postings for jobs located in Quebec appear in French.

© 2025 Robert Half. By clicking “Apply,” you’re agreeing to Robert Half’s Terms of Use and Privacy Notice.