Title: Data and Reporting Analyst - Intermediate
Location: Toronoto, ON  Hybrid
Duration: 7 Months

Summary

We are seeking a detail-oriented team member to join our Procurement Analytics team, responsible for supporting day-to-day data operations and request management. This role will operate routine data workflows—including Excel-based tasks and running automated Python scripts to curate and refresh datasets, monitor and respond to a shared team inbox, action incoming requests such as dashboard setup or data refreshes, and perform other duties as assigned.

The successful candidate will execute tasks within defined schedules, troubleshoot data issues, and support broader team initiatives such as documentation, process manual creation, and ad-hoc analysis. Proven experience with SQL, Python, Git (version control), and the ability to perform guided queries is essential, along with a willingness to learn and support various facets of our data analytics function.

This role will also include the opportunity to support and collaborate with our Data Governance team, engaging with a broad range of stakeholders to promote and implement effective data management practices. Additional responsibilities include supporting meeting minutes and assisting in the creation of presentation slides and training materials to aid communication and knowledge sharing across the team.

Education & Experience

• 3–5 years of experience in Data Analytics, Reporting Analytics, or related fields
• Minimum Bachelor's degree required
• Specialization in Technology, Computing, Data & Analytics, Business, or Engineering is preferred

Required Skills

• Well-developed communication and interpersonal skills
• Strong working knowledge of SQL and Python (Pandas), with hands-on experience executing, modifying, and maintaining existing queries and data processing scripts
• Strong working knowledge of SQL and Python, including the ability to execute and modify existing queries/scripts
• Experience using Git (version control) for managing code changes and collaboration
• Proficiency in Excel for data manipulation, validation, and operational workflows
• High attention to detail when working with large, complex datasets
• Ability to troubleshoot data issues and identify root causes within defined processes
• Strong organizational skills with the ability to manage multiple incoming requests and priorities
• Effective written and verbal communication skills; able to engage with both technical and business stakeholders
• Willingness to learn and contribute across data analytics and data governance functions
• Ability to follow structured processes while identifying opportunities for incremental improvements

Key Responsibilities

• Execute recurring data workflows, including running Python scripts and maintaining Excel-based processes to refresh and curate datasets
• Monitor and manage the team's shared inbox, triaging and responding to incoming requests in a timely manner
• Fulfill operational data requests, such as dashboard setup, data refreshes, and ad-hoc data pulls
• Perform data validation and quality checks, troubleshooting issues and escalating where appropriate
• Support the maintenance and improvement of process documentation and user guides
• Assist in the creation of process manuals and Standard Operating Procedures (SOPs)
• Collaborate with the Data Governance team to support data management practices
• Track and manage assigned tasks to ensure completion within defined timelines and schedules
• Contribute to continuous improvement initiatives within the Procurement Analytics function
• Provide general operational support as needed and perform other duties as assigned

Nice-to-Have Skills

• Hands-on experience leveraging Microsoft 365 low-code platforms, including:
  • Power Automate
  • Power Apps
  • SharePoint Forms
  • SharePoint Lists
• Experience designing and implementing event-driven workflows, approvals, and process tracking solutions

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 43.46/hr.