Strategic Planning Analyst

The Strategic Planning Analyst supports strategic planning and business development efforts for the Strategic Planning Department through research, design and production of data analyses, preparation of reports and presentations, and maintenance of data and information. This position provides technical and analytic support for the Strategic Planning Department to assist the Organization in achieving its strategic goals, responding proactively to market opportunities, and complying with regulatory requirements, such as the Certificate of Need process. The Strategic Planning Analyst requires strong qualitative and quantitative skills including statistics, use of analytical tools and planning databases, knowledge of health care planning and marketing, finance and operational data, as well as strong computer skills. This position requires the ability to translate qualitative and quantitative data into actionable information to inform decision-making.

The Strategic Planning Analyst is involved in many areas of the Organization and is responsible for working with Service Line Directors, Department Managers, physicians, and other staff to determine and respond to their information needs. Incumbent works independently, but with some direct supervision from the Manager of Strategic Planning, and must be able to multi-task and prioritize their assignments to meet the Strategic Planning Department and Organizational-wide needs.

• 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 market place and/or determine the demand for health care services within a given market. Assess regulatory and licensure requirements, demographics, market competition, demand forecasts, and physician practice data.

• Monitor and analyze 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.

• Assist the Manager of Strategic Planning with preparation of Certificate of Need applications and all related regulatory requirements.

• Provide support to the Manager of Strategic Planning by preparing 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 Manager of Strategic Planning.

• Develop expertise in both internal (Tableau, Meditech, BI Report Builder) and external (Sg2 Analytics, CHIME Data, CHIME Maps, etc.) data tools. Work collaboratively with Business Intelligence and IT to ensure the completeness and accuracy of internal data feeds sent to outside sources (e.g., CHA, etc.). Run analyses on internal data as needed.

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