The Specialized IT Consultant role focuses on developing and supporting business intelligence (BI) and data solutions using Power BI, MS SQL Server, SSIS, and Cognos. The consultant will play a key role in implementing robust ETL processes, designing interactive dashboards, and maintaining complex data systems. Working with multiple technologies such as Oracle, Visual Studio, .NET, and Azure Data Factory, the consultant ensures scalable, secure, and high-performing solutions. This position involves cross-functional collaboration, technical leadership, and hands-on development in both on-premises and cloud environments.
...
Advantages
•Hands-on work with a diverse technology stack including Power BI, Cognos, Oracle, and Azure.
•Opportunity to design end-to-end BI solutions including ETL, modeling, and reporting.
•Balanced hybrid work model combining remote flexibility with in-office collaboration.
•Collaboration with development, QA, and business teams across multiple phases of project delivery.
•Engagement in strategic architectural planning and performance optimization.
Responsibilities
•Design, develop, and maintain ETL processes using SSIS and Azure Data Factory.
•Build interactive reports and dashboards using Power BI and Cognos.
•Develop database solutions and optimize SQL queries, stored procedures, and performance.
•Lead the design and implementation of data models and data warehousing strategies.
•Translate business requirements into technical specifications and system designs.
•Manage version control using GIT and maintain documentation in SharePoint and DevOps.
•Support testing, release management, and post-deployment troubleshooting.
•Guide solution architecture using Microsoft Azure services and ensure compliance with security standards.
Qualifications
•5+ years of experience as an I&IT Consultant with expertise in Power BI, MS SQL Server, SSIS, Informatica ETL, and Cognos.
•Proficient in T-SQL, PL/SQL, Power Query, DAX, and data modeling with star and snowflake schemas.
•Hands-on experience with tools like Visual Studio, Azure DevOps, Erwin Data Modeler, and Power Designer.
•Familiarity with .NET Framework, Java, Oracle, and cloud services including Azure Data Factory, SSRS, and SSAS.
•Demonstrated ability to manage data migration, transformation, and integration from various sources.
•Strong understanding of data governance, compliance, and performance optimization.
Summary
This Specialized IT Consultant role offers an exciting opportunity to lead and deliver end-to-end business intelligence solutions across complex technical landscapes. With a strong focus on data architecture, ETL development, and dashboard reporting, the position is ideal for professionals seeking impactful work in a collaborative and technically diverse environment.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
The Specialized IT Consultant role focuses on developing and supporting business intelligence (BI) and data solutions using Power BI, MS SQL Server, SSIS, and Cognos. The consultant will play a key role in implementing robust ETL processes, designing interactive dashboards, and maintaining complex data systems. Working with multiple technologies such as Oracle, Visual Studio, .NET, and Azure Data Factory, the consultant ensures scalable, secure, and high-performing solutions. This position involves cross-functional collaboration, technical leadership, and hands-on development in both on-premises and cloud environments.
Advantages
•Hands-on work with a diverse technology stack including Power BI, Cognos, Oracle, and Azure.
•Opportunity to design end-to-end BI solutions including ETL, modeling, and reporting.
•Balanced hybrid work model combining remote flexibility with in-office collaboration.
•Collaboration with development, QA, and business teams across multiple phases of project delivery.
•Engagement in strategic architectural planning and performance optimization.
Responsibilities
•Design, develop, and maintain ETL processes using SSIS and Azure Data Factory.
...
•Build interactive reports and dashboards using Power BI and Cognos.
•Develop database solutions and optimize SQL queries, stored procedures, and performance.
•Lead the design and implementation of data models and data warehousing strategies.
•Translate business requirements into technical specifications and system designs.
•Manage version control using GIT and maintain documentation in SharePoint and DevOps.
•Support testing, release management, and post-deployment troubleshooting.
•Guide solution architecture using Microsoft Azure services and ensure compliance with security standards.
Qualifications
•5+ years of experience as an I&IT Consultant with expertise in Power BI, MS SQL Server, SSIS, Informatica ETL, and Cognos.
•Proficient in T-SQL, PL/SQL, Power Query, DAX, and data modeling with star and snowflake schemas.
•Hands-on experience with tools like Visual Studio, Azure DevOps, Erwin Data Modeler, and Power Designer.
•Familiarity with .NET Framework, Java, Oracle, and cloud services including Azure Data Factory, SSRS, and SSAS.
•Demonstrated ability to manage data migration, transformation, and integration from various sources.
•Strong understanding of data governance, compliance, and performance optimization.
Summary
This Specialized IT Consultant role offers an exciting opportunity to lead and deliver end-to-end business intelligence solutions across complex technical landscapes. With a strong focus on data architecture, ETL development, and dashboard reporting, the position is ideal for professionals seeking impactful work in a collaborative and technically diverse environment.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
