<p>Site: Mass General Brigham Incorporated</p> <p>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.</p> <p>Preferred candidate is proficient with DBT tool, where they feel comfortable designing, developing, and performing admin tasks. Additionally, has a strong grasp of CI/CD processes using Azure DevOps or Git.</p> <p>Job Summary</p> <p>Responsible for overseeing the design, development, implementation, and maintenance of data solutions within the organization. Support team of data engineers, collaborating with cross-functional teams, data scientists, and business stakeholders to ensure the efficient and reliable management of data.</p> <p>Essential Functions</p> <ul> <li>Develop ETL/ELT architectural patterns, guidelines, and methods to manage data assets across the data life cycle, from creation or acquisition through archival and purge. </li><li>Design and implement ETL/ELT architectural standards for multiple data platforms and technologies. </li><li>Drive delivery of highly optimized, scalable, and resource efficient ETL systems. </li><li>Evaluate and recommend new ETL/ELT features, products, and technology. </li><li>Act as an escalation point to troubleshoot and solve technical challenges. </li><li>Provide leadership in ETL/ELT designs, architectural decisions, and technical solutions. </li><li>Develop, test, and implement new and revised features and functionality as needed. </li><li>Lead code review and knowledge transfer sessions for project ETL deliverables. </li><li>Develop Data Engineering Quality circle agenda and drive implementation of standards and best practices. </li><li>Mentor and support junior and senior data engineers sets. </li></ul> <p>Qualifications</p> <ul> <li>Bachelor's Degree Computer Science required or Bachelor's Degree Related Field of Study required </li><li>MGB can review and consider experience in lieu of a degree </li><li>Experience in professional information technology positions 8-10+ years required and Data warehousing development in large reporting environment(s) 5-7 years required and Experience working with data integration tools, ETL frameworks, and workflow management systems (e.g., Apache Airflow) required </li></ul> <p>Knowledge, Skills and Abilities</p> <ul> <li>Strong expertise in data engineering principles, data modeling, ETL development, and data warehousing. </li><li>Strong ability in building data pipelines using Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams ). </li><li>Proficiency in working with relational databases (e.g., SQL Server, Oracle, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra). </li><li>Familiarity with cloud-based data solutions, preferably with AWS, Azure, or Google Cloud Platform. </li></ul> <p>Additional Job Details (if applicable)</p> <p>Working Conditions</p> <ul> <li>Onsite Flexible working model required </li><li>In Office onsite weekly as planned for business needs </li><li>M-F Eastern Business Hours required, remote working days require stable, secure, quiet working area </li></ul> <p>Remote Type</p> <p>Remote</p> <p>Work Location</p> <p>399 Revolution Drive</p> <p>Scheduled Weekly Hours</p> <p>40</p> <p>Employee Type</p> <p>Regular</p> <p>Work Shift</p> <p>Day (United States of America)</p> <p>EEO Statement:</p> <p>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 (857)-282-7642.</p> <p>Mass General Brigham Competency Framework</p> <p>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.</p>