Underwriting & Actuarial Data Analyst I jobs in United States
cer-icon
Apply on Employer Site
company-logo

HMSA ยท 8 hours ago

Underwriting & Actuarial Data Analyst I

HMSA is seeking an Underwriting & Actuarial Data Analyst I to support their Underwriting and Actuarial departments. The role involves working independently with customers to analyze data, apply statistical methodologies, and present findings to drive decision making across the organization.

AssociationHealth CareInsuranceMedical

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

Qualification

Data analysisStatistical methodologiesSQLData visualization toolsOLAP toolsMicrosoft OfficeCommunication skillsProblem solving

Required

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

Company

HMSA is an insurance company that provides affordable health plans, employee benefits services and worksite wellness programs.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Rick Hopfer
Chief Information Officer
Company data provided by crunchbase