---

---

Location

North York, ON | Canada

---

Job description

Looking for a Data Analytical Specialist/Scientist - Senior - The role will support the Planview project management system for the Community Services I&IT Cluster (CSC) to create financial reporting dashboards and increase the Cluster’s ongoing maturity.

** looking for someone that has experience with Power BI and knows how to use SQL. Knows how to develop reports, analytics, analyze data, manipulate data, how to identify key attributes to identify visualization using Power BI. Examines data to create visualizations based on back end SQL and Power BI.

Previous experience working in Ontario Public Sector or Education experience is highly desirable .

Advantages
Pay Every Week
Office is close to College Subway Station
Contract will extend

Responsibilities
Demonstrate knowledge of information management, data management, financial and business analysis, database architecture, and data related concepts such as data preparation, data integration, data anonymization, data extract/transform/load (ETL), data warehousing, data lineage, metadata management, master data management, and data governance

Demonstrate knowledge of data skills, methods, techniques, and tools, including data mining, statistical analysis, statistical models and algorithms on machine learning deep learning, natural language processing, artificial intelligence and other related disciplines
Demonstrates efficiency in Structured Query Language (SQL) to access databases to conduct research and use applications to retrieve and manipulate data from databases located on different platforms.
Experience with multiple databases (e.g. Oracle MS-SQL) and proficiency with various modeling, analytics and data visualization software tools (PowerBI, etc.)
Experience in the use of data modelling methods and tools (e.g. PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries
Understand legislative regulations, policies and guidelines, ministry programs/services and policy development processes, data standards (e.g. GO-ITS) and privacy legislation (e.g. FIPPA) related to access and release of personal information and data

Research, Analytical and Problem-Solving Skills - 40%

Ability to analyze data in source systems to identify data quality issues (e.g., missing values, duplicate meanings, and invalid data)
Manipulate and analyze complex, high-volume data from structured, unstructured and semi-structured sources, and multi-dimensional datasets with a variety of tools
Identify and assess information, data needs and requirements to support business plans/practices and business goals/objectives
Use creative thinking and propose innovative ways as it relates to data mining, behavioural economics, statistics and statistical models, algorithms, data integration, information management, predictive analytics and analytics modeling, and data-related information technology

Qualifications
Demonstrates efficiency in Structured Query Language (SQL) to access databases to conduct research and use applications to retrieve and manipulate data from databases located on different platforms. (modelling analytics and visualization tools)
Experience with multiple databases (e.g. Oracle MS-SQL) and proficiency with various modeling, analytics and data visualization software tools (PowerBI, etc.)
Demonstrate knowledge of data skills, methods, techniques, and tools, including data mining, statistical analysis and statistical models
Ability to analyze data in source systems to identify data quality issues (e.g., missing values, duplicate meanings, and invalid data)
Use creative thinking and propose innovative ways as it relates to data mining, behavioural economics, statistics and statistical models, algorithms, data integration, information management, predictive analytics and analytics modeling, and data-related information technology

Summary
** looking for someone that has experience with Power BI and knows how to use SQL. Knows how to develop reports, analytics, analyze data, manipulate data, how to identify key attributes to identify visualization using Power BI. Examines data to create visualizations based on back end SQL and Power BI.

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 [email protected] to ensure their ability to fully participate in the interview process. show more

---

Job tags

---

---

Salary