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

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

• Fine Manipulation (Fingering) Frequently (34-66%)

• Feeling Constantly %)

• Foot Use Rarely (Less than 2%)

• Vision - Far Constantly %)

• Vision - Near Constantly %)

• Talking Constantly %)

Hearing Constantly %)

Remote Type

Hybrid

Work Location

One Constitution Wharf

Scheduled Weekly Hours

40

Employee Type

Regular

Work Shift

Day (United States of America)

Pay Range

$73, $107,400.80/Annual

Grade

6

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