We are seeking a senior-level Solutions Designer to lead the design and development of advanced Business Intelligence solutions. This role is instrumental in translating complex business needs into high-performing technical frameworks using both Microsoft Power BI and Cognos, ensuring alignment with enterprise standards and industry best practices.
...
Pay Rate: $641.96-$676.04/Diem
Advantages
- Shape the strategy for technology upgrades and cloud migration initiatives.
- Influence everything from initial requirements gathering to automated deployment and production support.
- Deliver high-visibility BI solutions that improve organizational structure and efficiency.
- Work within a collaborative framework that supports both onsite expertise and remote productivity.
Responsibilities
- Lead the design, testing, and installation of new BI systems, ensuring seamless integration between existing platforms and new cloud/on-premise services.
- Act as the primary subject matter expert and technical advisor for all aspects of BI deliverables, providing expert assistance to various technology teams.
- Develop and manage end-to-end solutions using Power BI, Cognos, SSIS, and SQL-based reporting tools.
- Design and maintain semantic models, dimensional models, and data warehouse architectures optimized for advanced analytics.
- Oversee ETL processes (SSIS, Informatica) and automate release pipelines (CI/CD) using Azure DevOps or GitHub Actions to ensure smooth production deployments.
- Work with stakeholders to define technical roadmaps, determine project scope, and provide objective advice on I&IT requirements.
- Manage deployment activities in coordination with Infrastructure and Operations teams, including the creation of comprehensive "Release Books."
- Ensure rigorous documentation and formal knowledge transfer to designated internal staff through walkthroughs and version-controlled repositories.
Qualifications
- 10+ years as a Solution Designer/Developer with a heavy focus on the Microsoft BI Suite (Power BI, MS SQL, SSIS).
- Extensive experience with both Power BI Service (Cloud) and Power BI Server (On-Prem), including administration and row-level security.
- 5+ years of hands-on experience in ETL development, data migration, and daily job handling.
- Proficient in MS SQL Server, Oracle, Visual Studio, .NET Framework, and version control tools (GIT).
- Strong understanding of SDLC, Agile, and Waterfall methodologies, as well as change management principles.
- Proven ability in stakeholder engagement, negotiation, and consensus-building to resolve complex business pain points.
Summary
If you're interested in the Solutions Designer role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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.
This posting is for existing and upcoming vacancies.
show more
We are seeking a senior-level Solutions Designer to lead the design and development of advanced Business Intelligence solutions. This role is instrumental in translating complex business needs into high-performing technical frameworks using both Microsoft Power BI and Cognos, ensuring alignment with enterprise standards and industry best practices.
Pay Rate: $641.96-$676.04/Diem
Advantages
- Shape the strategy for technology upgrades and cloud migration initiatives.
- Influence everything from initial requirements gathering to automated deployment and production support.
- Deliver high-visibility BI solutions that improve organizational structure and efficiency.
- Work within a collaborative framework that supports both onsite expertise and remote productivity.
Responsibilities
- Lead the design, testing, and installation of new BI systems, ensuring seamless integration between existing platforms and new cloud/on-premise services.
- Act as the primary subject matter expert and technical advisor for all aspects of BI deliverables, providing expert assistance to various technology teams.
...
- Develop and manage end-to-end solutions using Power BI, Cognos, SSIS, and SQL-based reporting tools.
- Design and maintain semantic models, dimensional models, and data warehouse architectures optimized for advanced analytics.
- Oversee ETL processes (SSIS, Informatica) and automate release pipelines (CI/CD) using Azure DevOps or GitHub Actions to ensure smooth production deployments.
- Work with stakeholders to define technical roadmaps, determine project scope, and provide objective advice on I&IT requirements.
- Manage deployment activities in coordination with Infrastructure and Operations teams, including the creation of comprehensive "Release Books."
- Ensure rigorous documentation and formal knowledge transfer to designated internal staff through walkthroughs and version-controlled repositories.
Qualifications
- 10+ years as a Solution Designer/Developer with a heavy focus on the Microsoft BI Suite (Power BI, MS SQL, SSIS).
- Extensive experience with both Power BI Service (Cloud) and Power BI Server (On-Prem), including administration and row-level security.
- 5+ years of hands-on experience in ETL development, data migration, and daily job handling.
- Proficient in MS SQL Server, Oracle, Visual Studio, .NET Framework, and version control tools (GIT).
- Strong understanding of SDLC, Agile, and Waterfall methodologies, as well as change management principles.
- Proven ability in stakeholder engagement, negotiation, and consensus-building to resolve complex business pain points.
Summary
If you're interested in the Solutions Designer role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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.
This posting is for existing and upcoming vacancies.
show more
