Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
About the Role
This role supports the TPA underwriting team by analyzing program performance, producing reports, and driving process improvements. A key objective is to automate manual reporting processes, transitioning towards scalable solutions. This is a fixed-term position with potential for extension or permanent employment.
Responsibilities
- Prepare and deliver TPA program reviews, including performance summaries, loss trends, pricing adequacy, and key metrics.
- Aggregate and validate data from TPAs and internal systems to ensure data integrity and consistency.
- Produce recurring reports to support portfolio monitoring and client discussions.
- Translate complex data into clear, actionable insights for underwriting and leadership teams.
- Develop and maintain standardized templates and reporting tools to improve efficiency and consistency.
- Identify process gaps and partner with stakeholders to streamline workflows and reduce manual effort.
- Support the design and implementation of automation solutions (e.g., dashboarding, automated data pipelines, report generation).
- Document existing reporting processes and contribute to the development of future-state automated frameworks.
- Assist with ad hoc analyses, audits, and special projects related to TPA performance and underwriting strategy.
Requirements
- Bachelor’s degree in Business, Finance, Actuarial Science, Data Analytics, or related field.
- 1–3 years of experience in insurance underwriting, TPA program management, or insurance analytics/reporting.
- Intermediate Excel skills (pivot tables, lookups, data manipulation) with the ability to work with large datasets.
- Exposure to automation tools or programming (e.g., VBA, Power Automate, Python, SQL) is an asset.
- Strong attention to detail with the ability to reconcile and validate multiple data sources.
- Excellent communication skills to present findings to both technical and non-technical stakeholders.
- Analytical and data-driven mindset.
- Continuous improvement and automation focus.
- Strong attention to detail and accuracy.
- Ability to manage multiple priorities in a deadline-driven environment.
Skills
- Excel
- Data Analysis
- Reporting
- Automation Tools
- VBA
- Power Automate
- Python
- SQL
- Communication
- Analytical Thinking
Location
- Remote
Work Type
- Fixed-term
- Full-time
Experience Level
- Associate
- 1-3 years
Education Level
- Bachelor's degree
Salary/Compensations
- $45,000 - $58,500
Benefits
- Best in class total compensation
- Retirement savings plan with company contributions
- Health & Wellness offerings
- Mental Health programs and support
- Support achieving industry designations
- Competitive compensation
- Comprehensive group benefits plan
- Generous retirement savings plan
About the Company
- People Corporation is a national provider of benefits, retirement, wealth, wellness, and human resource solutions.
- Our experts and solutions serve over 20,000 clients representing nearly 3 million Canadians.
- We offer customized solutions designed to fit the unique needs of businesses and their employees, members and stakeholders.
Equal Opportunity
- Providing an inclusive, accessible environment, where all employees and clients feel valued, respected and supported is something we're committed to.
- We are dedicated to building a workforce that reflects the diversity of the communities in which we live, and to creating an environment where every employee has the opportunity to reach their potential.
- If you require an accommodation or an alternative format of any posting please reach out to careers@peoplecorporation.com.
- For more information on Accessibility at People Corporation, visit our link https://www.peoplecorporation.com/en-ca/accessibility-statement.