Underwriting & Actuarial Data Analyst II at HMSA in Honolulu, HI

Job description

• **Hybrid Work Environment - Must reside on Oahu **
• Pay Range: $59,000 - $116,000, position is eligible for an incentive bonus
• Note: Individuals typically begin between the minimum to middle of the pay range

Responsibilities

• 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.
• 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.
• 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
• 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.

Requirements

• Bachelor's degree and five (5) years of related experience; or an equivalent combination of education and related work experience.
• Strong oral and written communicate 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 but not limited to Word, PowerPoint, Excel, and Outlook.
• Proficiency with OLAP tools and databases.
• Knowledge of one or more of the following: SQL, R or SAS/SPSS

Skills

Required

• Effective Communication
• Dashboards
• Data visualization tools
• Advanced and custom graphics
• OLAP tools
• Databases
• SQL
• R
• SAS/SPSS