Financial Services Senior Analyst

Job Summary: 

The Senior Analyst will support reporting and analytics for the Financial Services division at The Brick and related companies. This includes contributions across consumer and commercial credit, insurance, and warranty programs. The role will partner with department heads to assist with strategic planning, business modeling, and accurate, efficient reporting.

This role reports to the Director of Payment Solutions and works closely with the VP of Financial Services to support data-driven decision-making across the division.

Credit Sales & Risk Management Reporting:

• Assist in 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.
• Support 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.
• Support with 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.
• Identify and escalate reporting issues as needed 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.
• Data analysis and database querying.
• Problem-solving and troubleshooting.
• Strategic planning.
• 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.