About Us:
As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care, and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.
We're focused on a people-first culture for our system's patients and our professional family. That's why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees' personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development-and we recognize success at every step.
Our employees use 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.

MGB Digital is undergoing a Cloud Deployment initiative. As part of this migration, we are moving our enterprise datawarehouse (EDW) from an on-prem (SQL Server) to SnowFlake. The EDW Operations team is supporting a "dual environment" as we migrate to the SnowFlake environment.

We are looking to hire a summer intern in our area to meet the growing needs of our Data Platform - Operations landscape.

Key Job Responsibilities:

* * Contribute to development of DBT ETL pipelines to move data into different SnowFlake zones

* Understand job failures and follow CI/CD deployments

* Use defined requirements to formulate technical solutions with maintainable code and minimum defects

* Work with cross functional teams to understand end-to-end flow of data

* Follow automated scheduling tools (Tidal) & end-to-end Ops support protocols

* Collaborate with team members to build datasets, queries, dashboards and larger solutions which drives business value & decisions

* Incorporate standards and conformed practices in building end-to-end solutions

* Ownership of maintenance of pre-prod and lower cloud environments

* Manage tickets, understand user requirements, and present technical solutions in various forums

Required Skills:

* Working knowledge of data models and data pipeline design in SnowFlake using DBT

* Strong knowledge of SQL & ETL development

* Ability to troubleshoot data integrations and flows for job performance & data accuracy.

* Working knowledge of R & Python is preferred

* Familiarity with Azure DevOps and ML pipelines

* Independently monitor job schedules, understand SLAs and communication protocols for ops support

* Strong analytical skills with ability to understand raw data and draw logical conclusions.

* Prior experience in healthcare is desirable

Preferred Major/Course of Study:

IInformation Systems, Analytics, Computer Science or Health Sciences

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.