Sr. Provider Network Analyst
Health New England
- Springfield, MA
- Permanent
- Full-time
- Performs ongoing market analysis using benchmarking across HNE network providers using a standard CMS approach with various types of reimbursement methodologies (DRG, RVUs, ASC, OPPS, AWP & ASP etc.)
- Leverages relationships and collaboration across multiple HNE departments to build a high level of trust and collaboration in report development, analysis, and timely delivery
- Interprets financial, accounting, and contractual information to ensure accuracy of data used in reporting, analysis, contract modeling, and forecasting
- Utilizes software including Amisys, Microsoft (Access, Excel, SQL Server) and/or SAS to perform queries utilizing the data warehouse, to refresh financial models by line of business, individual provider negotiation models, and/or other ad hoc reporting
- Resource for other members of the department/division on data-based business processes and may be responsible for training and guidance of other associates
- Presents data driven financial information and succinctly communicates analytic results to internal and external stakeholders
- Evaluates and researches departmental data needs by engaging stake holders and identifying inefficiencies/waste, risks and key person dependencies
- Identifies areas of opportunity to further enhance financial processes and data mining to better align with the corporate wide strategy of Caring, Simplification, and Affordability
- Identifies major cost drivers and recommends strategies for mitigating the cost drivers
- Continuous education in federal, state, and industry reimbursement and analytic models
- Works in partnership with multiple business areas to create comprehensive documentation (SOPs), training, and identify key dependencies and needs for Provider Network planning, strategy, and operations.
- Generates reports used to analyze network adequacy, perform gap analysis and support design & construction of optimally-sized networks meeting all state and federal regulatory requirements
- Communicates to stakeholders and leadership on project status, outcomes, and improvements
- Provides ad-hoc reporting and analysis for financial, governmental, pharmacy, and administrative data used in strategic decision making
- Understanding and competency with Quest Analytics for network adequacy and accessibility analysis reporting
- Familiarity with Massachusetts All Claims Payer Database and ability to retrieve strategic data from this database and other external reference sources
- Performs sensitivity analysis to identify risk/exposure associated with payment changes
- Bachelor's degree required
- Three to five (3 to 5) years of similar experience
- Minimum of two (2) years of health care experience
- Experience in Provider Network Management preferred
- Previous experience in data analysis and reporting using SAS / SQL, Python, Excel, and Access preferred
- Effective at managing competing priorities and can work independently with little oversight. Ideal candidate will be self-motivated and self-starting
- Strong analysis, critical thinking, and troubleshooting skills
- Strong knowledge of Managed Care lines of business including Commercial, Medicaid, and Medicare Advantage
- Significant experience with data interpretation, analysis and reporting using a variety of analytic tools.
- Experience with both financial and clinical data, and with the complexities of models for various types of provider payment methodologies, Quality Improvement metrics, and value based risk contracts
- Experience with allocations and ratios, product mix, and risk adjustment concepts
- Experience with SQL and/or SAS. Ability to write and run complex queries is required for this position.
- Analytical and detail oriented, Audit-minded thought process
- Advanced knowledge of Excel functions, formulas, charts and pivot tables is also required
- Knowledge in dashboard applications such as Power BI, Tableau, etc. is strongly preferred.
- Ability to work multiple projects at one time and meet tight deadlines
- Ability to work independently as well as part of a team
- Excellent oral, written, and communication/presentation skills