Are you a BI Solutions Designer with hands-on expertise in Power BI, SSIS, and Cognos? Our client seeks a Solutions Designer to lead the design, development, and deployment of scalable business intelligence and data integration solutions. This role will support the modernization of data services, providing robust reporting and analytics capabilities across multiple platforms and business units.
...
This position is ideal for someone with strong experience in ETL development, reporting solutions, and data transformation who thrives in a hybrid work environment and values collaboration with business stakeholders.
Advantages
- Long-term contract with hybrid flexibility (3 days onsite / 2 days remote)
- Lead BI development across Power BI, Cognos, SSIS, and Oracle environments
- Contribute to large-scale public sector transformation projects
- Collaborate with cross-functional teams, including architects, developers, QA, and stakeholders
- High visibility, high-impact project with knowledge transfer and documentation embedded in the workflow
Responsibilities
- Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization’s I&IT systems.
- Provides subject matter expertise in their field and highly expert technical assistance.
- Acts as the technical advisor/expert on all aspects of a specific deliverable.
- Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations.
- Develops processes and procedures for implementing deliverables.
- Prepares work plan, effort estimates, reports and presentations including options and recommendations, etc.
- Works with clients to determine the technical scope of the project and to determine requirements.
- Defines software, hardware and network requirements.
- Analyze I&IT requirements, giving independent and objective advice on the use of I&IT.
- Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems.
- Ensure seamless integration of new and existing systems, applications, and platforms.
- Evaluate and recommend technology stacks, platforms, and tools to support business goals.
- Design systems with a focus on security, compliance, and data privacy standards.
- Work closely with stakeholders such as business units, development teams, and IT infrastructure teams to ensure alignment with project goals.
- Ensure solutions are scalable, reliable, and can be optimized for future growth.
- Provide technical support and participate in the development, package creation, code merge, testing and release activities.
- Primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
- Develop and manage solutions using Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
- Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
Qualifications
Must Haves:
- Strong experience in developing reports and dashboards in Power BI.
- Solid experience in designing, developing, and deploying SSIS packages for ETL processes.
- Solid knowledge of MS SQL Server, including T-SQL, stored procedures, and query optimization.
- Familiar with data extraction, transformation, and loading (ETL) from various sources to target systems.
- Strong product experience such as Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
The ideal candidate should possess 10+ years of experience as a Solution Designer & Developer, with a focus on the following project environments:
- 5-7 years: Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation.
- 2-4 years: Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control.
Desirable Skills:
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions.
- Experience with a wide range of methods, tools and techniques for business analysis, such as business functional modelling, business event modelling, and business process mapping.
- Experience in structured, object-oriented and agile methodologies for user requirements.
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
- Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs.
- Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope.
- Awareness of emerging I&IT trends and technologies.
- Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
Summary
Our client is seeking a BI and Solutions Designer who can own the end-to-end design and development of data integration, ETL, and reporting solutions. If you have deep hands-on experience with Power BI, SSIS, Cognos, and SQL Server, and you’re passionate about scalable, secure, and data-driven platforms, this opportunity is for you.
Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So, even if this role isn’t for you, please update your profile so we can find you!
We look forward to supporting you in your job search! Good luck!
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
Are you a BI Solutions Designer with hands-on expertise in Power BI, SSIS, and Cognos? Our client seeks a Solutions Designer to lead the design, development, and deployment of scalable business intelligence and data integration solutions. This role will support the modernization of data services, providing robust reporting and analytics capabilities across multiple platforms and business units.
This position is ideal for someone with strong experience in ETL development, reporting solutions, and data transformation who thrives in a hybrid work environment and values collaboration with business stakeholders.
Advantages
- Long-term contract with hybrid flexibility (3 days onsite / 2 days remote)
- Lead BI development across Power BI, Cognos, SSIS, and Oracle environments
- Contribute to large-scale public sector transformation projects
- Collaborate with cross-functional teams, including architects, developers, QA, and stakeholders
- High visibility, high-impact project with knowledge transfer and documentation embedded in the workflow
Responsibilities
...
- Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization’s I&IT systems.
- Provides subject matter expertise in their field and highly expert technical assistance.
- Acts as the technical advisor/expert on all aspects of a specific deliverable.
- Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations.
- Develops processes and procedures for implementing deliverables.
- Prepares work plan, effort estimates, reports and presentations including options and recommendations, etc.
- Works with clients to determine the technical scope of the project and to determine requirements.
- Defines software, hardware and network requirements.
- Analyze I&IT requirements, giving independent and objective advice on the use of I&IT.
- Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems.
- Ensure seamless integration of new and existing systems, applications, and platforms.
- Evaluate and recommend technology stacks, platforms, and tools to support business goals.
- Design systems with a focus on security, compliance, and data privacy standards.
- Work closely with stakeholders such as business units, development teams, and IT infrastructure teams to ensure alignment with project goals.
- Ensure solutions are scalable, reliable, and can be optimized for future growth.
- Provide technical support and participate in the development, package creation, code merge, testing and release activities.
- Primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
- Develop and manage solutions using Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
- Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
Qualifications
Must Haves:
- Strong experience in developing reports and dashboards in Power BI.
- Solid experience in designing, developing, and deploying SSIS packages for ETL processes.
- Solid knowledge of MS SQL Server, including T-SQL, stored procedures, and query optimization.
- Familiar with data extraction, transformation, and loading (ETL) from various sources to target systems.
- Strong product experience such as Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
The ideal candidate should possess 10+ years of experience as a Solution Designer & Developer, with a focus on the following project environments:
- 5-7 years: Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation.
- 2-4 years: Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control.
Desirable Skills:
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions.
- Experience with a wide range of methods, tools and techniques for business analysis, such as business functional modelling, business event modelling, and business process mapping.
- Experience in structured, object-oriented and agile methodologies for user requirements.
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
- Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs.
- Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope.
- Awareness of emerging I&IT trends and technologies.
- Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
Summary
Our client is seeking a BI and Solutions Designer who can own the end-to-end design and development of data integration, ETL, and reporting solutions. If you have deep hands-on experience with Power BI, SSIS, Cognos, and SQL Server, and you’re passionate about scalable, secure, and data-driven platforms, this opportunity is for you.
Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So, even if this role isn’t for you, please update your profile so we can find you!
We look forward to supporting you in your job search! Good luck!
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
