Procurement Business Analyst

What we offer

In addition to a competitive salary and a rewarding career where you can truly make a difference, we offer a comprehensive package that meets the various needs of our diverse employees, including :

• Ability to participate in inclusive employee-led networks to educate, inspire, amplify voices, build relationships and provide development opportunities;
• Minimum three (3) weeks of paid annual vacation days, increasing with years of service;
• Four (4) paid personal days;
• Defined benefit pension plan with OMERS, includes 100-per-cent employer matching;
• Health and dental benefits, including a health spending account available upon your start date;
• Employee and family assistance program;
• Maternity and parental leave top up (93% of base salary);
• Training and development programs including tuition reimbursement of $1500 per calendar year.
• Fitness membership discount;

This job offers the opportunity to work from home as part of a hybrid work arrangement. This arrangement will allow you to work some days at a TCHC work location and the rest of the time from home.

The amount of time required to work at a TCHC work location is flexible, while considering operational and service delivery requirements.

Make a difference

As a Procurement Business Analyst, your expertise in supply chain data analytics, multivariant statistical data modelling, vendor spend analysis, forecasting, operational planning, reporting and business process improvement will be an integral part of the Supply Chain Strategy at TCHC.

Reporting to the Senior Director, Strategic Procurement, you will be focusing on providing technical, analytical, and reporting support to the supply chain operations.

You will also participate in supporting continuous improvement initiatives to streamline processes, reduce costs, and improve customer service.

What you’ll do

• Conducting marketing scans on pricing trends, assessing and standardizing the pricing regimes for RFxs
• Analyzing the pricing proposals from proponents and spend analytics
• Conducting the vendor spend analytics on the monthly basis by projects
• Analyzing and tracking the multi-year contract commitments and support annual budgeting process
• Develop and maintain databases, complex multivariant statistical data models, promotional forecasting models, ETL processes and supply chain dashboards using SQL Server, Python, R, and Power BI
• Conduct data analysis, provide insights to decision makers and implement business solutions to improve service / product flow and operational efficiency across the TCHC supply chain
• Analyze operational processes and make recommendations to improve performance and reduce cost
• Monitor, analyze, and report on supply chain productivity and financial results
• Analyze, interpret, and communicate operational and process analysis information via periodic reporting, ad hoc studies, and presentations
• Contribute analysis and decision support by process mapping, simulation, benchmarking and score carding
• Assist in the research, selection, and implementation of new software products, including participating in testing and documentation
• Perform analysis and transformation of various internal and external data sets with the aim of generating actionable insights
• Identifies and recommends opportunities for savings, best value and improved services.
• Provide assistance with process automation and technical support to the operational teams when required
• Leverage data visualization tools to represent the data in a business-friendly manner
• Collaborate with key stakeholders to define and continuously improve the user experience, relevance, and effectiveness of decision support tools
• Identify opportunities to leverage advanced analytics (esp. predictive) across the Supply Chain and Procurement teams to effect better business outcomes
• Support data stewardship and data governance activities and initiatives as needed

What you’ll need

• Post-secondary education in Data Analytics, Statistic, Business Studies, Supply Chain Management (or Industrial Engineering) together with related experience
• Demonstrated 3+ years of experience in developing multivariant statistical data models, promotional forecasting, data analytics, and automated dynamic dashboards using SQL, SQL Server, SSIS, Python, R, Power BI, excel, and MS Access
• Demonstrated and relevant 2+ years of experience in housing supply chain operations, analytics, forecasting and modelling
• Knowledge of complex value analysis methodologies, financial concepts related to ABC costing analysis, and operational efficiency measurement techniques
• Demonstrated medium / large project management experience
• Expert knowledge and experience using MS Office particularly Access, Excel, PowerPoint, Visio and Power BI.
• Previous experience with YARDI an asset.
• Excellent interpersonal and communications skills (both verbal and written) with ability to work with cross-functional teams
• You will have a good understanding of public procurement, trade agreements and purchasing by-law, contract formation with respect to terms and conditions, and specification development and competitive bidding processes.
• You have demonstrated ability to work in a fast paced and challenging environment using project planning principles in the purchasing processes.
• You have the ability to take others’ perspectives into account when communicating, negotiating or presenting arguments and can facilitate open communication and information exchange.
• You will assess information quickly and accurately (i.e. high level of analytical and attention to detail skills with respect to review of tender documents).

Formulates innovative solutions or resolves problems by developing new concepts, models, frameworks or approaches to meet business objectives

• You will assume personal responsibility and follows up on commitments.
• You can think diversely and outside the box to try new strategies that may differ from established approaches to policing.

Provides service in a professional, sincere and respectful manner (e.g. maintains high level of confidentiality and exercise good judgment and discretion responding to inquiries).

Exceptional analytical and problem-solving skills; and highly detail oriented

What’s next

Once you apply, we’ll review your resume and contact you if we believe your skills and experience will make you successful in the role.

If you are selected to move forward, the process will include one or more interviews and / or assessments and reference checks.

INDS