Data and Reporting Analyst to execute and optimize data operations using SQL, Python, and Excel workflows - JP903

Our financial services client is seeking a Data and Reporting Analyst (3-5 years) to execute and optimize data operations using SQL, Python, and Excel workflows

Duration: Until January 29th 2027 (possibility of extension or conversion)

Location: Downtown Toronto - Hybrid (3 days mandatory in office -Tuesdays mandatory and other days flex - subject to change based on business needs)

Join a procurement analytics team supporting data operations within a major banking environment. The role focuses on maintaining routine data workflows, running automated Python scripts, and managing dashboards and data refresh requests. This position provides visibility across data governance and analytics initiatives, offering the chance to contribute to documentation, training materials, and process improvement tasks. Candidates demonstrating strong performance may be considered for a future full-time opportunity.

Must Haves

• 3-5 years in data and reporting analytics within structured environments
• Proficiency with SQL and Python (Pandas) for query execution and data processing scripts
• Experience using Git for version control and collaboration
• Strong command of Excel for data manipulation, validation, and workflow operations
• Bachelor’s degree in Technology, Computing, Data & Analytics, Business, or Engineering
• 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 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
• Well-developed communication and interpersonal skills

Nice to Have

• Experience using Microsoft 365 low-code platforms such as Power Automate, Power Apps, and SharePoint

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; perform other duties as assigned.