Business Analyst, Reporting and Audit

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 The 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**

**PartnerRe is an equal opportunities employer.**

Please join our company LinkedIn Page for all updates on new positions that are coming live.

**Job Description**:
**About this job**:
We are seeking for our Toronto office, a Business Analyst who is a highly skilled, self
- motivated individual with extensive analyst background and skills. The Business Analyst will be responsible for the analysis, development and support of all incoming client data files for processing in PartnerRe systems. Typically, this data is in the form of transaction, in force, valuation, underwriting and claims files which have process streams that vary by function.

**About the role**:
Your internal responsibilities will include:

- Create and maintain the ETL scripts used for acquiring, transforming and loading into PartnerRe systems/tools.
- Design and maintain an effective control environment for all ETL processes, including underwriting, administration, claims, accounting and valuation.
- Ensure monthly data loads continue to meet stated metrics. Responsibilities include data/plan mapping (including entry and verification of manual data loads) for all clients, investigation and resolution of client issues, and accounting loads/verification.
- Analyze and design management reporting as defined by management. Write VBA code, macros, and SQL queries to extract, manipulate, and distribute data.
- Document all IT processes and procedures put into production.
- Adhere to all IT controls and security established by IT management.
- Keep the Business Analysis Manager informed of ongoing work activities and any unusual circumstances to ensure quality and timely deliverables.
- Update accounting system to track premium and commission accounts. Find and correct any discrepancies.
- Assist other teams within North American Life Operations when necessary including, claims, retro and reporting teams.
- Assist Valuation and Pricing with requests for data and data inquiries. Analyze discrepancies and provide documentation.
- Identify opportunities for process improvement, initiate internal reports and create efficiencies to improve data quality.
- Assist with Enhancement Projects including creation of project, testing and preparation for deployment. Defect/bug discovery and acceptance testing for the administration system. Document testing and outcomes and liaise with other departments to ensure tasks and bugs are completed to specifications.
- Participation in client visits.
- Communicate with clients to facilitate transmission of monthly transaction files and address any questions/clarifications regarding data issues with clients.
- Conduct client audits (desk and on-site audits).

**Qualifications**:
**About you**:

- Demonstrated results achieved through leadership skills, prior supervision preferable
- Demonstrated ability to maintain effective control environment
- Demonstrated ability to communicate with senior management, peers and staff
- Demonstrated ability to promote effective teamwork and accountability
- Ability to handle multiple assignments communicating prioritizations to required levels
- Ability to effectively work with external parties (auditors, vendors, advisors and regulators)
- Highest degree of professional ethics
- Strong interpersonal skills & effective communicator (written and oral)
- Demonstrated analytical, problem-identification and resolution skills with attention to detail
- High degree of personal competence (self-awareness, self-management) and social competence (social awareness, relationship management)

**Qualifications and Experience Required**:

- Bachelor’s Degree in the field of computer science, management