Job Location
Remote Work Policy
In office
Visa Sponsorship
Not Available
RelocationAllowed
Skills
Python
Data Warehousing
Excel
R Studio
Data Validation
Benchmarking
Data Management
Microsoft Power BI
Statistical tools
Visualization Tools
Analytical tools
Data Collection Procedures
Data Exchanges
Financial Funding Analysis
Renewal Rate Projections
IBNR Reporting
About the job
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Data Management
- Implement strategies and standards to improve data warehousing and reporting processes.
- Manage data collection procedures across clients, vendors, and team members.
- Facilitate data exchanges between carriers and vendors.
- Create and execute data validation and auditing practices to ensure data quality.
- Analysis
- Organize and sort complex datasets.
- Analyze and interpret trends using statistical and visualization tools (Excel, Microsoft Power BI, R Studio, Python, etc.)
- Conduct health plan analytics, including:
- Claims utilization, trend, and lag analyses
- Rate and contribution analysis
- Financial funding analysis
- Renewal rate and funding projections and modeling
- Benchmarking
- IBNR reporting
- Utilize analytical tools to develop alternative strategies, plan modeling, and cost reduction opportunities.
- Perform technical analysis of group insurance contracts and financial arrangements.
- Reporting
- Translate analysis into clear and compelling dashboards, presentations, and reports.
- Assist in the development of actionable, non-technical recommendations based on analytical insights.
- Prepare ad hoc reports for client teams and clients.
- Meet with clients to discuss quantitative reports.
- Perform other tasks as assigned by management.
EDUCATION AND/OR EXPERIENCE
- Bachelor's degree in a related field.
- 5+ years of related experience in data analytics, underwriting, and/or benefit design.
- Equivalent combination of education and experience.
