Hirejobs Canada
Register
Auckland Jobs
Canterbury Jobs
Northland Jobs
Otago Jobs
Southland Jobs
Tasman Jobs
Wellington Jobs
West Coast Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Business Data Analyst - Jobs in Toronto

Job LocationToronto
EducationNot Mentioned
SalaryNot Mentioned
IndustryNot Mentioned
Functional AreaNot Mentioned
Job TypeFull time

Job Description

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

  • 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.
  • 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.
  • Assist internal stakeholders with requests for data, data inquiries, analyze any data discrepancies with supporting documentation.
  • Analyze and design management reporting as defined by management.
  • Write VBA code, macros, and SQL queries to extract, manipulate, and distribute data.
  • 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.
  • Update accounting system with monthly client cashflow accounts vs accounts receivable. Find and correct any discrepancies.
  • Create and maintain the ETL scripts used for acquiring, transforming, and loading into PartnerRe systems/tools.
  • Adhere to all IT controls and security established by IT management.
  • Create and maintain a rigorous and effective control environment. This includes complying with all existing controls and identifying and remediating gaps in our current controls.
  • Follow IT change management process by thoroughly testing all ETL scripts and CRM applications prior to changes being implemented.
  • Liaise with Underwriting for data checking, management reporting, and discussion on results from Audits and for Retro business (including facultative applications).
  • 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.
  • Participate in client visits or client audits (desk or on-site) as required.

APPLY NOW

© 2021 HireJobsCanada All Rights Reserved