Lead Healthcare Data Analyst

As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care, and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.

We're focused on a people-first culture for our system's patients and our professional family. That's why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees' personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development-and we recognize success at every step.

Our employees use the Mass General Brigham values to govern decisions, actions, and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.

General Summary/Overview

The Lead Data Analyst Consultant, within the Mass General Brigham Enterprise Analytics (EA) Department, is responsible for identifying, querying, analyzing, and visualizing data through reports and presentations, a variety of data to support operations, quality and performance measurement initiatives throughout Mass General Brigham, including its acute and specialty hospitals around greater Boston. The Lead Data Analyst Consultant will be responsible for providing analytics insights to leadership at various levels within the organization. The position requires close collaboration and dialogue with clinical personnel, various analytic groups, and hospital and system leadership.

The Enterprise Analytics Department supports data and reporting across most domains of the hospital operations and could include areas such as patient satisfaction, patient safety, clinical outcomes, asset utilization, and more. The successful Lead Data Analyst Consultant will create lasting relationships with hospital leadership by becoming the go-to expert for data within his or her designated areas of expertise, as well as helping other team members develop to do the same. Regular responsibilities include gathering requirements, performing qualitative and quantitative analyses, finding and querying complex data, and sharing data and results in a digestible, visually appealing, way.

In addition, the Lead Data Analyst Consultant will serve as a resource and role model for other data analyst consultants, developing and sharing best practice methodologies, training other analysts and end-users, and growing the team's wealth of knowledge and documentation. The team mainly relies on Snowflake, Tableau, the Microsoft Office suite, and is partnering with the MGB Digital data platform teams on a journey to build a new data platform with Microsoft Azure Cloud and Snowflake, and leverages other tools and technologies on an as needed basis.

Position Summary:

The Lead Healthcare Data Analyst will support MGB's Enterprise Asset Management (EAM) program along with other enterprise level efforts. The Lead Data Analyst will partner with other members of the Enterprise Analytics team to address the priorities and needs of various operational domains - such as Emergency Medicine, Behavioral Health, Post Acute, and others as assigned. The Lead Data Analyst will be the go-to expert for data and analytics in one or more assigned domains. The position requires close collaboration and dialogue with clinical personnel, various analytic groups, and hospital and system leadership.

Principal Duties and Responsibilities

1. Elicits data and reporting requirements from hospital leadership, clinicians, and other staff, using interviews, document analysis, requirements workshops, site visits, use cases, scenarios, data analysis, task, and workflow analysis.

2. Queries and analyzes data from hospital systems such as our electronic medical record system (Epic), enterprise data warehouse (EDW), external websites, and more, to glean meaningful insights and produce actionable reports for internal customers.

3. Presents data and analyses to key stakeholder groups and leadership at both hospital and enterprise executive levels, including creating materials for and giving presentations as needed.

4. Works with EA and Digital staff in design, maintenance, and distribution of reports while also overseeing ad hoc data analyses and new report development as needed.

5. Works with EA and Digital staff to continually improve our analytical capabilities with SQL, Tableau, and other analytic platforms, which includes but not limited to dashboard and report development, QA of existing reports, and documentation of system functionality.

6. Performs comprehensive quality assurance, ensuring that data and reports meet end user specifications and are accurate and reliable.

7. Works with new and existing EA consultant analysts to share knowledge in methods of data analysis, summarization, and presentation. Trains other analyst consultants and end-users on key analytic and reporting systems and databases.

8. Partner with MGB Digital teams to leverage existing tools, methods, and processes in order to deliver timely information to operations stakeholders across MGB, including Snowflake.

9. Effectively recognizes when additional help or guidance is needed and seeks it out proactively.

10. Represents EA on internal and external committees or task forces as needed.

11. Performs all other related duties as required.

1. Bachelor's degree in management, information systems, statistics, or equivalent experience.

2. At least 8-10 years of experience, preferably in a related analytics position.

3. Healthcare knowledge, particularly as it pertains to electronic medical record data, is greatly preferred but not required.

4. Expertise in relational databases, SQL, data visualization, and Business Intelligence tools such as Tableau.

5. Knowledge and application of statistical analyses including variance analysis and statistical significance preferred.

6. Mastery of knowledge and application of workflows and data structures of at least some of underlying MGB systems, especially Epic. Effective working knowledge of the rest.

7. Experience with Epic Clarity, Caboodle, and/or Cogito a plus

8. Project management skills and/or experience a plus.

9. Proficiency with Microsoft Office Suite, including Word, Excel and PowerPoint.

Skills and Abilities

1. Strong ability to work and communicate effectively with staff at all levels within the organization, including senior hospital and enterprise management.

2. Strong experience with querying, manipulating, cleansing, and statistically analyzing large data sets using tools such as Snowflake or SQL Server Management Studio.

3. Strong proficiency with Excel, manipulating large data sets and synthesizing into digestible information, including polished visualizations.

4. Excellent experience presenting data through the building of dashboards and reports using business intelligence tools such as Tableau (preferred). Independently creates data visualizations that are suitable for presentation to senior leaders.

5. Ability to clearly communicate complex and sensitive data to senior executives as well as peers.

6. Strong written and verbal communication skills, with the ability to tailor message to individuals and audiences throughout the institution.

7. Strong organizational skills, with the ability to focus detailed concentrated effort on multiple projects. Actively participate in setting priorities for the team.

8. Possesses initiative and ability to work independently while thriving in a setting requiring collaboration and teamwork for maximal efficiency and effectiveness.

9. Attention to detail that ensures follow through on all initiatives implemented, and all projects undertaken.

10. Ability to effectively respond to time sensitive issues and meet deadlines.

11. Proactively providers constructive input to more junior team members on all aspects of the job, as appropriate.