PartnerRe is a leading global reinsurer committed to financial stability and client support. The Business Data Analyst will be responsible for data administration, ensuring data integrity, and compliance with internal controls to support the North America Life portfolio.
Process, validate, and administer incoming client data files (e.g., transaction, in-force, valuation, underwriting) 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
Qualification
Required
Knowledge of re/insurance principles
Proficiency in SQL, Python and Microsoft Office
Familiarity with audit and quality assurance principles
Strong communication and relationship management skills
You are a detail-oriented, analytical thinker with a passion for solving complex problems
Entry-level to mid-level position with hands-on experience in data administration, data validation, or database-driven environments
Degree in Business, Mathematics, Computer Science, Engineering or related STEM field
Preferred
VBA preferred
Basic French is an asset
Any LOMA designations
Benefit
Eligible employees may participate in our annual incentive program, payment under which is at the discretion of PartnerRe and subject to individual and company performance
Opportunity to participate in an array of benefits, including medical, dental and vision coverage
A health spending account
A defined contribution pension plan
Life insurance
Short- and long-term disability coverage
PartnerRe is a holding company for its international reinsurance group.
