Database Analyst

  • 34952
  • Life - Data Science
  • |
  • Florida, United States
  • |
  • Mar 22, 2019
Reinsurance
RESPONSIBILITIES
  • Load Solvency II and IFRS17 actuarial model output provided by business units to the actuarial data warehouse per agreed to quarterly deadlines.
  • Validate data loads by applying agreed to control procedures.
  • Identify and resolve any data quality issues with business units in a timely manner.
  • Provide clear communication to the uses of the actuarial warehouse data regarding status of data validation.
  • Prepare extracts for loading to home office reporting system and validate reports produced in Microstrategy.
  • Plan, schedule and coordinate the production schedule for Solvency II actuarial model sensitivity projections between the business units, the ERM department and Home Office.
  • Load the actuarial model output provided by business units to the actuarial data warehouse per agreed to semi-annual deadlines.
  • Validate data loads by applying agreed to control procedures.
  • Identify and resolve any data quality issues with business units in a timely manner.
  • Provide clear communication to the uses of the actuarial warehouse data regarding status of data validation.
  • Prepare extracts for loading to home office reporting system and validate reports produced in Microstrategy.
  • Recommend, test, and collaborate with database administrator to implement changes and improvements to data warehouse as needed.
  • Update mapping tables as needed and prepare documentation supporting changes and improvements.
  • Maintain MAR and related control documentation.
QUALIFICATIONS
  • Bachelor's degree in Information Technology or related field.
  • Min GPA 3.5.
  • 1 - 3 years’ min of related experience.
  • SQL or R.
  • Familiarity with databases and data manipulation.
  • Excellent verbal, written and interpersonal communication skills.
  • Strong organizational skills and time management.
  • Excellent analytical and mathematical skills.
  • Ability to work independently with minimal supervision.
  • Proficiency in Microsoft Office Suite.
  • Preferred:
  • Knowledge of insurance terminology and concepts.
  • Actuarial experience.
  • Knowledge of Solvency II, IFRS17 and Internal Capital Model reporting basis.