Job Description

25-027 Business Process Specialist

Number of Vacancies: 1
Resume Due Date: Monday, March 24, 2025 (5:00PM EST)
Duration: 9 Months
Hours of work: 35
Location: 1855 Energy Drive, Courtice (Hybrid – 2 days remote)



Job Overview

Business Process Analyst/Business Process Specialist

The Business Process Specialist will be responsible for providing recommendations to the divisions on business process integration and associated improvement programs. This person will also participate in the development and maintenance of business process integration programs.

• The successful candidate will function as an individual contributor leading process improvements and product implementation to deliver program enhancements and professional services delivery.
• Work with Recruitment and Onboarding team to identify specific needs and areas for improvement.
• Conduct requirements gathering, data and process analysis, and gap analysis.
• Provide direction on business process documentation and associated improvement programs.
• Prepare reports and presentations for appropriate Line Management, identifying priority areas for business process improvement.
• Facilitate the identification of priority areas for business improvement and integration.
• Define systems requirements, design, and prototype business processes, test complex functionality and train others and work in a team environment.
• Develop advanced reports, automate workflows, and optimize data processes. Must have strong skills in data analysis, automation, and visualization to improve efficiency and decision-making. The individual must have the following expertise:

• Expert level experience in Excel to create dynamic dashboards, Power Pivot models, and automate reports with VBA. Use Power Query and macros to clean, transform, and streamline workflows. Master XLOOKUP, INDEX/MATCH, dynamic arrays, and nested logic functions.
• Expert level experience in Power Automate to automate data flows with Power Automate, SharePoint, SQL, and APIs. Automate approvals, notifications, and data processing across Microsoft 365, SharePoint, and Teams. Connect Excel, SQL, Power BI, and third-party apps (e.g., Salesforce, Dynamics) for seamless data flow. Implement conditional logic, exception handling, and alerts for failed workflows.
• Expert level experience in Power BI to design dynamic, user-friendly reports with drill-through, slicers, and tooltips for deep insights. Use Power Query, relationships, and DAX calculations to build complex, optimized data models. Connect to multiple sources (SQL, SharePoint, APIs, cloud services) and automate data refreshes. Leverage Python, R, and AI visuals for predictive analytics and advanced data storytelling.

Qualifications

• Bachelor Degree in Business, Human Resources, Computer Science, Information Systems, Education or equivalent experience in a related relevant field.
• Business writing experience (requirements documents, specifications)
• Strong Data analysis experience
• Experience in developing Standard Operating Procedures and process documentation for various audiences both technical and non-technical
• Experience leading client teams and driving their work to ensure project timelines are met.
• Experience managing workstreams, including monitoring for project issues and escalations.
• Demonstrated ability to build relationships and credibility quickly.
• Strong verbal and written communication skills, with the ability to distill complex information into clear, concise content to be shared with the team.
• Experience working with SAP SuccessFactors Reporting
• Expert level skills with Microsoft Excel, PowerBI and PowerAutomate
• Experience with Microsoft Office Products
• Ability to assess and assist clients with existing systems and optimize their solutions using existing knowledge of system functionality and best practice recommendations.
• Ability to work collaboratively as part of a project team, deploying the features and functions of SuccessFactors products as outlined above.
• Ability to manage time and multiple projects with a high degree of attention to detail.