New

Data Analyst II, Community Health Evaluation and Reporting

Mass General Brigham (Enterprise Services)
United States, Massachusetts, Somerville
399 Revolution Drive (Show on map)
Jun 25, 2025
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 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. Mass General Brigham Incorporated 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 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.