Demo

Senior Data Engineer

Mass General Brigham Medical Group, Inc.
Somerville, MA Full Time
POSTED ON 2/17/2025
AVAILABLE BEFORE 5/15/2025

This Senior Data Engineer position is for development and support activities on EAM team for building Subject Area marts using cloud engineering technologies like Snowflake, DBT & Tidal. Develop, implement and DBT ETL models on Snowflake. Senior Data Engineer will also work on ingestion pipelines designed on Azure Data Lake and will develop & implement applications on Profisee.

  • Perform EDW ETL / ELT ingestions and integrations to ensure support data and analytic needs
  • Build and enhance standard solution that provides efficient and scalable ETL / ELT solutions from multiple data sources
  • Ensure the quality of data assets and robustness of data engineering processes
  • Experience with change control, release management and other ITIL processes
  • Participate in building out EDW on Snowflake, expanding and optimizing the data ecosystem, as well as optimizing data engineering processes
  • Support BI Developers, Data Architects, Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects
  • Conduct ETL solution, code, and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projects
  • Collaborate with Platform Architect on ETL / ELT new features and train peers
  • Perform troubleshooting on ETLs and related components
  • Identify application bottlenecks and opportunities to optimize performance

Qualifications

  • 7 plus years of experience designing and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions
  • 2 years of experience with developing models in DBT
  • Experience with Azure DevOps, Azure Git and CI / CD data pipeline integrations.
  • Demonstrates good knowledge of cloud computing platforms such as AWS, GCP, and Azure
  • Experience of support and enhance existing Enterprise Data Warehouse or Data Lake
  • Ensure designed systems are highly reliable, self-recovering, and require little or no supporting manpower
  • Familiar with change control, release management, and other ITIL methodology
  • Deep experience in traditional Data Warehousing & Cloud data warehousing
  • Mastery of SQL, especially within cloud-based data warehouses like Snowflake
  • Professional knowledge of Azure
  • Experience developing data pipelines using Snowflake features (Snow pipe, SnowSQL, Data Streams, Snow Sight)
  • Ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiences
  • Proven verbal, communication, and presentation skills
  • Proven ability to work independently
  • Skills / Abilities / Competencies

  • Thorough knowledge of Snowflake, DBT, Azure Microsoft SQL Server, SSIS, and related ETL tools
  • Strong SQL skills and workload management on Snowflake
  • Ability to troubleshoot system bottleneck and conduct performance tuning in large data warehouse or data lake
  • Experience with logical and physical data modeling
  • Experience with real time data processing and analytics products is a plus
  • 5 plus years of experience with building larger data warehouse in SQL Server, SnowSQL is a must
  • 2 years of experience with developing models in DBT
  • Familiarity with data engineering, data governance and data quality principles
  • Healthcare experience, most notably in Clinical data, Epic, Payer data and reference data is a plus but not mandatory
  • Supervisory Responsibilities

    No direct reports; may provide guidance to less seasoned and new staff

    Fiscal Responsibility

    Demonstrates fiscal responsibility by effectively using Mass General Brigham resources

    Working Conditions

    The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

    This position requires occasional local travel to MGB sites, vendors, and / or conferences

    Hospital work environment working conditions include possible exposure to diseases or infections and may require safety gear (PPE) such as gloves and mask.

    Normal office working conditions. The noise level in the work environment is quiet to moderate.

    While performing the duties of this job, the employee is frequently required to sit; talk; or hear; use hands to finger; handle; or feel; reach with hands and arms. The employee is occasionally required to stand; walk; and stoop; kneel; or crouch. The employee must frequently lift and / or move up to 5 pounds and occasionally lift and / or move up to 20 pounds.

    Specific vision abilities required by this job include close vision, distance vision and depth perception.

    Mass General Brigham Medical Group, Inc. 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.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Data Engineer?

    Sign up to receive alerts about other jobs on the Senior Data Engineer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $168,522 - $211,152
    Income Estimation: 
    $189,259 - $248,928
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Mass General Brigham Medical Group, Inc.

    Mass General Brigham Medical Group, Inc.
    Hired Organization Address Haverhill, MA Full Time
    Primary Care Physician for Haverhill, MA Join Our Community : Primary Care Opportunity in Haverhill, MA Mass General Bri...
    Mass General Brigham Medical Group, Inc.
    Hired Organization Address Salem, NH Full Time
    The Physician Assistant (PA) is a licensed provider. The PA is responsible for the assessment and management of various ...
    Mass General Brigham Medical Group, Inc.
    Hired Organization Address Somerville, MA Full Time
    We are seeking a full time, 40-hour Medication Access Coordinator (MAC) to join our team, Monday through Friday 8:00am-4...
    Mass General Brigham Medical Group, Inc.
    Hired Organization Address Somerville, MA Full Time
    Key Responsibilities: *Fire Drill Coordination: Plan, coordinate, and execute fire drills to ensure team preparedness. *...

    Not the job you're looking for? Here are some other Senior Data Engineer jobs in the Somerville, MA area that may be a better fit.

    AI Assistant is available now!

    Feel free to start your new journey!