Intermediate Operations Analyst with strong Excel experience to support the global procurement team with one of our major banking clients- 37051

Intermediate Operations Analyst with strong Excel experience to support the global procurement team with one of our major banking clients- 37051

Location Address: Toronto/Hybrid - 2-3 times per week (Wednesdays)

Contract Duration: 1 year

Schedule Hours: 8:30 am-5 pm Monday-Friday (No overtime), 37.5 Hours Per Week

Story Behind the Need

• Business group: Global Procurement Services - Supports contracts owners and stakeholders in sourcing, contracting, and managing third parties.
• The Source-to-Contracts Operations Analyst enables the Sourcing Intake Triage by clarifying and directing needs to pre-existing contracts and suppliers when possible.
• Additionally, this role monitors and reports compliance to the Global Procurement Policy. The role is responsible to follow and execute the Sourcing Intake Triage procedures to ensure Operational Level Agreement targets are met. Work is performed in accordance with the bank values and guiding principles, and in adherence to the bank Code of Conduct.

Typical Day in the Role:

• Review and triage goods/services intakes directing requestors to the correct sourcing channel. This will include the following:
• Applies knowledge of procurement policy and follows Standard Operating Procedures (SOPs) to triage goods and services intake requests. intake requests.
• Interacts with goods and services requestors and Sourcing Managers to review and clarify intake requests. Challenge requestors to direct low value and low risk intake requests to existing suppliers.
• Advises requestors to ensure mandatory requirements highlighted in the Self-Service Sourcing Guide are followed when the intake requests do not require Global Procurement Services Sourcing assistance.
• Deliver support and assistance daily to contract owners globally, to enable them to navigate the source-to-contract process. This will include the following on a daily basis:
• Respond to/solve enquiries and information requests (a.k.a. tickets, support issues). interacting with requestors via multiple channels.
• Log and track support issues/tickets.
• Re-assign requests to other groups as needed.
• Operates the Bank’s procurement technology solutions for consulting existing supplier/contract records and updates the intake requests as needed.
• Populates and maintains the intake requests Master Data Base. Updates the intake status daily to ensure accuracy of analysis dashboard.
• Executes the framework for Procurement Policy non-compliance and subsequent action plans.
• Prepares, updates, follows Standard Operating Procedures documentation to ensure data quality and consistent delivery of service according to established Operating Level Agreements (OLAs).
• Prepares, updates, follows the Problem Resolution Procedure (PRP) documentation to resolve common problems.
• Escalate issues to Manager and track to resolution. Understands how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.

Must Have Skills:

• 5 years of experience in operations, customer service, business help desk or support, branch management, project coordination, business administration, and/or business process improvement.
• 2 years of experience with Microsoft Office (Word, PowerPoint) and Excel (able to write formulas, effectively use lookup & references functions, logical functions and text functions at a minimum).
• Good customer service skills when dealing with internal and external stakeholders. (customer facing or operation)

Nice-To-Have Skills:

• Experience with ServiceNow or other procurement tools is desirable.

Best VS. Average Candidate:

• The ideal candidate is someone who can effectively communicate with stakeholders and has strong customer service experience. They should be able to independently perform tasks while following instructions and be highly proactive. The ideal candidate is someone who proactively asks questions and seeks collaboration to resolve issues.
• Someone with Excel experience, including skills in Pivot Tables, VLOOKUPs, report filtering and data manipulation. Please use a basic assessment to verify their Excel expertise.

Education & Certificates:

• College Diploma or University Degree in related field is necessary.

Candidate review and selection:

2 rounds:

1st round with Hiring Manager and one other manager, MS Teams video call - 30 minutes

Talk about previous experience, some questions plus the role overview.

***Excel and writing test will be sent once completing the first round****

2nd round with Hiring manager and Senior manager - MS Teams video call - 30 minutes

Talk about previous experience and understanding why they are interested in the role

***Please make sure the candidates are proficient in MS Excel, screening is required on your end****