The Data Analytical Specialist/Scientist plays a key role in analyzing complex datasets to deliver actionable insights that support policy and funding decisions in education and child care. This position requires strong expertise in Microsoft Excel, SQL databases, and Power BI for data validation, cleaning, transformation, and visualization. The role involves leading data assessments, identifying quality issues, conducting predictive and historical analysis, and developing reports and dashboards. The specialist will work in a hybrid setup and collaborate closely with clients and stakeholders to develop business intelligence solutions that align with strategic goals.
...
Advantages
•Opportunity to work on meaningful projects that support public planning and educational infrastructure
•Hybrid work model providing flexibility with a combination of remote and onsite work
•Exposure to cutting-edge analytics tools like Power BI, R, and Azure data environments
•Gain experience with a wide range of structured and unstructured data sets
•Work closely with cross-functional teams, including ETL developers, architects, and business stakeholders
Responsibilities
•Lead the design, development, and delivery of analytics and business intelligence solutions
•Perform data extraction, transformation, and load (ETL) for large relational datasets
•Conduct statistical and predictive analysis using tools like R and integrate results into Power BI
•Develop interactive dashboards and reports using Power BI and Excel
•Analyze and clean datasets from various domains, including land use and childcare
•Build and apply dimensional models and validate data standards
•Identify gaps in data quality and suggest improvements
•Document data standardization, requirements, and analytical processes
•Communicate insights clearly to both technical and non-technical stakeholders
Qualifications
•7+ years of experience with Microsoft Excel, including data validation
•Proficiency in SQL and experience with SQL-based databases
•Experience in data cleaning, transformation, and integration
•Strong background in Power BI for visualization and interactive reporting
•Hands-on experience with R, including statistical modeling and Power BI integration
•Familiarity with dimensional data modeling and cube development
•Demonstrated ability to document data requirements and analytics workflows
•Solid consulting, communication, and problem-solving skills
Summary
This Data Analytical Specialist/Scientist position offers a dynamic opportunity to drive data-informed decision-making through advanced analytics and visualization tools. The role is suited for professionals with strong technical skills in Excel, SQL, Power BI, and statistical modeling who are passionate about transforming data into actionable insights.
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
The Data Analytical Specialist/Scientist plays a key role in analyzing complex datasets to deliver actionable insights that support policy and funding decisions in education and child care. This position requires strong expertise in Microsoft Excel, SQL databases, and Power BI for data validation, cleaning, transformation, and visualization. The role involves leading data assessments, identifying quality issues, conducting predictive and historical analysis, and developing reports and dashboards. The specialist will work in a hybrid setup and collaborate closely with clients and stakeholders to develop business intelligence solutions that align with strategic goals.
Advantages
•Opportunity to work on meaningful projects that support public planning and educational infrastructure
•Hybrid work model providing flexibility with a combination of remote and onsite work
•Exposure to cutting-edge analytics tools like Power BI, R, and Azure data environments
•Gain experience with a wide range of structured and unstructured data sets
•Work closely with cross-functional teams, including ETL developers, architects, and business stakeholders
Responsibilities
...
•Lead the design, development, and delivery of analytics and business intelligence solutions
•Perform data extraction, transformation, and load (ETL) for large relational datasets
•Conduct statistical and predictive analysis using tools like R and integrate results into Power BI
•Develop interactive dashboards and reports using Power BI and Excel
•Analyze and clean datasets from various domains, including land use and childcare
•Build and apply dimensional models and validate data standards
•Identify gaps in data quality and suggest improvements
•Document data standardization, requirements, and analytical processes
•Communicate insights clearly to both technical and non-technical stakeholders
Qualifications
•7+ years of experience with Microsoft Excel, including data validation
•Proficiency in SQL and experience with SQL-based databases
•Experience in data cleaning, transformation, and integration
•Strong background in Power BI for visualization and interactive reporting
•Hands-on experience with R, including statistical modeling and Power BI integration
•Familiarity with dimensional data modeling and cube development
•Demonstrated ability to document data requirements and analytics workflows
•Solid consulting, communication, and problem-solving skills
Summary
This Data Analytical Specialist/Scientist position offers a dynamic opportunity to drive data-informed decision-making through advanced analytics and visualization tools. The role is suited for professionals with strong technical skills in Excel, SQL, Power BI, and statistical modeling who are passionate about transforming data into actionable insights.
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
