Previous Job
Previous
Data Analyst
Ref No.: 20-02477
Location: Weatogue, Connecticut
Data Analyst

Tailored Management is seeking a Data Analyst to work onsite with a diversified global insurer and the third largest property and casualty insurer in the U.S. Through its subsidiaries and affiliated companies, it offers a wide range of property and casualty insurance products and services to individuals and businesses alike. This company ranks 75th on the Fortune 100 list of largest corporations in the U.S., offering great career opportunities!

Location: Weatogue, CT
Contract Length: 6 Months

Job Duties:
  • Provide reporting and data analysis support for various business partners within North American Specialty.
  • Support data visualization and dashboard efforts across subject areas within the Insurance domain (Submission, Policy/Premium or Claim level analysis).
  • Ability to learn complex data sources and merge data across disparate systems to meet business requirements.
  • Ability to work directly with business users to understand requirements and provide recommendations on how best to display data in a report or visual dashboard.
  • Create standard operating procedures for new requirements and manage the transition to offshore support teams or junior staff.
  • Process change requests on steady state reports with attention to reconciliation expectations.
  • Automate existing manual reports using database and reporting tool functionality.
  • Execute standard testing and reconciliation for new or revised standard reports.
Skills:
  • Advanced understanding of data modeling, table relationships, and query optimization.
  • Ability to own report development effort with minimal supervision.
  • Problem solving; data related trouble-shooting such as identifying reconciliation variances, or determining cause of data anomalies.
  • Expert knowledge of Business Objects, PowerBI, Tableau or similar reporting tool required.
  • Skilled in merging data from multiple disparate sources. Data warehousing experience important.
  • Expert in MS Excel and MS Access
  • VBA knowledge a plus
  • Be able to prioritize based on due dates and task demands.

Experience:
  • 5+ years insurance data experience.
  • 5+ years SQL
  • 5+ years' experience with data warehousing and/or relational databases
  • Finance, Actuarial or Planning data experience is a plus.