Data and Reporting Analyst:
On behalf of our Banking client, Procom is searching for a Data and Reporting Analyst for a 6-month role. This position is a hybrid position with 3 days onsite at our client’s Toronto office.
Data and Reporting Analyst - Job Description:
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 involves executing routine data workflows, including Excel tasks and automated Python scripts, to curate and refresh datasets. The role also contributes to data governance efforts and supports documentation, process improvements, and ad-hoc analysis to enhance data management and reporting capabilities.
Data and Reporting Analyst - 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
Data and Reporting Analyst - Mandatory Skills:
- Strong working knowledge of SQL and Python (Pandas), with hands-on experience executing, modifying, and maintaining queries and data processing scripts
- Experience using Git (version control) for managing code changes and collaboration
- Proficiency in Excel for data manipulation, validation, and operational workflows
- Ability to troubleshoot data issues and identify root causes within defined processes
- Experience managing multiple incoming requests and priorities effectively
- Effective written and verbal communication skills for engaging with technical and business stakeholders
- Ability to follow structured processes while identifying opportunities for incremental improvements
Data and Reporting Analyst – Nice-to-Have Skills:
- Hands-on experience leveraging Microsoft 365 low-code platforms (Power Automate, Power Apps, SharePoint forms and lists) to design and implement event-driven workflows, approvals, and process tracking
Data and Reporting Analyst – Assignment Length:
This is a 6-month contract position.
Data and Reporting Analyst - Start Date:
ASAP
Data and Reporting Analyst - Assignment Location:
Toronto, Ontario, Canada. This is a hybrid role requiring a minimum of three days per week onsite.
