Junior Analyst, Programming And Reporting

What You’ll Do

• Provide QC support and enhancements for existing tools and EUCs related to the above
• Consult and problem solve on various business issues with cross functional groups
• As required, run existing automation processes (e.g. reporting, ad-hoc requests etc.) that enable information to be delivered to stores accurately.
• Build and develop automation processes for new reporting based on requirements
• Develop key reporting tools using MS Excel, VBA, Python and other data analytics tools (KNIME, Aginity, etc.)
• Develop tools and EUCs based on business requirements that will integrate with Canadian Tire Corporation store systems

What You Bring

• Post Secondary education in retail management, computer programming, or other business related designation
• 2+ years of experience demonstrating programming skills
• Knowledge in Python, Java, and JavaScript is an asset
• Advanced programming skills using VBA, SQL and RESTful APIs
• Excellent problem solving, listening, and time-management skills
• Ability to ‘learn on the fly’
• Attention to detail with high quality end-products
• Canadian Tire Retail experience and IBM AS/400 system knowledge is a strong asset
• Excellent written and verbal communication skills

What You’ll Do

The Pro Hockey Life (PHL) Finance & Planning group is a dynamic team that provides critical insights and brings together key stakeholders in support of the business’s long-term strategy. We play a key role in facilitating discussion and in identifying and analyzing the impacts of business decisions from a financial perspective. Reporting to the Manager, FP&A - Pro Hockey Life & Party City, the Senior Financial Analyst will play a key role within a dynamic FP&A team. This position utilizes strong analytical skills and financial knowledge to provide insights on key working capital and financial metrics for the PHL business. This position also plays an important role in the support finance provides to our business partners. In addition, the incumbent will be part of the budget and forecast cycles that play a key role in building out the strategies of the PHL business unit.

• Prepare, analyze and deliver month end review presentations to senior leaders and various teams in the business and in finance
• Support the continuous improvement of the financial planning, forecasting, and reporting processes within the team to improve efficiency, and synergies.
• Support the business with a fully analytical skillset, including developing operational reporting and executive dashboards, providing analysis, conclusions and recommendations for the business
• Provide support to the business by monitoring results versus prior year & budget/ forecast, and providing thorough analysis and investigating variances while identifying risks and opportunities with a focus on providing meaningful/actionable insights
• Work with the Manager, FP&A to provide quantitative and qualitative decision support including proactive financial analysis
• Lead a variety of ad hoc projects as assigned by the Manager
• Present findings to all levels of the organization’s leadership in an understandable and compelling manner
• Works with business stakeholders in developing and analyzing Cost Benefit Analysis Presentations (CBAs) for new capital projects
• Review key performance metrics (financial and business metrics) to improve existing reports and develop new reports
• Optimize tasks to increase efficiency and accuracy, include driving the design of automation for the business
• Prepare annual operating budgets and yearly forecasts as well as in-depth projections and long-term outlooks.
• Foster strong working relationships across the businesses, and work proactively to identify opportunities for finance to act as a strategic business partner

What You Bring

• Minimum of 3 years experience in FP&A or related role, preferably in a corporate or retail environment
• Strong interpersonal and communication skills with a demonstrated ability to build and maintain strong relationships
• Ability to influence and persuade different points of view
• Ability to execute multiple projects and drive key business results under tight deadlines
• Strong time management and self-management skills
• Ability to clearly and confidently, communicate results to technical and non-technical audiences
• University Degree in Accounting/Finance, or business-related discipline AND Professional Accounting designation/MBA or working towards one (CPA- CMA, CA, CGA)
• Advanced MS Excel and PowerPoint skills. Experience using Hyperion Planning & HFM, ThoughtSpot and Peoplesoft accounting systems is a plus
• Ability to work independently and in an ambiguous environment
• Self-starter attitude with willingness to learn and master new technologies
• Strong problem solving, analytical and strategic thinking skills; able to see the “big picture” in a complex business environment

Hybrid

At Canadian Tire we value flexibility. We have adopted a hybrid work model whereby employees use a combination of working in office and virtually in service of outcomes. Each leader is empowered to decide what work is best achieved in person based on the unique needs of their team.

About Us

Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, 1,700 retail locations, financial services, exemplary e-commerce capabilities, and exciting market-leading merchandising strategies. We dream big and work as one to innovate with purpose for our customers at every level of our business, investing in new technologies and products, and doubling down on top talent to drive the company forward. We offer competitive salaries and wages to CTC employees, as well as store discounts, supported learning through our Triangle Learning Academy, Canadian Tire Profit Sharing, and retirement and savings programs for eligible employees. As part of our enhanced flex benefits program, we offer mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families, including total well-being, and mental health tools and resources for all employees. Join us in helping to make life in Canada better through living and working our Core Values: we are innovators and entrepreneurs at our core, outcomes drive us, inclusion is a must, we are stronger together and we take personal responsibility. It is an especially exciting time to join CTC and its family of companies where career opportunities are wide-ranging! 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.