Data Warehouse Lead - Canada (Remote)

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 arenaflex 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 arenaflex 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 arenaflex 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 arenaflex 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 arenaflex 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 arenaflex 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 companiesis 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 Apply tot his job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...