Reporting & Analysis Manager (Financial Services)

Leon's Furniture; Edmonton; On-site; CAD 95,000 - 130,000; Full time

Job summary

Leon’s Furniture is seeking a Reporting & Analysis Manager for its Financial Services division in Edmonton. You will oversee reporting across consumer and commercial credit, insurance products, and warranty-related analytics, collaborating with department heads for strategic planning and post-mortem analyses.

The role reports to the Director of Payment Solutions with a dotted line to the VP of Financial Services.

Qualifications

• Education in Finance, Accounting, Business, or a related field.
• At least 5 years of experience in accounting, financial analysis, reporting, or a related field.

Responsibilities

• Oversee the creation and distribution of reports for consumer and commercial credit, including credit sales, new credit card applications, insurance sales, credit risk, commercial receivable and bad debts.
• Manage journal entries and account reconciliations for various financial services areas.
• Run queries and analyze AR transaction data from the database.
• Utilize intermediate Excel skills, including pivot tables and MS Query to analyze and present data.
• Conduct warranty claims analysis and forecast outcomes for new programs.

Skills

Analytical skills

Excel

POS+ familiarity

Communication

Leadership

Prioritization

Financial analysis

Risk management

Data querying

Strategic planning

Collaboration

Education

Finance/Accounting/Business degree

Tools

MS Query

Pivot Tables

LFL POS+

Job description

Reporting & Analysis Manager (Financial Services)

Regular Full Time Edmonton, AB, CA

About Company:

For over 115 years, Leon’s Furniture Limited (LFL Group) has been helping Canadians create homes they love. Founded in 1909 in Welland, Ontario, Leon’s has grown from a single furniture store into one of Canada’s largest and most respected retailers, serving customers in communities across every province.

Today, LFL Group is a proudly Canadian organization with a portfolio of trusted retail brands and businesses, including Leon’s Furniture, The Brick, Appliance Canada, TransGlobal, Midnorthern Appliance, and The Brick Mattress Store, along with a network of distribution, transportation, and corporate operations that support millions of customers nationwide.

Our continued success is built on the dedication of our people. We are committed to creating an inclusive workplace where every associate is treated with respect, provided with equal opportunities to grow, and supported through competitive compensation, comprehensive benefits, and ongoing career development.

As one of Canada's leading retailers, we continue to invest in our people, our brands, and our future. While the retail landscape continues to evolve, LFL Group remains focused on innovation, exceptional customer experiences, and building long-term careers for talented individuals who share our passion for excellence.

Whether you're just starting your career or looking for your next opportunity, you'll find a place to grow, make an impact, and be part of a company with a proud Canadian legacy and an exciting future.

About the Role:

The Financial Services Reporting & Analysis Manager will oversee reporting and analytics for the entire Financial Services division at LFL – which includes support for consumer credit, commercial credit, insurance companies, and warranty businesses. This role involves working collaboratively with the various department heads within the financial services team to help with strategic planning, business models, pre- and post-mortem analyses, and ensuring the accuracy and efficiency of financial services reporting.

Reporting to the Director of Payment Solutions, with a dotted line to the Vice President of Financial Services, this role will be critical to the continued growth and success of this division of the organization.

Qualifications:

• Education in Finance, Accounting, Business, or a related field.
• At least 5 years of experience in accounting, financial analysis, reporting, or a related field.
• Strong analytical skills and attention to detail.
• Intermediate Excel skills, including the ability to create and manipulate pivot tables and MS Query (or equivalent).
• Familiarity with LFL POS+ and retail systems.
• Excellent communication, leadership, and teamwork skills.
• Ability to handle multiple tasks and prioritize effectively.
• Financial analysis and reporting.
• Risk assessment and management.
• Data analysis and database querying.Problem-solving and troubleshooting.
• Strategic planning and execution.
• Collaboration and teamwork.

Responsibilities:

• Oversee the creation and distribution of reports for consumer and commercial credit, including credit sales, new credit card application, insurance sales, credit risk, commercial receivable and bad debts.
• Manage accounting tasks such as journal entries and account reconciliations for various financial services areas.
• Running queries and analyzing AR transaction data from the database.
• Utilize intermediate Excel skills, including pivot tables and MS Query (or equivalent), to analyze and present data.
• Warranty Claims Analysis:
  • Conduct claims analysis specific to warranty programs and products.
  • Analyze sales data to identify factors impacting sales positively or negatively, such as pen rates and attach rates.
  • Forecast and predict outcomes for new programs, considering volatility, claims, and commission models.
• Insurance Client and Contract Analysis:
  • Develop, maintain, and distribute comprehensive internal and external reporting related to Trans Global Insurance and Trans Global Life Insurance companies.
  • Contribute to investigating and establishing working models for new clients, understanding their volumes and claims risk.
  • Analyze expiring contracts, profitability by contract type, and overall health of the book of business.
  • Assist with pricing models and thresholds for new programs.
  • Create reporting and dashboards for MVPs and Pilot programs
• KPI Monitoring and Reporting:
  • Monitor and report on key performance indicators (KPIs) related to financial services performance.
  • Analyze and report on KPIs to identify areas for improvement and determine corrective actions.
• Additional Responsibilities:
  • Conduct franchise credit risk analyses and provide actionable insights.
  • Help design, and report on, new and exciting contests for financial services to engage and motivate the team internally and externally.
  • Troubleshoot errors in reporting and work to resolve them promptly.
  • Work closely with the LFL reporting team and external payment providers to automate reports and improve efficiency.