Strategic Planning Analyst

Major Accountabilities/Critical Responsibilities

• Compile, organize, format, analyze, interpret, report and present data to inform strategic planning, business/program development, and other informational needs of the Strategic Planning Department and the Organization.
• Prepare draft of narratives, research materials, tables, analyses, and other materials for review and inclusion in written planning documents.
• Provide timely and accurate analyses for all projects assigned.
• Support the planning, development, and execution of short and long-term strategic initiatives across the organization through program/initiative management, meeting facilitation/leadership, document development, and analytical support.
• Utilize market data systems (such as CHIME, Sg2, and Marketware) and develop new and creative methods and analyses to help solve complex problems and improve the analytical efficiency of the Strategy and Business Development function.
• Design routine and custom reports such as market share, patient origin, utilization trends, physician utilization, network integrity, demographics, and forecasts and projections.
• Manage requests for new reports as well as modifications to existing reports in a timely manner.
• Design and prepare standard on-going reports, Executive-level presentations, and ad hoc analyses.
• Conduct project specific research to better understand the marketplace and/or determine the demand for healthcare services within a given market.
• Assess regulatory and licensure requirements, demographics, market competition, demand forecasts, and physician practice data.
• Maintain awareness of internal and external environments and identify trends and opportunities for consideration.
• Continually monitor healthcare news, research articles, and attend industry meetings as appropriate and proactively share internal and market insights with team members, executive leadership, service line administrators, operations, and clinical staff through quarterly reports, presentations, memos, newsletters, white papers, etc.
• Identify and compile competitive business intelligence.
• Select and use appropriate methodologies for decision making.
• Select data from a variety of sources to fulfill business needs by extracting key pieces and relating them to the specific project.
• Provide data and reporting to comply with regulatory requirements, such as the Certificate of Need process and the CT Office of Health Care Access and Department of Public Health requests.
• Actively monitor CON filings by other hospitals (in Connecticut and New York) and other important state regulatory activity.
• Auxiliary responsibilities include assisting the Director of Strategy with preparation of Certificate of Need applications and all related regulatory requirements.
• Prepare data analyses and documentation to facilitate the development of strategic and business plans, feasibility studies, and various programmatic initiatives, and to respond to requests from consultants.
• Work collaboratively with Analytics and Innovation, Information Technology, Finance, and other applicable departments in the Organization to provide requested information to Service Line Directors, Strategy and Marketing Department staff, Department Managers, physicians, and other staff in the Organization, and consultants, as directed by the Director of Strategy.

Qualifications/Requirements

• Bachelor’s degree required, Master’s Degree Preferred, preferably in Business Administration, Health Care Administration, Market Research, or Statistics.
• Knowledge and experience in health care planning and marketing, and hospital/health system finance and operational data, as well as strong computer skills and complex statistical and data analytical skills required.
• Other Requirements: Strong data analysis skills as well as experience working with large volumes of data in MS Excel, Tableau 2+ years of job-related experience in a health care provider or health plan setting Knowledge and experience in hospital/health system data (e.g., MSDRG, ICD & CPT codes) Ability to apply critical thinking and problem-solving skills to work through complex situations Experience in the preparation of statistical and descriptive reports Effective oral, written, and documentation skills Excellent communication and presentation skills Eagerness and ability to learn and contribute to as a team player High degree of personal initiative with adaptability to manage multiple projects with changing priorities Ability to build relationships with and work effectively with colleagues at all levels, both administrative and clinical, internal and external Innovative thinker and self-starter Strategic planning background a plus Curiosity and willingness to learn Ability to encourage and foster creativity in the team Computer Skills Required Must be proficient in: Microsoft Word, Excel, Power Point, and Adobe Acrobat Chime databases (e.g. Decision Support Tool; Physician Performance, Chime Maps, Patient Census Report) Sg2 and other forecasting software Use of spreadsheet tools, database management, and presentation tools Knowledge of and experience working with statistical and data warehousing/reporting systems