Business Data Analyst

About this job:

The Business Data Analyst will be responsible for the analysis, development, and support of all outgoing client data files for processing in PartnerRe systems. Data is produced in various file formats and usually includes transaction, in force, valuation and underwriting files, which have process streams that vary by function.

• Support the PartnerRe monthly retro billing process (including account and data reconciliations, exception handling, account booking).
• Update accounting system to track retro premium and commission accounts. Find and correct any discrepancies.
• Identify/present variances, account trending, premium calculations/verifications and draw conclusions from the findings.
• Ensure monthly retro processing 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.
• Create, maintain and test the ETL scripts used for acquiring, transforming and loading into PartnerRe systems/tools.
• Analyze and design management reporting as defined by management. Write VBA code, macros, an...