Lead Architect – Data & Advanced Analytics

ITI is over 35 years of advising and making IT projects come to life for our clients. But above all we’re human IT experts who embrace our visionary side. We rethink IT to make a positive impact on companies, industries and the economy.  

At ITI, we value new ideas and combining areas of expertise. We like intelligence in all its forms: technological, human, individual and collective.  

Working with us means having the opportunity to grow and develop IT in your own way, for yourself and the more than 1,500 clients we serve. To innovate with one of Canada’s Best Managed Companies, where IT is developed by humans, for humans.  

Unify Data. Unlock Intelligence. Create Impact. 

Please note that the job title listed may differ from the internal title to align with commonly used market terminology and improve job search visibility. 

Internal job title: Senior Advisor, Data and Artificial Intelligence. 

ITI is looking for a Lead Architect – Data & Advanced Analytics to join its growing Data & AI consulting practice.  

In this hands-on role, you will contribute directly to the design, development, and optimization of modern data platforms built on Microsoft Fabric and Azure technologies. You will work closely with clients, architects, and project teams to deliver scalable analytics, reporting, and AI solutions while providing technical leadership throughout project execution. 

You will play a key role in building robust data environments that enable organizations to unlock the full value of their data and accelerate their innovation initiatives. 

To reflect common practices and terminology used in the data and artificial intelligence field, certain terms are intentionally presented in English. 

Your role at ITI

You will be responsible for:    

Data Platform Architecture & Design 

• Design and implement modern data platforms leveraging Microsoft Fabric, Azure Databricks, and Snowflake; 
• Define scalable Lakehouse and Data Warehouse architectures based on industry best practices; 
• Design ingestion, transformation, and semantic modeling strategies to support analytics and AI use cases; 
• Define data models, transformation patterns, and storage strategies that support enterprise analytics initiatives; 
• Participate in solution design, architecture reviews, and implementation planning; 
• Collaborate with architects and delivery teams to ensure alignment between business requirements and technical solutions. 

Data Engineering & Development 

• Develop and optimize data solutions using Microsoft Fabric components, including OneLake, Lakehouse, Data Warehouse, Data Factory, Real-Time Intelligence, and Power BI; 
• Build scalable ETL/ELT pipelines and reusable data engineering frameworks; 
• Develop enterprise-grade solutions using SQL, Python, and PySpark; 
• Design and optimize Spark workloads, data pipelines, and semantic models to ensure performance and scalability; 
• Implement reusable ingestion and transformation frameworks; 
• Contribute to enterprise reporting and analytics solutions through robust semantic models. 

Governance, DevOps & Operations 

• Implement CI/CD best practices, deployment automation, and source code management processes; 
• Apply best practices for security, governance, data quality, and environment monitoring; 
• Contribute to Microsoft Purview initiatives, metadata management, data lineage, and compliance requirements; 
• Participate in clients’ data governance and security initiatives; 
• Design secure, scalable, maintainable, and cost-efficient solutions. 

Technical Leadership & Collaboration 

• Provide technical leadership through mentoring, coaching, and code reviews; 
• Support technical decision-making and resolution of complex data engineering challenges; 
• Collaborate with clients, architects, project managers, account managers and delivery teams; 
• Contribute to technical standards, accelerators, and best practices within the Data & AI practice; 
• Participate in technical workshops, architecture discussions, and solution planning activities. 

This position is for you if…

• You enjoy building data solutions as much as designing them; 
• You thrive on solving complex technical challenges and delivering practical solutions; 
• You are passionate about Microsoft Fabric and modern data platforms; 
• You enjoy collaborating with multidisciplinary teams and working directly with clients; 
• You are passionate about knowledge sharing and helping others grow; 
• You want to contribute to the growth of an innovative and evolving Data & AI practice. 

What we’re looking for

Profil

• Minimum of 5 years of experience in data engineering, advanced analytics, or modern data platforms; 
• Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field; 
• Strong hands-on experience with Microsoft Fabric; 
• Advanced proficiency in SQL, Python, and PySpark; 
• Experience designing and implementing Lakehouse and Data Warehouse solutions; 
• Strong understanding of data modeling, ETL/ELT methodologies, and distributed data processing; 
• Experience building scalable cloud-based data solutions; 
• Experience with Azure Databricks, Snowflake, Azure Synapse Analytics, or comparable cloud data platforms; 
• Solid understanding of data governance, security, and data quality principles; 
• Experience implementing DevOps and CI/CD practices using Git, Azure DevOps, GitHub, or equivalent tools; 
• Demonstrated ability to provide technical leadership in complex initiatives; 
• Experience in consulting, client-facing projects, or technical advisory roles; 
• Strong proficiency in French, both spoken and written. An advanced level of English is required, as approximately 30% of interactions are conducted with English-speaking clients. 

Assets 

• Microsoft Certified: Fabric Data Engineer Associate (DP-700) certification; 
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) certification; 
• Microsoft Certified: Azure Data Engineer Associate (DP-203) certification; 
• Experience with Real-Time Intelligence and enterprise data governance initiatives; 
• Experience with Microsoft Purview; 
• Experience with Azure AI Services or AI-enabled analytics solutions; 
• Experience with Direct Lake, semantic models, or enterprise analytics environments; 
• Experience working in consulting environments or delivering client-facing projects; 
• Experience with hybrid, multi-cloud, or multi-platform architectures. 

Human qualities

• Strong analytical thinking and problem-solving abilities; 
• Natural technical leadership and collaborative mindset; 
• Ability to communicate effectively with both technical and non-technical audiences; 
• Strong attention to quality, detail, and execution; 
• Curiosity, autonomy, and commitment to continuous learning; 
• Adaptability in fast-changing environments; 
• Strong team spirit and commitment to collective success. 

What we offer

Our code of honour ensures that you’re never just a number. We empower our teams to take on challenges with agility. Each and every one of us has the autonomy to get things done.  

Concretely, this means:

• A work environment where transparency and honesty reign — where everyone enjoys autonomy and the trust and attention of their leaders ; 
• The ability to divide your time between home and the office — and have truly flexible working hours ; 
• Summer schedule — 8 additional half-days off ; 
• A group insurance plan — adaptable to your needs ; 
• A telehealth service including 24/7 access to medical personnel — to respond to your concerns ; 
• Personal days — to ensure you’re there for life’s important moments ; 
• Floating holidays — to help you take some time off in your busy life ; 
• A Group RRSP — to plan for life after your career ; 
• Continuing education — to develop your skills and help you grow. 

Our values

We believe how we do something is just as important as what we do.
We leverage our expertise, ethics, commitment and excellence to advise, collaborate and bring projects to life.

We are ITI

We believe in blending styles and backgrounds. In the differences that push us to think differently. That’s why ITI has an Equal Employment Opportunity program and encourages women, people with disabilities indigenous people and visible minorities to submit their application. We are working to become an inclusive employer for all and accommodation measures may be provided, upon request, to persons with disabilities throughout the pre-screening and selection process.

Our simple recruitment process

Simplifying things is in our DNA.

If your application is selected, you will be invited to an initial virtual interview with our recruitment specialist. If this interview is successful for both of us, you will be invited to a virtual interview with the hiring manager and our recruitment specialist. If necessary, a technical interview may be added to the process for IT positions.

All applications are treated as confidential.

By submitting your application for this position, you consent to our collection and use of your personal information for the purpose of evaluating your application. If your application is unsuccessful, you also consent to our contacting you regarding similar opportunities. You can consult our Privacy Policy at the following address https://iti.ca/uploads/2023/09/CONFIDENTIALITY-AND-PRIVACY-PROTECTION-POLICY.pdf

Want to transform IT with us?