Apply on Employer Site

HMSA · 3 hours ago

Underwriting & Actuarial Data Analyst II

Honolulu, HI

Full-time

Hybrid

Mid, Senior Level

$59K/yr - $116K/yr

5+ years exp

HMSA is a healthcare organization that supports the Underwriting and Actuarial departments. The Underwriting & Actuarial Data Analyst II will work independently to analyze data, prepare reports, and provide insights to drive decision-making across the organization.

AssociationHealth CareInsuranceMedical

Responsibilities

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

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