Python Data Wrangler Internship Jobs in Massachusetts

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

The Senior Data Analyst, within the Mass General Brigham Enterprise Analytics (EA) Department, providing dedicated analytical support to Health Data Solutions (HDS), is responsible for identifying, querying, analyzing, curating and visualizing clinical data to support initiatives throughout Mass General Brigham. The Senior Data Analyst will be responsible for using MGB data assets to build curated datasets according to complex requirements. The position requires close collaboration and dialogue with external collaborators, clinical personnel, various analytic groups, and hospital and system leadership.
The Senior Data Analyst partners closely with clinicians, researchers, and analytics and digital colleagues to translate complex questions into rigorous analytical approaches. The role requires strong expertise in Snowflake SQL, Python, and R, with an emphasis on reproducible, well-documented analytical workflows.
In addition, the Senior Data Analyst will serve as a resource and role model for other data analysts, sharing best practice methodologies, training other analysts and end-users, and growing the team's wealth of knowledge and documentation. The team primarily leverages Snowflake SQL, Python, R, and 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.Partners with researchers, clinicians, and other stakeholders to define research-oriented analytic questions and data requirements, translating study objectives and protocols into clear analytical specifications.
2.Queries and analyzes data from hospital systems such as our electronic medical record system (Epic), enterprise data warehouse (EDW), vendor neutral archive (VNA) and more, to identify and curate cohorts based on dataset specifications and other project requirements. The analyst should be comfortable performing data wrangling across multiple data sources.
3.Produces and maintains data dictionaries, dataset versioning and release notes.
4.Presents data and analyses to key stakeholders, including creating materials for and giving presentations as needed.
5.Uses programmatic tools such as Python or R to support data QA and exploratory analysis. This includes identifying missing data, detecting outliers, and assessing whether anomalies reflect true variation or unreliable data.
6.Applies data de-identification techniques and tools to protect sensitive healthcare information in accordance with HIPAA and related regulations.
7.Develops, maintains, and delivers programmatic analytical outputs, including reproducible reports, analytical datasets, figures, and written summaries, to support stakeholder decision-making.
8.Collaborates with EA, HDS, and MGB Digital partners to continually improve analytical capabilities using SQL, Python, R, and other programmatic analytics tools, including documentation of analytical methods, assumptions, and limitations.
9.Performs comprehensive quality assurance, ensuring that data and reports meet end user specifications and are accurate and reliable.
10.Works with new and existing EA analysts to share knowledge in methods of data analysis, summarization, and presentation. Trains other analysts and end-users on key analytic and reporting systems and databases.
11.Partner with MGB Digital teams to leverage existing tools, methods, and processes in order to deliver timely information to stakeholders across MGB, including Snowflake SQL.
12.Effectively recognizes when additional help or guidance is needed and seeks it out proactively.
13.Represents EA on internal and external committees or task forces as needed.
14.Performs all other related duties as required.
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 SQL Server Management Studio, Python, and R.
3.Strong experience presenting analytical findings using programmatic and narrative-driven approaches, including creation of tables, figures, statistical summaries, and written insights appropriate for executive and clinical audiences. With limited input from others, creates data visualizations that are suitable for presentation to senior leaders.
4.Demonstrated ability to handle protected health information (PHI) under HIPAA, organizational policies and IRB protocols
5.Familiarity with LLM-based tools to help review unstructured clinical text, extract structured variables, and support pre-labeling workflows.
6.Ability to clearly communicate complex and sensitive data to senior executives as well as peers and external collaborators.
7.Strong written and verbal communication skills, with the ability to tailor message to individuals and audiences throughout the institution.
8.Strong organizational skills, with the ability to focus detailed concentrated effort on multiple projects and re-establish priorities as necessary.
9.Possesses initiative and ability to work independently while thriving in a setting requiring collaboration and teamwork for maximal efficiency and effectiveness.
10.Attention to detail that ensures follow through on all initiatives implemented, and all projects undertaken.
11.Ability to effectively respond to time sensitive issues and meet deadlines.

Education
Bachelor's Degree Analysis required or Bachelor's Degree Related Field of Study required
Can this role accept experience in lieu of a degree?
Yes
Licenses and Credentials
Experience
Experience in data analysis 5-7 years required
Knowledge, Skills and Abilities
- Strong knowledge of relational databases, SQL, data visualization, and Business Intelligence tools, such as Tableau.
- Strong proficiency with Microsoft Office Suite, including Word, Excel, and PowerPoint.
- Ability to communicate complex workflows and data to a variety of audiences.
- Project management skills and/or experience are a plus.
- Knowledge and application of statistical analyses including variance analysis and statistical significant preferred.
- Healthcare knowledge, particularly as it pertains to electronic medical record data, is preferred but not required.

Working Model Requirements

• M-F Eastern Business Hours Full Time required

• Hybrid model includes in person onsite work at MGB local sites, weekly or monthly, to be determined based on business needs

• Must be flexible for weekly or monthly in person stakeholder meetings, team meetings and internal customer needs

• On remote workdays, employees must use a stable, secure, and compliant workstation in a quiet environment. Teams video is required and must be accessed using MGB-provided equipment

Hybrid

399 Revolution Drive

40

Regular

Day (United States of America)

Pay Range

$79,560.00 - $115,720.80/Annual

Grade

7

At Mass General Brigham, we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive, and any offer extended will take into account your skills, relevant experience if applicable, education, certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however, it does not encompass all elements contributing to your total compensation package. In addition to competitive base pay, we offer comprehensive benefits, career advancement opportunities, differentials, premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply, and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.

0100 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