Strategic Intelligence Consultant III

Yale New Haven Health; New Haven (CT); On-site; USD 90,000 - 130,000; Full time

Job summary

Yale New Haven Health seeks an experienced healthcare analytics professional to support efficiency initiatives and cost savings across the system. The role involves designing analyses, dashboards, and reports, and collaborating with Strategy Management to inform strategic decisions.

The ideal candidate has 5–6 years in healthcare analytics, strong Excel/SQL skills, and proficiency with Tableau and Power BI.

Qualifications

• Master's degree in Business Analytics, Computer Science, or Information Management (or equivalent).
• 5–6+ years of professional healthcare analytics experience preferred.
• Experience with large datasets, predictive forecasting, and reporting.

Responsibilities

• Develop dashboards and visualizations in Tableau and Power BI for the Office of Strategy Management and senior leadership.
• Collaborate with SI consultants and other teams to support data-driven decision making.
• Create reports for program planning, market analyses, and business development.

Skills

Analytical thinking

Communication

Problem solving

Team collaboration

Education

Master's degree in Business Analytics

Bachelor's degree plus experience considered

Tools

SQL

Tableau

Power BI

Excel

Access

Maptitude

Job description

Overview

To be part of our organization, every employee should understand and share in the YNHHS Vision, support our Mission, and live our Values. These values - integrity, patient-centered, respect, accountability, and compassion - must guide what we do, as individuals and professionals, every day.

Responsible for supporting projects and initiatives designed to improve efficiency and/or achieve cost savings across Yale New Haven Health System (YNHHS). Accountable for the accuracy and timeliness of department deliverables using multiple internal and external databases, benchmarking, forecasting and financial systems. Supports the Office of Strategy Management and System Strategy through the development of in-depth market assessments, profiles, and analysis. Develops integrated analysis of national, state, and local healthcare trends and proactively identifies and proposes strategy refinements because of market conditions. Responsible for the design and maintenance of databases and software programs, analysis design and visualizations while adhering to project timelines. Develops expertise related to all relevant data sources. Demonstrates complex problem-solving ability and ability to improve processes. Serves as a role model, cultivates innovation, creates compelling data presentation, is considered a subject matter expert, and can manage change in a fast-paced environment. Manages assigned data projects from discovery phase through implementation. Participates on Strategic Intelligence Team in delivering high-quality, actionable information to the organization that informs strategic decision-making and enhances the organization's IQ.

EEO/AA/Disability/Veteran

Responsibilities

• Works with departmental resources and identifies areas of opportunity for improvement. Develops qualitative, quantitative, and visual analysis to support recommendations.


• Uses critical thinking for in-depth analysis and data visualizations.


• Cultivates innovation and motivates others through expertise and understanding of the Office of Strategy Management.


• Coordinates with SI (Strategic Intelligence) consultants on the development and/or support of automated and manual systems; provides technical guidance in analytical tasks.


• Works in collaboration with the other team members to provide dashboards for key service lines/new projects and drive utilization of dashboards.


• Provides project management tools to meet the data needs of department and create standardization creating global definitions and data request protocol.


• Participates in determining the nature and scope of project activities and processes to be developed or modified.


• Creates various reports for program planning, strategic and market analyses, and business development.


• Analyzes reports to assess impact on clinical programs, business planning and System strategy. Reviews reports with internal team members to ensure they can be presented to an executive level audience.


• Develops comprehensive market-based and clinical program-specific market overviews using inpatient state data sets and internal organizational data to identify trends, changes, developments, and other key conclusions.


• Coordinates comprehensive data interpretation to support senior level decisions regarding strategic clinical program and other initiatives.


• Drives results through subject matter expertise on understanding the healthcare business.


• Effectively interfaces and coordinates with other individuals to integrate and understand data from other information systems internally and externally.


• Serves as a role model and ensures accountability of junior team members.


• Builds dashboards and other analysis through Tableau and PowerBI for use by the OSM (Office of Strategy Management) (Office of Strategy Management) (Office of Strategy Management) team and Senior leadership.


• Supports the development of dashboards to visualize and automate display of data to be updated regularly.


• Participates in Regulatory processes, supports state Senate bills, surveys, and research across YNHHS.


• Performs other job responsibilities as assigned or requested.

Qualifications

EDUCATION

• Master's degree in Business Analytics, Computer Science, or Information Management. Bachelor's degree and an equivalent combination of education and experience may be considered in place of an advanced degree.

EXPERIENCE

• A minimum of five (5) to six (6) years of professional experience preferred in healthcare analytics.


• A minimum of five years professional analytics work experience is required.


• Experience working with large datasets, data analysis, predictive forecasting modeling, and reporting required.


• Candidate must demonstrate strong aptitude in Microsoft Excel (specifically, Pivot and Vlookup tables). SQL, Tableau, cloud based environments, programming, querying, Power BI and Microsoft Access a plus.

SPECIAL SKILLS

• Strong analytical and quantitative skills are required.


• Ability to work in a fast-paced environment and deliver accurate, high-quality data.


• Ability to conduct diverse types of analysis including process, marketplace, physician, organizational and operational.


• Excellent verbal and written communication skills.


• Proficient with computer information systems, data manipulation and reporting, demographics, such as Maptitude or other mapping software, inpatient and outpatient calculators/forecasters, pivot tables, Microsoft SQL, Tableau, Word, Excel, Access, and PowerPoint.

PHYSICAL DEMAND

• Must be able to travel to various sites across the health system.