Consultant, Data & AI

ITI is over 30 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 

At ITI, we help organizations unlock the full value of their data. We’re looking for a Consultant to join our Data & AI Consulting team and play a key role in designing and implementing modern, high-performance data solutions for our clients. 

In this role, you’ll work directly with clients to understand their business needs and technical environment, and architect the right data solutions to support their goals. You’ll collaborate with our internal team and technology partners to design, build, and evolve the data services and offerings that power our customers’ analytics and AI capabilities. 

Your work will focus on building secure, scalable, and reliable cloud-based data platforms—primarily on Microsoft Synapse, Fabric, and Azure Databricks—that not only drive insights today but also enable the next generation of AI workloads. 

We offer a flexible hybrid work model, competitive benefits, and a culture built on innovation, collaboration, and well-being, where your expertise helps shape the future of data and AI.

Your role at ITI

You will be responsible for:

• Work with business stakeholders to understand reporting needs and translate them into clean, well-structured datasets; 
• Prepare, transform, and model data using SQL and data transformation tools (e.g., Fabric Dataflows / Lakehouse SQL / dbt / Synapse pipelines); 
• Develop and maintain semantic models to support self-service analytics in Power BI; 
• Build intuitive and visually compelling dashboards and reports in Power BI, ensuring they reflect business definitions and KPIs accurately; 
• Apply data quality checks and follow best practices for documentation, versioning, and maintainability of data assets; 
• Collaborate with data engineers, business analysts, and data scientists to ensure datasets are well-governed, understood, and ready for use across teams; 
• Support end-users by enabling adoption of dashboards and self-service capabilities (training, office hours, data literacy support); 
• Contribute to continuous improvement, identifying opportunities to streamline data processes or enhance reporting assets; 
• Create clear and comprehensive documentation (data dictionaries, model diagrams, business definitions, report guides) to support maintainability and knowledge sharing; 
• Stay current with Microsoft Fabric, Power BI, and industry best practices to support ongoing improvements to the analytics environment. 

This position is for you if…

• You thrive in a dynamic, fast-paced environment where innovation and collaboration are key; 
• You are passionate about staying ahead of the curve in data engineering and cloud technologies; 
• You enjoy solving complex problems and turning data into actionable insights; 
• You value autonomy, but also love working closely with talented teammates; 
• You communicate clearly and effectively with both technical and non-technical stakeholders; 
• You are excited to mentor others and contribute to a culture of growth and excellence. 

What we’re looking for

Profile

• 1–4 years of experience in data analytics, business intelligence, or data engineering; 
• Strong proficiency in SQL for data exploration, transformation, and modeling; 
• Hands-on experience building Power BI dashboards and semantic models (DAX knowledge is an asset); 
• Familiarity with Microsoft Fabric and/or Synapse (e.g., Lakehouse, Dataflows, Pipelines, Notebooks); 
• Basic understanding of data modeling concepts (e.g., star schema, data warehouse vs. data lake); 
• Experience working with data transformation tools (e.g., Dataflows, dbt, Spark SQL, or SQL-based ELT platforms); 
• Ability to translate business questions into clear reporting requirements and KPI definitions; 
• Strong documentation and communication skills, including the ability to present insights to business stakeholders; 
• A Microsoft Fabric Certification (Data Engineer or Analytics Engineer) is an asset; 
• Openness to learning modern data engineering practices and cloud services (Azure, Databricks, CI/CD, governance frameworks); 
• Bachelor’s degree in a related field (Data Analytics, Computer Science, Mathematics, Business Intelligence) or equivalent practical experience. 

Human qualities

• Analytical Skills: Ability to analyze system performance, troubleshoot technical issues, and propose improvements; 
• Teamwork and Collaboration: Strong ability to work collaboratively with multidisciplinary teams, including architects and data experts;
• Communication: Excellent ability to simplify technical concepts and communicate effectively with various stakeholders; 
• Autonomy and Curiosity: Capacity to learn new technologies and stay up to date in a constantly evolving field. 

What we offer

Our honour code is to never take you for a number. We support our teams to take on challenges with agility. Each and every one of us has the latitude to move forward and 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 that’s 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, ethnic and visible minorities, aboriginals and people with disabilities to submit their application. We are working to become an inclusive employer for all, and to see uniqueness as a source of innovation.  

Our simple recruitment process

Simplifying things is in our DNA.

If your application is selected, you will be invited to an initial phone or 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 manager responsible for the position 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?