Solutions Architect, Data & AI

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. To innovate with one of Canada’s Best Managed Companies, where IT is developed by humans, for humans.  

Democratize Data with us 

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: Advisor, Data and AI. 

ITI is looking for a Solutions Architect, Data & AI to join its consulting services team. You will be a key contributor within a talented team and a rapidly expanding practice, with a hands-on role in designing, scoping, and delivering modern solutions for our clients. 

This role sits at the intersection of architecture, delivery, and technical leadership. You will be involved from the early stages of opportunities, collaborating with account managers, technology partners, and project managers to qualify needs, scope solutions, estimate efforts, and define the technical approach. 

The role remains highly hands-on: you will work directly with code, contribute to pipeline development, and address critical technical challenges, while guiding the team throughout execution. 

Your work will primarily involve modern platforms such as Microsoft Fabric, Synapse, Azure Databricks, and Snowflake, supporting analytical needs and artificial intelligence use cases. 

Your role at ITI

You will be responsible for:    

Architecture, scoping, and advisory 

• Design modern data architectures: Lakehouse, Data Warehouse, medallion architecture, batch or streaming; 
• Define solution patterns, ingestion strategies, data models, and transformation approaches; 
• Scope the technical aspects of projects: assumptions, inclusions, exclusions, dependencies, risks, prerequisites, and success criteria; 
• Contribute to effort and cost estimation to support proposals; 
• Collaborate with account managers, technology partners — notably Microsoft — project managers, and delivery teams; 
• Advise clients on their Data & AI roadmap and ensure a smooth transition between sales, architecture, and delivery. 

Delivery and technical leadership 

• Design, develop, and optimize data pipelines (ETL/ELT) using Fabric, Synapse, Databricks, and/or Snowflake; 
• Develop and optimize code in SQL, Python, and PySpark; 
• Implement orchestration pipelines using Azure Data Factory, Fabric Data Pipelines, or equivalent tools; 
• Guide data engineering consultants through technical execution, code reviews, and resolution of complex issues; 
• Ensure alignment between target architecture and implementation; 
• Establish best development practices: CI/CD, versioning, documentation, quality, and reusability. 

Governance and quality 

• Apply best practices in security, governance, data quality, and performance; 
• Contribute to access and security management, particularly with Azure, Entra ID, and RBAC; 
• Document solutions to ensure maintainability and knowledge sharing. 

This position is for you if…

• You enjoy both designing architecture and contributing directly to its technical implementation; 
• You are comfortable working in complex environments, where structure and clarity are needed despite ambiguity; 
• You are able to collaborate with technical teams, clients, partners, and business stakeholders; 
• You enjoy sharing knowledge, mentoring others, and contributing to a culture of technical excellence. 

What we’re looking for

Profile

• Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field; 
• Minimum of 5 years of experience in data engineering, architecture, or delivery of analytical solutions; 
• Proven experience in designing and implementing modern data platforms; 
• Strong proficiency in SQL; 
• Solid experience with Python and PySpark; 
• Knowledge of platforms such as Microsoft Fabric, Synapse, Azure Databricks and/or Snowflake, and Power BI; 
• Good understanding of Azure data services: ADLS, Data Factory, Fabric Data Pipelines, Purview, or equivalents; 
• Experience with CI/CD practices and version control tools (Azure DevOps, Git, or equivalent); 
• Demonstrated ability to provide technical leadership to a team; 
• Experience in a client-facing environment, consulting services, or technical pre-sales; 
• 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: Azure Data Engineer Associate certification or equivalent; 
• Experience with Microsoft Fabric, Synapse, Azure Databricks, and/or Snowflake; 
• Master’s degree in Computer Science, Analytics, Data Engineering, Artificial Intelligence, or a related field; 
• Experience implementing semantic models or enterprise analytical environments; 
• Experience writing proposals, estimates, SOWs, or architecture documents; 
• Experience with hybrid, multi-cloud, or multi-platform architectures; 
• Interest in contributing, depending on your exposure and interests, to the design of AI solutions in collaboration with the AI development team. 

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

Human qualities

• Natural technical leadership; 
• Strong analytical and problem-solving skills; 
• Ability to communicate clearly with both technical and non-technical audiences; 
• Strong discipline in scoping and delivery; 
• Autonomy, curiosity, and a continuous learning mindset; 
• Team spirit and willingness to help others grow. 

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?