Underwriting & Actuarial Data Analyst I

Hawaii Medical Service Association; Honolulu (HI); Hybrid; USD 59,000 - 116,000; Full time

Benefits offered by this job

Incentive bonus

Job summary

Hawaii Medical Service Association is seeking a data analytics professional to support underwriting and actuarial teams. You will review data sources, prep data, perform analyses using statistical methods, and present findings to drive decisions.

The role emphasizes dashboards, data visualization, and training internal customers, with hybrid work on Oahu. The candidate should have a degree plus several years of related experience and strong communication skills, along with proficiency in SQL or

Qualifications

• Bachelor's degree and four years of related experience, or equivalent.
• Strong oral and written communication skills.
• Strong understanding of data types and data reliability.
• Strong problem solving and data collection, analysis and interpretation.
• Strong understanding/use of dashboards and data visualization tools.
• Proficiency with Microsoft Office (Word, PowerPoint, Excel, Outlook).
• Proficiency with OLAP tools and databases.
• Knowledge of SQL, R or SAS/SPSS.

Responsibilities

• Data Management: review data sources, prep data, identify data sources, ensure data completeness/accuracy/timeliness, maintain reporting tables, validate data integration.
• Analytics and Technical Acumen: perform analyses, apply statistical methods, document process and tools, select appropriate analytics, ensure reproducibility.
• Analytics/Reporting Tool Development & Training: develop/deliver analytics tools, self-service reporting, train customers on new capabilities.
• Effective Communication: present findings, ensure objectives are met, document analyses, advise customers on data-driven decisions.
• Performs other duties as assigned.

Skills

Oral communication

Written communication

Data understanding

Problem solving

Dashboards & visuals

Microsoft Office

OLAP tools

SQL knowledge

R or SAS/SPSS knowledge

Education

Bachelor's degree

4+ years related experience

Tools

OLAP tools

Databases

Data visualization tools

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

Works independently with internal and external customers in support of the Underwriting and Actuarial departments to clearly articulate and define business problem(s) to be solved; reviews data sources and preps needed data; performs required analysis; applies accepted statistical methodologies where applicable; documents the process that was followed and data sources/tools used; ensures results have been validated (statistically, if necessary); and prepares/presents findings and or training that are informative and audience appropriate to drive decision making across various levels of the organization.

Minimum Qualifications

• Bachelor's degree and four 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

Duties and Responsibilities

• Data Management:
  • Reviews data sources and preps needed data.
    • 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.
• 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.
    • 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.
• Analytics/Reporting Tool Development & Training:
  • Participates in the development and delivery of analytics/reporting tools for internal and external customers.
    • Types of projects include the development and or maintenance 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.
    • 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.

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact808-948-5588 or via email at [e-mail].

EEO is the Law