Data Analyst II, Community Health Evaluation and Reporting

Site: Mass General Brigham Incorporated

 

Mass General Brigham relies on a wide range of professionals, including doctors, nurses, business people, tech experts, researchers, and systems analysts to advance our mission. As a not-for-profit, we support patient care, research, teaching, and community service, striving to provide exceptional care. We believe that high-performing teams drive groundbreaking medical discoveries and invite all applicants to join us and experience what it means to be part of Mass General Brigham.

 

 

Job Summary

Mass General Brigham Community Health lead the Mass General Brigham system-wide commitment to improve the health and well-being of low-income and vulnerable populations.

The overarching goal of all initiatives will be to demonstrate a reduction in health inequities and a measurable improvement in community health outcomes in MGB priority communities.

The Community Health Evaluation and Reporting team is seeking an experienced data analyst to provide analytic support for community health reporting and compliance functions at Mass General Brigham and program evaluation for system-wide community-based initiatives. The best candidate has solid analytical, data visualization, and communication skills, and experience working with health care data. The incumbent will develop data collections tools with key stakeholders to track and monitor patient and community-level outcomes, analyze results, and synthesize findings into dashboards, reports, and presentations. The Data Analyst will become
an expert within the Community Health domain, acquire in-depth knowledge of workflows across various settings, be a subject matter on publicly available community-level and census data, and conduct routine and complex analyses to address stakeholder needs and meet compliance reporting requirements. The incumbent will be responsible for building and maintaining key
relationships with staff, providing evaluation and data advice, and sharing knowledge. The candidate will also be responsible for rigorous quality assurance and presenting analytical findings to diverse audiences in an accessible manner.

Principle Duties And Responsibilities

1. Assessment and planning – Community Health Needs Assessment

- Co-lead the collection and interpretation of primary/qualitative data including developing surveys, focus groups, and interviews using tools such as RedCap, participate in regional collaboratives and working groups to share knowledge on publicly available community-level data such as from the DPH, BRFSS, or CHIA, and co-lead the synthesis of primary and secondary data for reports and presentations

2. Community Health Program Evaluation

- Collaborate with community health teams to understand program goals and strategies across various workstreams. Develop theories of change and evaluation plans to inform program improvement. Create and train staff on data collection tools. Serve as an expert on internal MGB patient data sources such as Epic and external community data sources. Guide and train new team members by familiarizing them with the data products they will use and provide them with relevant information about the Community Health domains. Coordinate as needed with MGB Data and Analytics.

- Utilize a variety of tools (E.g., SAS, SQL, R, Python, Excel) to access data, write
queries, develop programming logic, create dashboards, manipulate, and analyze large datasets to meet the needs of Community Health. Apply appropriate data cleaning procedures and organize and structure data efficiently. Pull data from a variety of internal and external sources to develop dashboards using Tableau for senior leadership to track and monitor metrics and outcomes. Complete thorough quality assurance procedures to ensure accuracy, reliability, trustworthiness, and validity of work.

3. Compliance and Reporting

- Participate in all required compliance reporting including to the IRS, MA Attorney General, MA DPH, and grantors, play a lead role in the administration and maintenance of tracking and grant management tools, such as AGS Prime.

4. Presentation

- Present analytical findings in a variety of formats (reports, PowerPoint, graphs, figures, tables, dashboards), formulate recommendations, and effectively communicate results to non-analytic audiences.

5. Other duties as assigned

 

Qualifications

• Bachelor’s degree in computer science, informatics, statistics, public health,
• epidemiology, biostatistics, or related field and an interest in healthcare and the use of data to evaluate community health programs.
• 3+ years of experience working with healthcare data.
• 3+ years of experience working at a hospital or specialty care facility strongly preferred.
• Epic Proficiency or Certification in Clarity / Caboodle data model or Epic applications preferred;
• Proficiency in querying complex data structures using SQL is required.
• Working knowledge of Azure, AWS, Snowflake, or similar experience is preferred.
• Strong programming skills and proficient in other programming languages (e.g., SAS, R, and Python) as well as working knowledge of data visualization (Tableau) software is preferred.
   

Skills, Abilities And Competencies

• Ability to function effectively and independently in a fast-paced environment, organize and prioritize work independently, and meet tight deadlines.
• Ability to manage multiple projects simultaneously, set priorities, and collaborate with team members and others throughout the organization.
• Possess strong interpersonal skills to effectively communicate with cross functional teams including staff at all levels of the organization.
• Knowledge of public health evaluation frameworks is preferred.
• Practical problem-solving abilities, i.e., the ability to formulate hypotheses, test options and move forward in a fast-paced environment.
• Excellent interpersonal skills, including strong customer service orientation and the ability to translate complex technical concepts to non-technical audiences.
• Possible local travel to Mass General Brigham sites.

 

Additional Job Details (if applicable)

 

Remote Type

Hybrid

 

Work Location

399 Revolution Drive

 

Scheduled Weekly Hours

40

 

Employee Type

Regular

 

Work Shift

Day (United States of America)

 

EEO Statement:

Mass General Brigham Incorporated is an Equal Opportunity Employer. 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 law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. To ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Veteran’s Readjustment Act of 1974, and Title I of the Americans with Disabilities Act of 1990, applicants who require accommodation in the job application process may contact Human Resources at (857)-282-7642.

 

Mass General Brigham Competency Framework

At Mass General Brigham, our competency framework defines what effective leadership “looks like” by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.