rq08052 business intelligence specialist.

he individual will act as a bridge between business stakeholders and technical teams, providing detailed documentation and supporting end-to-end delivery of BI solutions. With a strong focus on dashboard development, data transformation, and ETL processes, this role ensures accurate, timely, and actionable insights to support business decision-making in a hybrid work setting.

Advantages
•Involvement in full-cycle BI solution development using modern technologies.
•Hybrid work environment with a structured balance between in-office and remote work.
•Exposure to a broad technical landscape including Power BI, Cognos, Oracle, .NET, and Cloud Services.
•Opportunity to lead business analysis efforts with high-impact outcomes.
•Gain cross-functional experience collaborating with QA, development, and stakeholder teams.


Responsibilities
•Conduct business analysis to gather, document, and validate I&IT requirements.
•Develop reports, dashboards, and visualizations using Power BI and Cognos.
•Support data transformation and migration using SSIS, Informatica, and SQL.
•Liaise with development and QA teams to clarify requirements and ensure solution quality.
•Optimize database performance, queries, and stored procedures in SQL Server and Oracle.
•Manage data modeling, warehousing, and ETL processes.
•Produce business documentation including business cases, process models, use cases, and testing plans.
•Facilitate knowledge transfer, maintain version control documentation, and ensure project compliance.


Qualifications
•5–7 years of experience in business analysis within I&IT environments.
•Proficient in Power BI (including DAX, Power Query, Gateway, APIs, and Security).
•Strong experience with MS SQL Server (T-SQL, SSMS, SSIS, SSRS, SSAS).
•Skilled in Cognos development (Report Studio, Framework Manager, Query Studio).
•Familiar with Oracle databases (PL/SQL, performance tuning, data modeling).
•Hands-on experience with Visual Studio, .NET Framework, and version control tools like GIT.
•Knowledge of Agile and Waterfall methodologies and the software development lifecycle.
•Experience in AODA compliance, data security, and privacy standards is desirable.


Summary
This role offers an exciting opportunity for a Business Intelligence Specialist to leverage their business analysis and technical skills to deliver high-quality BI solutions. By bridging the gap between business and IT, this position supports informed decision-making and process optimization across the organization.

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.