The Role
Prepare, clean, and validate data sources; perform descriptive and predictive analyses using statistical and time-series methods; document reproducible workflows; lead project definition and stakeholder meetings; present findings and train others on MicroStrategy and Excel.
Summary Generated by Built In
Job Summary & Responsibilities Preferred Qualifications
- 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.
- Ensures existing, approved, corporate tools used can accept/integrate the data.
- Where necessary (and if practical to be done within the delivery timeframe of a project), facilitates the identification and use of new tools and works with the Technical Review Committee to authorize its use.
- 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.
- Where appropriate, applies linear regression (correlation, contingency table, ANOVA, inference, chi-square, t-test) and/or time series methods (data set-up, conversions, trends, decomposition, models, forecasts, confidence).
- 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.
- Project Definition and Coordination:
- Lead meetings with internal and external customers to clearly articulate and define business problem(s) of medium/high complexity and impact (department/function specific, external customer centric, or part of a corporate project).
- Types of projects include descriptive and predictive analytics.
- Applies a whole company perspective, draws upon previous knowledge and experience, and -- where necessary -- researches new/other approaches to identify and agree upon objectives, approach, and success measures.
- Works with customer to submit appropriate paperwork (ISS, TPDR, etc.) and ensures necessary agreements are in place for external customers.
- Defines delivery milestones and negotiates timeframes, monitors progress, and periodically notifies customer of status.
- Lead meetings with internal and external customers to clearly articulate and define business problem(s) of medium/high complexity and impact (department/function specific, external customer centric, or part of a corporate project).
- Effective Communication:
- Works primarily with department heads or function leads to 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.
- Works primarily with department heads or function leads to prepare/present findings that are informative and audience appropriate
- Performs all other miscellaneous responsibilities and duties as assigned or directed.
- Trains others on MicroStrategy and Excel.
- Functions as a team player within the department and embodies collaboration.
#LI-Hybrid
- Bachelor's degree and four years of related experience or two years of Healthcare Analytics 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
- Bachelor's degree and four years of related experience or two years of Healthcare Analytics experience or equivalent combination
- Strong oral and written communication skills
- Strong understanding of data types, content reliability, and data quality
- Strong problem solving and data collection, analysis, and interpretation skills
- Strong understanding/use of dashboards, data visualization tools, and advanced/custom graphics
- Basic knowledge of Microsoft Office applications (Word, PowerPoint, Excel, Outlook)
- Proficiency with OLAP tools and databases
- Knowledge of one or more: SQL, R, or SAS/SPSS
HMSA Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about HMSA and has not been reviewed or approved by HMSA.
-
Healthcare Strength — Medical and dental coverage are described as solid, with preventive services and select zero‑cost features adding value in recent plan years. Employer-sponsored plans can have affordable premiums in certain groups and broad access options.
-
Retirement Support — A 401(k) with company match and potential discretionary contributions forms a strong component of total rewards. Retirement support complements the core medical and dental package.
-
Leave & Time Off Breadth — Paid holidays and PTO that increases with tenure provide meaningful time‑off flexibility. Time‑away benefits scale with service length.
HMSA Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
The Hawaii Medical Service Association (HMSA), an independent licensee of the Blue Cross and Blue Shield Association, is a reliable name in Hawaii health care. Established in 1938, we are the largest and most experienced provider of health care coverage in the state. Over half of Hawaii’s population have chosen HMSA for their health care coverage. We are dedicated to providing quality, affordable health plans; employee benefit services; and worksite wellness programs. HMSA also offers a variety of programs, services and support to help improve the health and well-being of our members and community.
