Strategic Intelligence Consultant III

Yale New Haven Health • New Haven, CT

1d

About The Position

The Strategic Intelligence Consultant III supports projects and initiatives designed to improve efficiency and achieve cost savings across Yale New Haven Health System (YNHHS). The role is accountable for accurate, timely department deliverables using internal and external databases, benchmarking, forecasting, and financial systems. It supports the Office of Strategy Management and System Strategy by developing in-depth market assessments, profiles, and analyses; integrating national, state, and local healthcare trends; and identifying and proposing strategy refinements in response to market conditions.

The position designs and maintains databases and software programs, develops analysis and visualizations, and meets project timelines. It manages assigned data projects from discovery through implementation, develops expertise in relevant data sources, and applies complex problem-solving and process-improvement skills. As a member of the Strategic Intelligence Team, the consultant delivers actionable information to inform strategic decisions and enhance organizational insight. The role also serves as a subject matter expert and role model, cultivates innovation, presents data compellingly, and manages change in a fast-paced environment.

Requirements

• At least five years of professional analytics work experience.
• Experience working with large datasets, data analysis, predictive forecasting models, and reporting.
• Strong aptitude in Microsoft Excel, specifically Pivot and VLOOKUP tables.
• Strong analytical and quantitative skills.
• Ability to work in a fast-paced environment and deliver accurate, high-quality data.
• Ability to conduct process, marketplace, physician, organizational, and operational analyses.
• Excellent verbal and written communication skills.
• Proficiency with computer information systems, data manipulation and reporting, demographics, mapping software such as Maptitude, inpatient and outpatient calculators or forecasters, pivot tables, Microsoft SQL, Tableau, Word, Excel, Access, and PowerPoint.
• Ability to travel to various sites across the health system.

Nice To Haves

• SQL, Tableau, cloud-based environments, programming, querying, Power BI, and Microsoft Access experience are considered a plus.
• Five to six years of professional experience in healthcare analytics is preferred.

Responsibilities

• Work with departmental resources to identify opportunities for improvement and develop qualitative, quantitative, and visual analyses to support recommendations.
• Use critical thinking to conduct in-depth analysis and develop data visualizations.
• Cultivate innovation and motivate others through expertise and understanding of the Office of Strategy Management.
• Coordinate with Strategic Intelligence consultants on developing or supporting automated and manual systems, and provide technical guidance on analytical tasks.
• Collaborate with team members to provide dashboards for key service lines and new projects and encourage dashboard utilization.
• Provide project management tools to meet departmental data needs and standardize global definitions and data-request protocols.
• Participate in determining the nature and scope of project activities and processes to be developed or modified.
• Create reports for program planning, strategic and market analyses, and business development.
• Analyze reports to assess impacts on clinical programs, business planning, and System strategy; review reports with internal team members to ensure they are suitable for executive audiences.
• Develop market-based and clinical program-specific market overviews using inpatient state datasets and internal organizational data to identify trends, changes, developments, and conclusions.
• Coordinate data interpretation to support senior-level decisions about strategic clinical programs and other initiatives.
• Apply healthcare business subject matter expertise to drive results.
• Coordinate with others to integrate and understand data from internal and external information systems.
• Serve as a role model and ensure accountability among junior team members.
• Build dashboards and other analyses using Tableau and Power BI for the Office of Strategy Management team and senior leadership.
• Support development of dashboards that visualize and automate regularly updated data displays.
• Participate in regulatory processes and support state Senate bills, surveys, and research across YNHHS.
• Perform other job responsibilities as assigned or requested.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level