Financial Services Reporting & Analysis Manager

Job Summary: 

The Reporting & Analysis Manager will oversee reporting and analytics for the entire Financial Services division at The Brick and related companies – 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.

• Credit Sales & Risk Management Reporting:
• 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 reporting team and external partners to automate reports and improve efficiency.

Reporting and Analysis Deliverables:

• Financial performance by channel, enrollment trends, insurance attachment rates, premiums by program, province, age group, etc.
• Customer Contact Centre volumes, performance (call answer, first-call resolution, etc.), and trends.
• Customer satisfaction measurement tracking.
• Claims tracking and trends by distributor, claim type, province, age group, etc.

Competencies:

• Financial analysis and reporting.
• Risk assessment and management.
• Data analysis and database querying.
• Problem-solving and troubleshooting.
• Strategic planning and execution.
• Collaboration and teamwork.

• Education in Finance, Accounting, Business, or a related field.
• At least 7 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).
• Excellent communication, leadership, and teamwork skills.
• Ability to handle multiple tasks and prioritize effectively.