Oswald Companies needs a professional to support health and welfare clients in the Group Benefits department by conducting data analysis, preparing analytics and financial deliverables, and contributing to special projects within the Analytics Team.
Requirements
- Prior experience gathering, manipulating and deciphering data required
- Prior analytical and research experience required
- Experience with data analysis
- Experience with financial analysis
- Experience with benchmarking resources and tools
- Experience with data analytics systems, software and tools
- Experience with databases (e.g. HDMS)
Responsibilities
- Accesses the data of existing clients to conduct financial analyses of relevant information to aid in the evaluation of plan performance, both current and projected experience.
- Analyzes data to identify plan utilization, financial trends and comparative industry benchmarks in order to provide a basis for preparing financial projections, utilizing benchmarking resources and tools, developing COBRA rates and making recommendations for plan design modification.
- Maintains client-specific access to carrier websites and any third-party databases (e.g. HDMS) to generate and download reports, translates information into our internal client report template, reviews the output for reasonableness and accuracy, and delivers the analysis for peer review, including an overview of critical observations.
- Assists in the onboarding of new clients, which includes collaborating with internal staff to understand client needs, scheduling required events and reporting activities, working with carriers to obtain information access for client-specific data analysis, and setting up the appropriate templates.
- Proficient in the use of Oswald Companies software data analytics systems, software and tools to maximize personal effectiveness.
- Collaborates with Systems Analysts to ensure complete and timely information is submitted for new client implementations, carrier changes, and ongoing maintenance of accounts in the data warehouse and other Analytics systems. Audits data to ensure data integrity and works with Systems Analysts to resolve any issues.
- As assigned, assesses provided data of prospective clients to conduct a financial and demographic, current-state analysis to promote client awareness with the objective of securing new business.
Other
- Responsible for supporting health and welfare clients in the Group Benefits department through data analysis, preparation of analytics and financial deliverables, and special projects with the Analytics Team.
- Maintains the security of client information obtained from all applicable benefit lines of coverage in compliance with HIPAA requirements.
- Collaborates with the service team and other Analytics team members to review client-specific data analytics; works closely to identify and develop solutions to minimize risk and maximize cost effectiveness.
- Provides internal teams with accurate deliverables in a timely fashion to meet client expectations; maintains a concise and consistent level of communication with all involved team members.
- Collaborates with other Data Analytics team members to share knowledge and contribute to the design and utilization of client deliverables; remains current on compliance regulations and incorporates that knowledge into existing data analytics tools; builds team synergy for department effectiveness.
- Prioritizes and manages workload effectively, thinks through issues and determines alternative solutions to meet deadlines and improve personal productivity.
- One to three years or more related experience or the equivalent combination of education and experience.
- Prior experience working in a group benefits environment preferred
