Closed listing
Business Data Analyst - Reporting and Audit
- Toronto, ON, Canada
$65,000 to $85,000 CAD / year
This opening has closed.
The original listing is kept below for reference.
Job details
- Pay
- $65,000 to $85,000 CAD / year
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Company Description
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
View Home - PartnerRe Experience e-book to find out more about what it’s like to work at PartnerRe.
We are always looking for bright, proactive individuals to join our team!
Please follow our Careers page for all updates on new positions. We look forward to receiving your application.
PartnerRe is an equal opportunities employer.
Please join our company LinkedIn Page for all updates on new positions that are coming live.
Compensation and Benefits
The expected base salary range for this position, when hired into our Toronto location, is CAD $65,000 – $85,000 per year. For positions based in other jurisdictions, compensation will be determined in alignment with local regulations, market benchmarks, and internal compensation frameworks. The above range reflects the typical base salary range for candidates hired into this position. The actual salary will vary depending on a number of factors, including job location, experience, qualifications, education/training, skills, market conditions, and alignment with the role’s requirements.
In addition to base salary, 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. Eligible employees also have the 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, etc.
Working Arrangement
PartnerRe operates with a hybrid work approach that balances in‑office collaboration with the flexibility of remote work. Our employees are required to be in the office 3 days a week. Our goal is to create an environment where employees can connect, innovate, and perform at their best.
This position is for an existing vacancy within our organization.
PartnerRe is committed to an inclusive, accessible recruitment experience. Reasonable accommodations for candidates with disabilities are available upon request throughout the hiring process.
As a Business Data Analyst within the Reporting & Audit 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.
Data Management & Analysis
- 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.
Operational Support
- 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.
Technical Development
- 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.
Stakeholder Collaboration
- 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.
Project Support & Quality Assurance
- 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.
About You
- Knowledge of re/insurance principles
- Proficiency in SQL, Python and Microsoft Office; VBA preferred.
- Familiarity with audit and quality assurance principles.
- Strong communication and relationship management skills.
- Basic French is an asset.
- You are a detail-oriented, analytical thinker with a passion for solving complex problems. You bring intellectual curiosity, professional integrity, and a collaborative mindset to everything you do. Your ability to communicate effectively and think creatively makes you a valuable partner across teams.
- 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.
- Any LOMA designations
Additional Information
#LI-Hybrid:
PartnerRe provides a working environment in which diversity is valued, where all employees feel welcome, respected, and empowered to perform at their best. We invite you to learn more about D&I at PartnerRe.
Thank you,
PartnerRe Hiring Team
More about this job
Responsibilities
Responsible for the ingestion, validation, and maintenance of client data within operational databases for the North America Life portfolio. The role ensures data integrity and audit readiness through SQL/VBA development and reconciliation of financial data sets.
Requirements
Requires a degree in a STEM field and proficiency in SQL, Python, and Microsoft Office, with VBA preferred. Candidates should have entry to mid-level experience in data administration and knowledge of re/insurance principles.
Skills
- SQL
- Python
- VBA
- Microsoft Office
- Data Validation
- ETL
- Data Mapping
- Data Reconciliation
- Financial Reporting
- Audit Compliance
- Data Administration
- Relationship Management
Benefits
- Medical Coverage
- Dental Coverage
- Vision Coverage
- Health Spending Account
- Life Insurance
- Short-term Disability Coverage
- Long-term Disability Coverage
- Annual Incentive Program
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Finance & Accounting
- Technology
Keywords
- Reinsurance
- SQL
- Python
- VBA
- ETL
- Data Integrity
- Audit
- LOMA
- Data Mapping
- Financial Reporting
- Compliance
- Data Validation
- STEM
- North America Life Portfolio
- Operational Databases