Senior Home Hospital Data Analyst

About Us:

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.

The Opportunity:

The Senior 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 Senior 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 Senior 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. 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 Senior Data Analyst Consultant will serve as a resource and role model for other data analyst consultants, 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 Senior Home Hospital Data Analyst specializes in MGB's innovative Home Hospital (HH) program. The Home Hospital program aims to improve the care of patients in their homes while increasing hospital capacity and reducing total costs of care. The Sr Data Analyst will partner with other members of the Enterprise Analytics team to represent the priorities and needs of the Home Hospital site operation teams and will be the go-to expert for data in the Home Hospital domain. 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 hospital leadership, 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 Snowflake, 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.

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

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

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

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

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

Knowledge and application of workflows and data structures of underlying MGB systems, especially Epic, preferred.

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

Project management skills and/or experience a plus.

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 management.

2. 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. Strong experience presenting data through the building of dashboards and reports using business intelligence tools such as Tableau (preferred). With limited input from others, 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 and re-establish priorities as necessary.

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.

Working Environment

* The EOI's main office is in Somerville, MA, the team includes local members. It is important to note that we do expect local Data Analyst team members to be able to work in-person twice a week, mostly for the purpose of presentations to senior leaders. As of this writing there is not a regular cadence to such presentations. We are committed to building an engaged, inclusive community and offer a variety of opportunities to come together virtually to facilitate learning and collaboration.