We are seeking a Business Intelligence Specialist to lead high-priority data warehousing and migration initiatives. This role is focused on the transition from legacy systems to modern, cloud-based BI platforms. You will be responsible for gathering complex requirements, analyzing diverse datasets, and designing sophisticated reporting solutions. The ideal candidate will bridge the gap between technical ETL processes and executive-level guided analysis, ensuring that business data is transformed into actionable strategic insights.
...
Pay Rate: $347.18- $386.31/Diem
Advantages
- Strategic Influence: Shape the organization’s transition to modern cloud-based analytics and high-performance BI tools.
- Technical Depth: Work with a robust variety of technologies, including Oracle, DB2, and SQL Server, in a complex multi-platform environment.
- Executive Visibility: Develop and deliver presentations that translate complex data relationships into business recommendations for senior management.
- Professional Growth: Gain hands-on experience in business process re-engineering for large-scale enterprise applications.
Responsibilities
- Requirement Elicitation: Lead the gathering and documentation of functional requirements for Cognos and Power BI applications, specifically focusing on data migration and cloud transitions.
- Solution Design: Develop customized query applications, guided analysis, and drill-down functionality to assist in quantitative business analysis.
- Data Migration: Oversee the design and concepts of data migration across multiple platforms (e.g., Oracle to SQL Server or Cognos to Power BI).
- ETL & Scripting: Create and optimize complex SQL scripts for data profiling, cleansing, and automated extraction to ensure data integrity across large datasets.
- Reporting & Dashboards: Design and support BI reports and dashboards using Cognos 10+ and Microsoft Power BI, including the implementation of "key-trend" alerts.
- Process Engineering: Conduct business process re-engineering and process mapping (UML) to align application designs with modern business objectives.
- Troubleshooting: Investigate and resolve production issues and defects within ETL pipelines (SSIS) and BI deployments using tools like Microfocus ALM.
- Knowledge Transfer: Provide 1-on-1 sessions and documentation to internal staff to ensure the sustainability of the developed solutions.
Qualifications
- Technical Ecosystem: Deep experience in environments utilizing Oracle, Informatica, SSIS, and SQL Server for data warehousing and ETL.
- BI Tool Mastery: Demonstrated proficiency in designing enterprise-wide solutions using Cognos 10 or higher and Microsoft Power BI.
- Advanced SQL: Expertise in writing complex SQL for data profiling and query optimization across diverse database environments (Oracle 10x+, DB2, SQL Server).
- Data Migration: Proven understanding of data warehouse design and seamless integration concepts for transitioning to modern BI platforms.
- Analytical Skills: Strong ability to analyze data source systems for cleanliness issues and develop automated cleansing/load scripts.
- Modern Tech Stack: (Asset) Working knowledge of cloud infrastructure, including Azure, Databricks, and Power Query.
- Education & Methodologies: Experience across the full SDLC using both Agile and Waterfall methodologies.
Summary
If you're interested in the Business Intelligence Specialist 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 Business Intelligence Specialist to lead high-priority data warehousing and migration initiatives. This role is focused on the transition from legacy systems to modern, cloud-based BI platforms. You will be responsible for gathering complex requirements, analyzing diverse datasets, and designing sophisticated reporting solutions. The ideal candidate will bridge the gap between technical ETL processes and executive-level guided analysis, ensuring that business data is transformed into actionable strategic insights.
Pay Rate: $347.18- $386.31/Diem
Advantages
- Strategic Influence: Shape the organization’s transition to modern cloud-based analytics and high-performance BI tools.
- Technical Depth: Work with a robust variety of technologies, including Oracle, DB2, and SQL Server, in a complex multi-platform environment.
- Executive Visibility: Develop and deliver presentations that translate complex data relationships into business recommendations for senior management.
- Professional Growth: Gain hands-on experience in business process re-engineering for large-scale enterprise applications.
Responsibilities
...
- Requirement Elicitation: Lead the gathering and documentation of functional requirements for Cognos and Power BI applications, specifically focusing on data migration and cloud transitions.
- Solution Design: Develop customized query applications, guided analysis, and drill-down functionality to assist in quantitative business analysis.
- Data Migration: Oversee the design and concepts of data migration across multiple platforms (e.g., Oracle to SQL Server or Cognos to Power BI).
- ETL & Scripting: Create and optimize complex SQL scripts for data profiling, cleansing, and automated extraction to ensure data integrity across large datasets.
- Reporting & Dashboards: Design and support BI reports and dashboards using Cognos 10+ and Microsoft Power BI, including the implementation of "key-trend" alerts.
- Process Engineering: Conduct business process re-engineering and process mapping (UML) to align application designs with modern business objectives.
- Troubleshooting: Investigate and resolve production issues and defects within ETL pipelines (SSIS) and BI deployments using tools like Microfocus ALM.
- Knowledge Transfer: Provide 1-on-1 sessions and documentation to internal staff to ensure the sustainability of the developed solutions.
Qualifications
- Technical Ecosystem: Deep experience in environments utilizing Oracle, Informatica, SSIS, and SQL Server for data warehousing and ETL.
- BI Tool Mastery: Demonstrated proficiency in designing enterprise-wide solutions using Cognos 10 or higher and Microsoft Power BI.
- Advanced SQL: Expertise in writing complex SQL for data profiling and query optimization across diverse database environments (Oracle 10x+, DB2, SQL Server).
- Data Migration: Proven understanding of data warehouse design and seamless integration concepts for transitioning to modern BI platforms.
- Analytical Skills: Strong ability to analyze data source systems for cleanliness issues and develop automated cleansing/load scripts.
- Modern Tech Stack: (Asset) Working knowledge of cloud infrastructure, including Azure, Databricks, and Power Query.
- Education & Methodologies: Experience across the full SDLC using both Agile and Waterfall methodologies.
Summary
If you're interested in the Business Intelligence Specialist 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
