Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

As a Business Data Analyst within the Assumed Administration team, you will act as a data administrator responsible for the ingestion, validation, reconciliation, and controlled maintenance of client data within operational databases supporting the North America Life portfolio. The role is focused on data integrity, audit readiness, and compliance with internal controls, ensuring accurate financial and operational reporting. This position supports business operations through hands-on data administration and analysis rather than information systems design or IT consulting.

Responsibilities

Process, validate, and administer incoming client data files within governed operational data repositories.
Perform data mapping, manual data entry, and verification to support standardized data models and controlled data structures.
Investigate and resolve client data issues and discrepancies through structured data analysis and validation controls.
Ensure data completeness, accuracy, and consistency across source and target systems.
Ensure monthly data loads meet defined performance and control metrics.
Update accounting and operational databases with client cashflows and reconcile data discrepancies across systems.
Verify premium, allowance, and tax calculations using reconciled and controlled data sets for assumed policies.
Support the maintenance of a strong operational control environment.
Develop and maintain ETL scripts for data acquisition, transformation, and controlled loading into operational databases.
Write and optimize SQL queries, VBA code, and macros to administer, validate, and analyze structured data for operational and audit purposes.
Adhere to IT controls, change-management protocols, and security standards.
Communicate with clients regarding data transmission requirements, validation issues, and discrepancy resolution.
Liaise with internal teams to support audits, retrocession business, and reporting.
Support stakeholders with data extracts, validations, and discrepancy resolution related to administered data sets.
Contribute to data and process enhancement initiatives, including testing and documentation.
Participate in client audits by supporting audit-related data validation and reconciliation.
Identify opportunities for process improvement to enhance data quality, efficiency, and control effectiveness.

Requirements

Proficiency in SQL, Python and Microsoft Office; VBA preferred.
Familiarity with audit and quality assurance principles.
Strong communication and relationship management skills.
Basic knowledge of re/insurance principles.
Basic French is an asset.
Detail-oriented, analytical thinker with a passion for solving complex problems.
Intellectual curiosity, professional integrity, and a collaborative mindset.
Ability to communicate effectively and think creatively.
1-3 years of TAI Experience.

Skills

SQL
Python
Microsoft Office
VBA
Data administration
Data validation
Database-driven environments
ETL script development
SQL query optimization
VBA code optimization
Macro development
Audit principles
Quality assurance principles
Communication
Relationship management
Re/insurance principles

Location

Toronto

Work Type

Hybrid
3 days a week in office

Experience Level

Entry-level
Mid-level

Education Level

Degree in Business, Mathematics, Computer Science, Engineering or related STEM field.
Any LOMA designations

Salary/Compensations

CAD $65,000 – $85,000 per year

Benefits

Medical coverage
Dental coverage
Vision coverage
Health spending account
Defined contribution pension plan
Life insurance
Short-term disability coverage
Long-term disability coverage
Annual incentive program

About the Company

PartnerRe is a leading, privately owned, multi-line global reinsurer with a reputation of financial stability and strength, and a commitment to rebuilding businesses and communities after risk events around the world.
Our mission is to continue to be a financially stable and predictable business partner, supporting our clients with solutions tailored to their needs, delivering superior returns to our owner, providing rewarding opportunities for our people and making a positive contribution to society.
To achieve this, we live by our values of Integrity, Performance, Collaboration, Straightforward Communication and Respect and Care.
Core to The PartnerRe Experience is our global nature. No matter where you sit in the company, you are part of something bigger.
Our teams represent our truly international mindset, forging connections across office locations and all levels of the organization and building a network of mutual success.
The result is a day-to-day experience that will allow you to: Shape your own career, Grow in a supportive environment, Connect with a community of experts, Make an impact.

Equal Opportunity

PartnerRe is an equal opportunities employer.
PartnerRe is committed to an inclusive, accessible recruitment experience. Reasonable accommodations for candidates with disabilities are available upon request throughout the hiring process.
PartnerRe provides a working environment in which diversity is valued, where all employees feel welcome, respected, and empowered to perform at their best.