Underwriting & Actuarial Data Analyst II

hmsacareers; Honolulu (HI); On-site; USD 90,000 - 120,000; Full time

Job summary

HMSA Careers in Honolulu seeks a data analytics professional to manage data sources, prep datasets, and ensure data quality for analysis and reporting.

The role defines analytical frameworks (descriptive, predictive, prescriptive), collaborates with customers, and delivers self-service dashboards, with a strong emphasis on communication, documentation, and training on new tools.

Qualifications

• Bachelor's degree and five (5) years of related experience; or an equivalent combination of education and related work experience.
• Strong oral and written communication skills.
• Strong understanding of data (types, content reliability, etc.).
• Strong problem solving and data collection, analysis, and interpretation.
• Strong understanding/use of dashboards, data visualization tools, and advanced and custom graphics.
• Basic knowledge of Microsoft Office applications, including Word, PowerPoint, Excel, and Outlook.
• Proficiency with OLAP tools and databases.
• Knowledge of SQL, R or SAS/SPSS.

Responsibilities

• Lead data management efforts by reviewing sources, prepping data, and communicating risks and limitations to stakeholders.
• Perform analyses using appropriate statistical methods; document process, data sources, and tools used.
• Develop and deliver analytics/reporting tools for internal/external customers; define milestones and provide training.
• Prepare/present findings, ensure business problems are met, and document the analysis for stakeholders.

Skills

Communication skills

Data understanding

Problem solving

Dashboards / Data viz

MS Office

OLAP tools

SQL / R / SAS

Education

Bachelor's degree + 5 years experience

Tools

MS Excel

Power BI

SQL

R

Job description

1. Data Management:
   
   • Reviews data sources and preps needed data. Identifies and communicates issues, limitations, and risks with data sets/reports.
     
     • Identifies existing and new data sources.
     • Performs data prototyping, if necessary, to agree what data can/not be used.
     • Preps data for use in analysis, goes back to source if problems are found, and identifies other options/alternatives if problems cannot be resolved.
     • Performs review of data to ensure completeness/accuracy/timeliness for the purpose of the analysis.
     • Maintains tables that are necessary for department or corporate reporting.
     • Ensures existing, approved, corporate tools used can accept/integrate the data.
     • Works with external data contacts to resolve issues related to the delivery or receipt of data.
2. Analytics and Technical Acumen:
   
   • Performs required analysis, applies accepted statistical methodologies where applicable, and documents the process that was followed, and data sources/tools used. Consults with customers on the appropriate analytical approach, identifies benefits/risks, and makes appropriate suggestions to arrive at the desired outcome.
     
     • Determines what kind of analytics will be performed (descriptive, predictive, prescriptive) and defines/documents overall framework.
     • Understands various internal and external data sources available; uses expertise to utilize the most appropriate data source.
     • Utilizes appropriate tools to load, integrate, and analyze data.
     • Conducts analysis and documents findings, identifies unexpected anomalies and root cause (if possible) and determines if analysis can continue, identifies alternatives if anomalies cannot be resolved.
     • Ensures reproducibility of outcomes.
     • Documents entire analysis process, including business problem, data sources, methods and tools used, project reference, and outcomes.
     • Implements pre-emptive actions, where possible.
     • Gains the needed skills/knowledge when new technologies arrive and provides translation between old and new.

Analytics/Reporting Tool Development & Training

Lead in the development and delivery of analytics/reporting tools for internal and external customers.
Types of projects include the development, maintenance, and enhancements of self-service reporting tools and regular or ad hoc reporting.
Applies a whole company perspective, draws upon previous knowledge and experience, and -- where necessary -- research new/other approaches to identify and agree upon objectives, approach, and success measures.
Gathers customers requirements and translates them into actionable analytics and reporting tools.
Defines delivery milestones and negotiates timeframes, monitors progress and periodically notifies customer of status.
Provides training to customers on new tools/reporting capabilities

Effective Communication

Prepare/present findings that are informative and audience appropriate.
Reviews findings and outcomes with customer, ensures business problem/objectives have been met, and prepares documentation of the analysis.
Where necessary, manage divergent views in the audience and advises the internal/external customer on any recommendations or options that will facilitate data and analysis driven decision making.
Prepares a presentation of the analysis, process followed and reviews it with the customer to ensure the results are audience appropriate.
Performs all other miscellaneous responsibilities and duties as assigned or directed.

1. Bachelor's degree and five (5) years of related experience; or an equivalent combination of education and related work experience.
2. Strong oral and written communicate skills.
3. Strong understanding of data (types, content reliability, etc.).
4. Strong problem solving and data collection, analysis, and interpretation.
5. Strong understanding/use of dashboards, data visualization tools, and advanced and custom graphics.
6. Basic knowledge of Microsoft Office applications. Including but not limited to Word, PowerPoint, Excel, and Outlook.
7. Proficiency with OLAP tools and databases.
8. Knowledge of one or more of the following: SQL, R or SAS/SPSS