RQ07145 Data Analytical SpecialistScientist Senior

This is a contract position for a Data Analytical Specialist / Scientist - Senior for our public sector client.

Work location : Downtown Toronto

Duration : Twelve Months

7.25 hours / day

This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages

Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities

The Common Cluster Solutions Branch focuses on services that support both ministries and all branches within the cluster.

CCS also provides business intelligence, data analysis and other KPI reporting on important areas of business operations to our partners and the cluster.

These services include Business Intelligence (BI), which consists of performance reporting, analytics and consulting services, and includes offering self-service tools to enable and empower our business partners to make informed decisions for their day-to-day business operations.

The resource would be engaged on a number of discrete projects that have been approved by ministry program areas as key priorities, including :

1) SOLGEN Private Security & Investigation Services Branch (PSISB) to develop Compliance Enforcement reporting Phase 1

2) SOLGEN Private Security & Investigation Services Branch (PSISB) to develop Compliance Enforcement reporting Phase 2

3) SOLGEN Animal Welfare Services (AWS) critical operational reporting

• 4) Modernized Use of Force reporting;
• 5) Inventory of Mental Health Programs reporting;
• 6) eRoster reporting;

7) CSOI Investigations Reporting

In addition, other Microsoft Power BI work is ongoing within the Branch and resources may be required to assist in other Power BI development work involved in the unit.

Deliverables :

• Design prototypes of business intelligence solutions (dashboards and reports)
• Undertake special assignments / sub-projects as assigned.
• Assess, evaluate, and document stakeholder interests.
• Conduct business requirement sessions and document options and outcomes.
• Prepare and document data analysis findings and data dictionaries.
• Participate in problem analysis and identify opportunities where business intelligence and advanced analytics can be used to support project and / or program objectives.
• Serve as a data analytics subject matter expert on inter-disciplinary project teams and / or as an ad-hoc advisor to deliver data analytics expertise and advice.
• Conduct periodic reviews of developed analytical solutions to identify opportunities for enhancements or evolution.
• Research, prepare and document issues related to data collection and reporting requirements.
• Plan, prepare and deliver demo and training sessions on new Business Intelligence dashboards and reports to all levels of user community.
• Ensure alignment and adherence to IT processes and standards.
• Participate in development and UAT testing and document results.
• Participate in Knowledge transfer.

Skills and Knowledge :

• Proven experience as a Data Analyst in building Business Intelligence reports and dashboards
• Proven experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
• Demonstrated experience with Power BI, SQL Query and / or other data query tools
• Demonstrated knowledge and experience of Microsoft Power BI service
• Proven, demonstratable experience in data visualization; working with BI implementation methodologies
• Knowledge of data analysis, data management
• Proven ability to partner with internal / external stakeholders and liaise with technical experts and non-technical colleagues
• Excellent verbal and written communication skills, interpersonal and facilitation skills
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar / spelling and terminology
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment

Qualifications

• Ability to examine, understand and present requirements, data and information in a cohesive manner using various tools including TOAD, SQL Server Management Studio, Visio, Powerpoint, Miro, Mermaid.js, Excel
• Ability to Lead and advise on data compatibility and recommend solutions
• Superior knowledge of the Microsoft 365 Office suite and Microsoft Azure ecosystem
• Experience in database transition to work between platforms and manage multiple stages of projects from initiation to testing to delivery
• Ability to liaise and provide reporting information, assessment and data interpretation to others

Summary

If interested and qualified for this role, please apply today for immediate consideration!

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.