The Business Insights Analyst is responsible for providing data support to the Strategic Services Department and key organizational decision makers. Responsibilities include the creation and management of accurate, complete and reliable databases and forecasting tools necessary to provide the information used in strategic business decisions and community health. This position will be required to understand the fundamental structure of databases and have a working knowledge of excel and other programs used to manipulate, organize, and present data and information in a meaningful and informative manner. Further, this position requires the ability to interact with various levels of the organization in order to assist in the interpretation and use of that data, as well as with contacts from various third party or government organizations, and external agencies that provide data to the system.
Core Job Responsibilities
Use software programs (e.g., Excel, Access, Tableau, Power BI) designed to extract, manipulate, compile and organize database information
Visually show insights with data visualizations, which may include Excel graphics, PowerPoint graphics, Think-Cell, Power BI, Tableau, Maptitude, etc.
Maintain the Annual Operating Plan (AOP) functionality and monthly data input reminders
Build AOP goal templates in Leader Evaluation Manager (LEM) and translate AOP reporting to LEM as needed. Become an expert on LEM functionality and AOP goal development given LEM reporting capabilities.
Obtain and maintain market data available from South Carolina Revenue and Fiscal Affairs
Maintain Tableau databases of market and internal data
Update market assessments in support of business development and service line planning
Update and maintain annual releases of demographics data as well as provide demographic information as requested
Develop data in compliance by DHEC guidelines: Certificate of Need (CON) Applications, Joint Annual Reports (JAR’s)
Continuous education to become an expert on market demand forecasting assumptions and impact factors by site of care
Scrub Sg2 workforce supply and demand database, assist in workforce analysis, and maintain supply database
Provide data support/analysis and recommendations to consultants on various types of projects
Continuing education to maintain proficiency in mapping software, state data, data visualization, and outside analytical tools (e.g., Sg2)
Support Community Health initiatives
Plan and execute projects related to community and under served population health management tools, primary care access systems, and innovative managed population payment models
Identify disparities in internal hospital data for emergency room visits and frequency of inpatient admissions
Drive to data-driven insights to identify community needs and provide justification for future initiatives, partnerships, and programs
Support partnership with the Road to Better Health to develop a community needs assessments, including research and comparative analyses to like regions
Estimate return on investment for community health interventions
Drive to insights through analysis of AccessHealth’s Care Scope care management database.
Must possess excellent communication, organization, and analytical skills
Strong Microsoft Office skills (Excel, PPT, Access) required
Degree in business, healthcare or quantitative field
2 years minimum experience in data analysis, preferably health care
Internal Number: 31549
About Spartanburg Regional
Spartanburg Regional is an integrated healthcare system that provides care from birth to hospice. As a a partner with the community for 90 years, we have earned a reputation for technological excellence. With more than 5,600 employees, Spartanburg Regional prides itself in being one of the most recognized healthcare facilities in Upstate South Carolina. A long list of accolades and accomplishments keep our employees proud. We believe the pride and quality in our organization is the result of a focused effort of our staff and resources.