Data Analyst II

The Opportunity

The Data Analyst II, 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 Data Analyst II 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 Data Analyst II will create lasting relationships with hospital leadership by becoming highly proficient in the 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 Data Analyst II will share best practice methodologies with other analysts and train end-users on various tools as needed, growing the team's wealth of knowledge and documentation. The team mainly relies on Microsoft SQL Server, 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.

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 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 analysts to share knowledge in methods of data analysis, summarization, and presentation. Trains 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 leveraging Microsoft Azure, Snowflake, and Informatica cloud tools.

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.

Qualifications

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

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

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

4. Working knowledge of relational databases, SQL, data visualization, and Business Intelligence tools such as Tableau and proficiency in at least one of these areas.

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

6. Developing knowledge and application of workflows and data structures of underlying MGB systems, especially Epic, preferred.

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 various levels within the organization.

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

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

4. Experience presenting data through the building of dashboards and reports using business intelligence tools such as Tableau (preferred). With direction from more senior teammates, create data visualizations that are suitable for presentation to senior leaders.

5. Ability to clearly communicate complex and sensitive data to hospital leaders 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 take direction regarding appropriate prioritization.

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.

Mass General Brigham is an Equal Opportunity Employer. By embracing diverse skills, perspectives, and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under the law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, perform essential job functions, and receive other benefits and privileges of employment.