We are seeking a Business Intelligence Specialist (Junior) to implement and support data-driven solutions in a hybrid environment (3 days onsite, 2 days remote). The role focuses on designing and maintaining BI reports, dashboards, and ETL processes using tools like Cognos, Power BI, and various data platforms.
Advantages
...
•Hybrid Work Model: Enjoy both on-site collaboration and remote flexibility.
•Impactful Work: Help shape critical business decisions by designing robust BI reports, dashboards, and data integrations.
•Cutting-Edge Tools: Gain hands-on experience with Cognos, Power BI, ETL tools like SSIS and Informatica, and various database environments.
•Professional Growth: Expand your skill set in data analysis, business process re-engineering, and BI migration projects.
•Collaborative Environment: Work closely with cross-functional teams to gather requirements, troubleshoot issues, and deliver high-quality data solutions.
Responsibilities
•Create and maintain Cognos and Power BI reports, dashboards, and queries.
•Enhance existing data sets and models for better reporting and drill-down functionality.
•Develop guided analysis, routine scheduling, and notifications for key trends or alerts.
•Migrate data into Power BI-compatible formats using ETL tools (e.g., SSIS, Informatica).
•Identify and address data cleanliness issues, develop extraction, cleansing, and load scripts.
•Collaborate on data warehouse design, ensuring seamless integration with source systems.
•Gather and clarify requirements from business and IT stakeholders.
•Prepare technical documents, business cases, and process flows.
•Provide knowledge transfer sessions and maintain version-controlled documentation.
•Investigate and resolve BI-related production issues, deploying fixes as needed.
•Optimize data models, queries, and performance across different BI environments.
•Offer ongoing support for both scheduled and ad-hoc research/reporting needs.
•Contribute to agile or waterfall SDLC phases, including design, testing, and release management.
•Present findings and recommendations to various audiences, ensuring stakeholder alignment.
Qualifications
•Proven experience with Cognos 10 or higher and Microsoft Power BI for BI solutions.
•Familiarity with Oracle, SQL Server, and ETL processes (SSIS, Informatica) for data migration.
•Working knowledge of data warehousing principles, data mapping, and business process re-engineering.
•Strong MS Excel skills (Power Query, Pivot Tables) for advanced data analysis and reporting.
•Excellent communication and analytical skills to translate business requirements into technical solutions.
•Understanding of Oracle SQL and PL/SQL.
•Experience with BI tool migrations (e.g., moving from Cognos or Qlik to Power BI).
•Familiarity with agile or waterfall methodologies in project delivery.
Summary
Join our team as a Business Intelligence Specialist and contribute to transformative data-driven solutions. You’ll collaborate on end-to-end BI projects, tackle data challenges, and empower business stakeholders through insightful reports and dashboards. Apply now to expand your expertise in an engaging, forward-thinking 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
We are seeking a Business Intelligence Specialist (Junior) to implement and support data-driven solutions in a hybrid environment (3 days onsite, 2 days remote). The role focuses on designing and maintaining BI reports, dashboards, and ETL processes using tools like Cognos, Power BI, and various data platforms.
Advantages
•Hybrid Work Model: Enjoy both on-site collaboration and remote flexibility.
•Impactful Work: Help shape critical business decisions by designing robust BI reports, dashboards, and data integrations.
•Cutting-Edge Tools: Gain hands-on experience with Cognos, Power BI, ETL tools like SSIS and Informatica, and various database environments.
•Professional Growth: Expand your skill set in data analysis, business process re-engineering, and BI migration projects.
•Collaborative Environment: Work closely with cross-functional teams to gather requirements, troubleshoot issues, and deliver high-quality data solutions.
Responsibilities
•Create and maintain Cognos and Power BI reports, dashboards, and queries.
•Enhance existing data sets and models for better reporting and drill-down functionality.
...
•Develop guided analysis, routine scheduling, and notifications for key trends or alerts.
•Migrate data into Power BI-compatible formats using ETL tools (e.g., SSIS, Informatica).
•Identify and address data cleanliness issues, develop extraction, cleansing, and load scripts.
•Collaborate on data warehouse design, ensuring seamless integration with source systems.
•Gather and clarify requirements from business and IT stakeholders.
•Prepare technical documents, business cases, and process flows.
•Provide knowledge transfer sessions and maintain version-controlled documentation.
•Investigate and resolve BI-related production issues, deploying fixes as needed.
•Optimize data models, queries, and performance across different BI environments.
•Offer ongoing support for both scheduled and ad-hoc research/reporting needs.
•Contribute to agile or waterfall SDLC phases, including design, testing, and release management.
•Present findings and recommendations to various audiences, ensuring stakeholder alignment.
Qualifications
•Proven experience with Cognos 10 or higher and Microsoft Power BI for BI solutions.
•Familiarity with Oracle, SQL Server, and ETL processes (SSIS, Informatica) for data migration.
•Working knowledge of data warehousing principles, data mapping, and business process re-engineering.
•Strong MS Excel skills (Power Query, Pivot Tables) for advanced data analysis and reporting.
•Excellent communication and analytical skills to translate business requirements into technical solutions.
•Understanding of Oracle SQL and PL/SQL.
•Experience with BI tool migrations (e.g., moving from Cognos or Qlik to Power BI).
•Familiarity with agile or waterfall methodologies in project delivery.
Summary
Join our team as a Business Intelligence Specialist and contribute to transformative data-driven solutions. You’ll collaborate on end-to-end BI projects, tackle data challenges, and empower business stakeholders through insightful reports and dashboards. Apply now to expand your expertise in an engaging, forward-thinking 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
