Digital Intern - Data Lake Data Engineer

Mass General Brigham (Enterprise Services)
United States, Massachusetts, Somerville
399 Revolution Drive (Show on map)
Mar 28, 2025
At Mass General Brigham Digital, we pride ourselves on our ability to create maximum strategic, clinical, and operational value from established and emergent technologies for our patients, care teams, researchers, and employees. Digital health will not only enhance the equity and efficiency of healthcare delivery, but it will also help make medicine more personalized and precise. We recognize that increasing value and continually improving quality while maintaining an inclusive focus are essential to organizational excellence, and we invite you to join us on this journey. The work we do in Digital is a strategic imperative, and there is a strong and growing understanding of how together we will transform Mass General Brigham in innovative and impactful ways. The candidate will be participating in building out our Data Lake platform, expanding data ecosystem and data pipeline architecture. The ideal candidate has ETL/ELT and data pipeline experience and knowledge. The Data Engineer will support our Software Developers, Database Architects, Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional / non-functional business requirements on cloud based data platforms (e.g. Azure) and relational data systems (SQL Server, SSIS). Use/s 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. Other duties and responsibilities as assigned. Current enrollment in college-level coursework required Azure data engineering and Azure Cloud Data Lake knowledge and experience. Programming experience in Python, SQL, PySpark. Experience with Design and Architecture of Azure big data frameworks/tools: Azure Data Lake, Azure Data Factory, Snowflake, Azure Data Bricks, Powershell. Experience with building processes supporting data transformation, data structures, metadata, dependency and workload management. Experience with Azure DevOps/CI-CD, Continuous integration and deployment. Skills/Abilities/Competencies: Experience on SQL, Spark, Python, pySpark (2+ of these) knowledge and experience working with relational databases for data querying and retrieval. Strong SQL skills on multiple platform (preferred MPP systems). Data Modeling tools (e.g. Erwin, Visio). Strong interpersonal and communication skills, both written and verbal. Scrum/Agile development experience. Excellent organizational skills and attention to detail, manage multiple tasks and meet deadlines, follow through, and manage to schedule. Strong innovation capabilities and the ability to think creatively. Strong collaboration and team building skills within, across and outside of an organization. Maintain and promote a positive team environment. Maintains stable performance under pressure, demonstrating sensitivity to diverse organizational culture. Ability to effectively cope with change, remain flexible and adaptable within a fast-paced environment with rapidly changing requirements, and ability to negotiate situations when the big picture is not clearly defined. Schedule requirements: This internship will be June 2nd - August 8th 2025. Up to 40 hours/week M-F Hybrid role includes onsite at MGB local sites and Assembly Row. Remote Working days require stable, quiet, secure working area that is HIPAA compliant Onsite events are planned ahead, working days onsite weekly vary for department needs, must be flexible. Physical Requirements Standing Occasionally (3-33%) Walking Occasionally (3-33%) Sitting Constantly (67-100%) Lifting Occasionally (3-33%) 20lbs - 35lbs Carrying Occasionally (3-33%) 20lbs - 35lbs Pushing Rarely (Less than 2%) Pulling Rarely (Less than 2%) Climbing Rarely (Less than 2%) Balancing Occasionally (3-33%) Stooping Occasionally (3-33%) Kneeling Rarely (Less than 2%) Crouching Rarely (Less than 2%) Crawling Rarely (Less than 2%) Reaching Occasionally (3-33%) Gross Manipulation (Handling) Constantly (67-100%) Fine Manipulation (Fingering) Frequently (34-66%) Feeling Constantly (67-100%) Foot Use Rarely (Less than 2%) Vision - Far Constantly (67-100%) Vision - Near Constantly (67-100%) Talking Constantly (67-100%) Hearing Constantly (67-100%) 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.