Job Description: General Summary: Provides analysis of healthcare industry and market trends, Medical Center and competitor volumes and market share, demographic analyses of target patient populations and prepares reports for managers of results of analysis. Develops periodic reports for strategic planning and monitoring purposes. Assists in preparation of Certificate-of-Need applications. Serves as a technical expert on planning and competitive information sources, volume analysis and facility forecasting.
Principal Duties and Responsibilities:
1. Serves as programmer/model developer for major analytical and forecasting projects, working closely with the Director and Project Manager.
2. Provides various ad hoc analytical services, including volume and market share reports for program committees, physician leaders and managers. This may also include requests for maps and demographic data. Serves as in-house resource on the use of mapping software for strategic planning purposes.
3. Provides advice and support on difficult analytical and process issues to assist the service line administrators and other colleagues in moving their group processes forward.
4. Assists the Project Manager, Director and Associate Vice President in managing the technical and analytical workflow of the department, providing guidance on the organization and management of information on our department server and the organization of templates and models in use.
5. Supports the annual baseline volume projection process as part of the annual budget process, preparing historical trend analysis and working closely with Finance/Decision Support staff on department databooks.
6. Compiles information on economic and health care industry trends, compile and analyze demographic, market share, financial and utilization data from internal and external sources to support strategic program planning.
7. Assists the Project Manager in the completion of annual surveys (IDPH, AHA, Crain's) with Information Services and Finance staff.
8. Assists in the facility planning process and the CON application process by developing utilization trends and bed need forecasts as well as population projections.
9. Serves as a technical liaison with outside data vendors regarding data content and accuracy.
10. Assists with special studies and CEO Council and Board documents in collaboration with the Senior Vice President, Associate Vice President, Director and Project Manager.
Knowledge, Skills and Abilities:
A Bachelors Degree or two years of relevant work experience. Course work desirable in at least some of the following: microeconomics, statistics, computer programming, accounting and finance. Healthcare-related analytical work experience desirable. Knowledge and experience in the health care field are highly desirable. Requires strong interpersonal and communication skills, both written and oral.
Knowledge and experience with database software programs such as Access and advanced skills in Excel and PowerPoint required in order to effectively conduct complex analyses of market and competitive information as well as clinical patient-level analyses. Financial analysis and modeling/forecasting experience are highly desirable.
