View Our Website View All Jobs

Data Analyst

POSITION PURPOSE:

Run monthly key performance indicators and ad hoc reports for operations, actuarial, underwriting, sales and finance. Be expert regarding data sources and reporting. Familiar with report generation using data sets and canned reports in Excel, MS Access, SQL, and Report Builder (SSRS).

ESSENTIAL JOB DUTIES AND RESPONSIBILITIES:

  • Extensive Data Driven Analysis using data warehouse and SQL Server Management Studio
  • Ability to use Visual Studio and Team Foundation Server
  • Ability to use PowerPivot, cubes, and object databases
  • Create, optimize, and automate monthly /weekly reports
  • Interacts with end users (customers) through all phases of report development including requirements gathering and user acceptance testing.
  • Ability to use Excel macros and MS Access databases
  • Assist internal customers, e.g. Actuary /Claims, in creation of data /reports
  • Understand links between the various admin systems
  • Create key performance indicator reports

DESIRED  MINIMUM  QUALIFICATIONS:

  • 5+ years’ experience in data analyst role
  • 2 years of insurance or healthcare expreience
  • Ability to work independently and take ownership of deliverables.
  • Strong analytical and problem solving skills.
  • Flexible and able to adapt to a fast-paced environment.
  • Strong customer service orientation.
  • Ability to communicate analyses and reporting in concise and simple manner
  • Experience working in a team-oriented, collaborative environment.
  • Good  written and verbal skills

Education and Experience:

  • BS in Math or Computer Science or related field

Necessary Knowledge:

  • Create queries using T-SQL
  • Exposed to Task Factory and SSIS Packages
  • Bilingual English/Spanish
  • Create and maintain new reports using Report Builder (SSRS)
  • Excel Advanced (macros), MS Access using ODBC, data warehouses
  • Understanding of direct insurance processes or similar processes, e.g. banking or healthcare, preferred
  • Knowledge of SharePoint 2013 (Dashboard  creation, data sources, PowerPivot  publication)
  • Excellent technical knowledge
Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150