Underwriting & Actuarial Data Analyst I
Hawaii Medical Service Association · Honolulu, Hawaii, United States ·
- Category
- Data analytics
Entry-level data analyst on the underwriting and actuarial team at a Hawaii health insurer. Day to day: sourcing, cleaning, and validating data; performing descriptive, predictive, and prescriptive analyses using statistical methods; and building and maintaining self-service and ad hoc reporting tools for internal and external customers.
- 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.
- Reviews data sources and preps needed 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.
- Performs required analysis, applies accepted statistical methodologies where applicable, and documents the process that was followed, and data sources/tools used.
- 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
- Participates in the development and delivery of analytics/reporting tools for internal and external customers.
- 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.
- Prepare/present findings that are informative and audience appropriate.
- Performs all other miscellaneous responsibilities and duties as assigned or directed.
#LI-Hybrid