Home Base Data Engineer

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.

Home Base, a Red Sox Foundation and Massachusetts General Hospital program, is dedicated to healing the invisible wounds - including post-traumatic stress, traumatic brain injury, anxiety, depression, co-occurring substance use disorder, family relationship challenges and other issues associated with Military service - for Veterans of all eras, Service Members, Military Families and Families of the Fallen through world-class clinical care, wellness, education, and research.

Home Base seeks to hire a data engineer to start July 2025, who will support a variety of tasks involving database and data warehouse management, design, ETL scripting, data validation, support/troubleshooting, as well as related dev ops and documentation. The qualified candidate will be highly detail-oriented and have a strong interest in and aptitude for data management, engineering, and problem-solving.

The successful candidate must be highly organized, motivated, and able to thrive both in the context of long-term, complex team engineering projects as well as the fast-paced environment of supporting production systems for a dynamic organization. Therefore, it is extremely important that the candidate possesses the ability to carefully keep track of multiple work streams including asking for input when needed. This position is not a supervisor or senior engineer, but may involve mentorship of co-ops, and does include the opportunity for growth. In the short term, it will focus on supporting data migration to Salesforce, as well as building out integrations in the Home Base data warehouse to more fully utilize enterprise data warehouse assets in Snowflake.

Job Summary
Summary
Responsible for implementing methods to improve data reliability and quality. They combine raw information from different sources to create consistent and machine-readable formats, and they develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling.

Does this position require Patient Care? No

Essential Functions
-Design, develop, and implement data pipelines and ETL/ELT code to support business requirements.
-Maintain and optimize various components of the data pipeline architecture.
-Deliver high quality, efficient solutions to meet technical standards and industry best practices.
-Deliver optimal technical solutions for business and operational requirements.
-Participate in team design sessions and contribute options and solutions Produce and support product documentation.
-Participate in ETL Quality circle discussions to explore, discuss, and arrive at efficient solutions and best practices.

Qualifications

Education
Bachelor's Degree Computer Science 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
Data warehousing development in large reporting environment(s) 2-3 years required and Experience with developing data pipelines using on Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams ) required and Hands-on development experience with ETL/ELT tools, such as dbt, Fivetran, or Informatica required and Experience working in Agile software development environment required

Knowledge, Skills and Abilities
- Working knowledge of cloud computing platforms such as AWS, Google Cloud Platform, or Azure.
- Familiarity with enterprise data warehousing systems a plus.

Additional Job Details (if applicable)

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%)

Remote Type

Remote

Work Location

123 Main Street

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 .

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.