Business Data Analyst

About PartnerRe

PartnerRe is a leading, privately owned, multi-line global reinsurer with a reputation of financial stability and strength. Our mission is to continue to be a financially stable and predictable business partner, supporting our clients with solutions tailored to their needs.

We live by our values of Integrity, Performance, Collaboration, Straightforward Communication and Respect and Care. Our global nature allows you to shape your own career, grow in a supportive environment, connect with a community of experts, and make an impact.

The Business Data Analyst will be responsible for the analysis, development, and support of all incoming client data files for processing in PartnerRe systems. This includes ensuring monthly data loads meet stated metrics, investigating and resolving client issues, and accounting loads/verification.

• Ensure monthly data loads continue to meet stated metrics, including data/plan mapping, verification of manual data loads, and investigation and resolution of client issues.
• Keep the Manager, Assumed Admin - NAL informed of ongoing work activities and any unusual circumstances to ensure quality and timely deliverables.
• Develop a robust understanding of reinsurance concepts, principles, and treaty language.
• Identify opportunities for process improvement, initiate internal reports, and create efficiencies to improve data quality.
• Assist other teams within North American Life Operations and Administration when necessary.
• Communicate with clients to facilitate transmission of monthly data files and address any questions/clarifications regarding data issues with clients.
• Verify that premiums, allowances, and taxes for client policies being assumed are being calculated and billed correctly.
• Create and maintain the ETL scripts used for acquiring, transforming, and loading into PartnerRe systems/tools.
• Liaise with Underwriting for data checking, management reporting, and discussion on results from Audits and for Retro business (including facultative applications).
• Participate in client visits or client audits (desk or on-site) as required.

• Analyze and design management reporting as defined by management.
• Write VBA code, macros, and SQL queries to extract, manipulate, and distribute data.
• Update accounting system with monthly client cashflow accounts vs accounts receivable. Find and correct any discrepancies.
• Create and maintain a rigorous and effective control environment.
• Follow IT change management process.

The successful candidate should be a conscientious individual with exceptional problem-solving skills, a high degree of professional ethics, and intellectual curiosity. In addition, the candidate should possess the right combination of communication skills, an inquiring mind, and creative mindset.

• 1-4 years of experience in a financial institution with some data management expertise.
• Knowledge of insurance industry is a plus.
• Undergraduate or graduate degree in business or STEM disciplines.
• Basic knowledge of audit & quality assurance principles.
• Interpersonal skills and relationship management.
• Proficient in SQL, MS Office.
• Some experience with VBA.
• Some experience with Alteryx is a plus.
• Basic French language skills is a plus.