Data Warehouse Lead

Info-Tech Research Group delivers impartial, highly pertinent IT research, enabling CIOs and IT leaders to make well-informed, strategic decisions. We are currently serving over 30,000 professionals and collaborate closely with IT teams, equipping them with actionable tools and expert guidance to drive measurable results and enhance technology initiatives and organizational processes.

Why join us?

• We pride ourselves on consistent year-on-year growth, with double-digit growth even during a global pandemic.
• We are in the Top 3 on LinkedIn's Top Companies List in Canada.
• Info-Tech fosters a growth-focused, entrepreneurial culture with unlimited opportunities for professional growth and development.
• We provide financial support for professional development and training.

About the role

We are seeking an experienced Data Warehouse Lead to drive the end-to-end implementation of Microsoft Fabric across the organization. This role combines strategic vision with hands-on technical execution, enabling the transformation of our data ecosystem into a unified, intelligent, and scalable platform.

You will lead the setup of ETL/ELT pipelines, design and implement the bronze, silver, and gold layers of our data Lakehouse, and oversee the configuration of key Fabric components including Data Factory, One Lake, and Power BI. You'll also play a pivotal role in exploring advanced capabilities such as Microsoft Copilot to accelerate analytics and automation.

Key Responsibilities

1. Strategic Design & Architecture

• Collaborate with the Data & Analytics (D&A) team and business stakeholders to translate business needs into scalable data architecture.
• Define and implement a modern data Lakehouse framework using Microsoft Fabric, ensuring alignment with organizational goals and best practices.
• Lead the design of Bronze–Silver–Gold data layers to support structured, semi-structured, and unstructured data transformation.

2. Technical Implementation & Delivery

• Build and optimize ETL/ELT pipelines using Microsoft Data Factory, Dataflows Gen2, and Fabric Data Engineering environments.
• Configure One Lake, Fabric Data Warehouse, and Power BI workspaces for seamless integration and unified governance.
• Explore and implement CoPilot features within Fabric to streamline query generation, documentation, and user interactions.

3. Leadership & Stakeholder Engagement

• Engage with executives and functional leaders to establish metrics, strategies, and implement roadmaps for enterprise-wide analytics.
• Facilitate value-driven stakeholder conversations to identify data opportunities and define innovative solutions that exceed expectations.
• Provide thought leadership and proactively present new approaches, automation techniques, and architectural patterns to enhance data delivery.

4. Governance, Standards & Reusability

• Curate and maintain a repository of data architecture principles, design patterns, and reusable components for data engineers and integrators.
• Promote consistency, scalability, and data quality through governance frameworks, metadata management, and documentation standards.
• Collaborate with the Director of Data Operations to ensure robust support, education, and alignment across business units.

Qualifications and Experience

• Minimum 7+ years of professional IT experience across multiple organizations, including leadership roles in Data Architecture, Data Engineering, or AI.
• Proven track record in end-to-end data platform implementations, preferably within the Microsoft Azure and Fabric ecosystem.

Technical Expertise

• Expertise in:
  • Data Strategy and Architecture (strongly desired)
  • Data Lakehouse / Data Warehouse design
  • ETL/ELT frameworks and orchestration
  • Data Integration and Management
  • Data Quality, MDM, and Enrichment
• Business Intelligence and Analytics (Power BI, Fabric Warehouse)
  • Hands-on experience with Microsoft Synapse, Azure Data Factory, SQL, Spark, and data modeling tools.

Leadership & Soft Skills

• Exceptional communication, presentation, and stakeholder management abilities.
• Strong collaboration and relationship-building skills across technical and non-technical teams.
• Demonstrated ability to coordinate complex service delivery models and balance competing priorities.
• A self-starter who leads with initiative, strategic thinking, and accountability.
• Alignment with Info-Tech Research Group's core values of integrity, trust, and member-first excellence.

Language Skills: Bilingual proficiency in French, Spanish or German is nice-to-have to support our diverse client base across North America and globally.

Info-Tech Research Group of companies is an equal opportunity employer committed to diversity and inclusion and does not discriminate on the basis of any legally protected status or characteristic including Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran and are pleased to consider all qualified applicants. To that end, upon request, ITRG will ensure, to the extent possible, that accommodation be made available to applicants throughout the recruitment and hiring process.

#LI-CL2