Operations Planning Analyst

Mark's Work Wearhouse Ltd.; Calgary; Presencial; CAD 63.000 - 104.000; Jornada completa

Descripción de la vacante

Mark's Work Wearhouse Ltd. is seeking an inventory planning and forecasting specialist in Calgary to drive demand forecasts for ongoing and new programs.

You will partner with vendors, translate analytics into actionable guidance, and optimize inventory across Fulfillment Centres while testing planning tools with IT and business teams. Responsibilities include leading forecast cycles, scenario analysis, monthly finance reporting, and developing automation to reduce manual work.

Formación

• Strong proficiency in Excel for data analysis using formulas and Pivot Tables.
• Experience with SQL or other database querying languages.
• Knowledge of data preparation and data analysis.
• Working knowledge of ERP platforms such as Microsoft D365/PeopleSoft.
• Ability to translate analytical insights into clear recommendations for stakeholders.
• Experience with inventory replenishment and planning toolsets.
• Retail/wholesale/B2B experience with understanding product category impacts.

Responsabilidades

• Forecast demand for ongoing programs and new programs.
• Meet with vendors and provide Mark's Commercial order projections.
• Provide projections to Retail PODs for shared products.
• Analyze core inventory requirements for Fulfillment Centres.
• Test and implement planning tools with IT and business partners.
• Balance inventory between Fulfillment Centres.
• Lead forecast cycles using planning assumptions and quarterly processes.
• Perform scenario analysis to mitigate supply, inventory, and service-level risks.
• Prepare monthly reporting for the Finance team.
• Write SQL queries and maintain KNIME workflows.

Conocimientos

Excel

SQL

Data analysis

ERP systems

Stakeholder communication

Inventory planning

Retail/B2B experience

Herramientas

KNIME

ANAPLAN

Power Query

SQL

Descripción del empleo

What you'll do

• Forecast demand for ongoing programs as well as new programs.
• Meet with vendors and provide Mark's Commercial order projections.
• Provide Mark's Commercial order projections to Retail PODs for shared products.
• Analyze core inventory requirements for Fulfillment Centres.
• Review seasonal Fulfillment Centre inventory and take action on stranded inventory.
• Work with IT and business partners to test and implement planning tools.
• Balance inventory between Fulfillment Centres.
• Contact PODs for product recommendations supporting customer opportunities.
• Lead recurring forecast cycles using approved planning assumptions, size curves, inventory holds, safety stock settings, allocation logic, and quarterly planning processes.
• Perform scenario analysis and recommend actions to mitigate supply, inventory, and service-level risks.
• Support the development and maintenance of forecasting tools, templates, and planning models.
• Calculate demand and place import purchase orders.
• Implement item coverage and floor values based on demand forecasts.
• Analyze demand and place purchase orders ahead of cost increases when appropriate.
• Analyze inventory positions, open sales orders, and fulfillment constraints to identify risks and opportunities.
• Coordinate inventory transfers, inbound shipments, vendor supply commitments, and replenishment activities.
• Review seasonal inventory strategies and recommend actions to mitigate excess and stranded inventory.
• Monitor and manage critical purchase order activity throughout the procurement lifecycle.
• Own material purchase order exceptions and ensure timely resolution through established workflows.
• Analyze open purchase orders, vendor confirmations, and supply constraints to recommend buy, expedite, transfer, substitute, future-date, hold, or cancellation actions.
• Work closely with suppliers, sourcing teams, and supply chain partners to proactively manage supply disruptions.
• Escalate critical risks impacting customer fulfillment, inventory availability, or service levels.
• Complete quarterly accrual markdown activities.
• Prepare monthly reporting for the Finance team.
• Review and submit Cat50 ISF activities within ANAPLAN as required.
• Develop ad hoc reports related to inventory, sales, forecasting, and operational performance using various reporting tools.
• Write SQL queries required by the business.
• Develop and maintain KNIME workflows and reporting files as required.
• Maintain planning data quality, reporting controls, and forecasting integrity.
• Produce concise operational insights, recommendations, risks, and opportunities for stakeholders and leadership teams.
• Support business decision-making through data-driven analysis and forecasting expertise.
• Work with business and technical partners to test, improve, and implement planning tools and processes.
• Maintain and support forecasting templates, Power Query transformations, reporting automation, and associated controls.
• Identify opportunities to reduce manual effort through automation and workflow improvements.
• Participate in continuous improvement initiatives that enhance planning accuracy, operational efficiency, and customer service performance.
• Support implementation of new planning capabilities, reporting tools, and operational processes.

What you bring

• Strong proficiency in Microsoft Office Suite applications, specifically Excel, to perform data analysis including formulas, Pivot Tables, and advanced data manipulation.
• Experience with SQL or other database querying languages and tools.
• Knowledge and experience in data preparation and data analysis.
• Working knowledge of enterprise systems including Microsoft D365, PMM, PeopleSoft, or similar ERP platforms.
• Demonstrated ability to translate analytical insights into clear recommendations and effectively communicate with technical and non-technical stakeholders.
• Experience with inventory replenishment and planning toolsets.
• Experience in retail, wholesale, contract, or B2B environments with the ability to understand product category impacts across the broader business.
• Ability to model processes and determine financial implications of alternatives.
• Goal-driven individual who continuously seeks improvement opportunities.
• Flexible and adaptable individual who can effectively prioritize to meet changing business demands.
• Strong problem-solving skills and ability to think critically.
• Ability to work independently with minimal supervision.
• Experience managing inventory, forecasting, purchase order, replenishment, and fulfillment-related activities.
• Strong analytical, planning, and problem-solving capabilities within an exception-driven environment.
• Experience documenting business processes and supporting continuous improvement initiatives.
• Ability to prioritize multiple activities while balancing customer service, inventory, and financial objectives.

In addition to competitive pay, we offer: Comprehensive benefits and retirement programs Performance incentives, Continuing Education Programs Other perks to support your well-being Career growth opportunities and product discounts Broadband.

Salary Range: $44,000 – $73,000. Our typical hiring range is between $44,000 and $58,000. Salary decisions are also dependent on other factors such as your experience, industry benchmarks, internal equity and other role-specific requirements. For critical roles, the compensation offering will be reviewed to ensure alignment with market rate and conditions and the unique value you bring to the role.

About Us

At Marks, we want you to experience an extraordinary career in helping to lead our brand's evolution to be Canada’s number one destination for industrial and casual apparel and footwear. As one of Canada’s leading apparel retailers, and a valued part of the Canadian Tire family of companies, Mark’s stands out for its commitment to comfort, quality and style. Mark’s is a leader in product development, innovation and quality through its assortment of industrial apparel, footwear and accessories, with strong private and exclusive brands. Join us, where there's a place for you here.

Our Commitment to Diversity, Inclusion and Belonging

We are committed to fostering an environment where belonging thrives, and diversity, inclusion and equity are infused into everything we do. We believe in building an organizational culture where people are consistently treated with dignity while respecting individual religion, nationality, gender, race, age, perceived ability, spoken language, sexual orientation, and identification. We are united in our purpose of being here to help make life in Canada better.

Accommodations

We stand firm in our Core Value that inclusion is a must. We welcome and encourage candidates from equity-seeking groups such as people who identify as racialized, Indigenous, 2SLGBTQIA+, women, people with disabilities, and beyond. Should you require any accommodation in applying for this role, or throughout the interview process, please make them known when contacted and we will work with you to help meet your needs.

We are one of Canada’s most admired and trusted companies

With world-class owned brands and exciting market-leading merchandising strategies, we are continually innovating with purpose: to excite and serve Canadian customers from coast-to-coast. We are connected to communities, big and small, from coast-to-coast, offering products and services that reflect the diverse nature of every one of them. From sports to outdoors, automobiles to homes, we know and understand life in Canada like no other retailer.

If you’re ready to take on new challenges – be it in digital, IT, marketing, data & analytics, merchandising, or one of the many other roles we have – there is a place for you here.