Senior Data Engineer, MGB Digital at Mass General Brigham

Site: Mass General Brigham IncorporatedMass 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.Job SummaryAbout UsMass General Brigham is a passionate welcoming community where brilliant minds meet caring hearts. Come be a part of the worlds most powerful force in medicine where every role is important in changing lives. A wide range of clinical and non-clinical employment opportunities exist at our member hospitals and at our other health care and research organizations. Join our dynamically growing integrated network of health care professionals!Our Digital Enterprise Engineering Clinical Data Solutions team is hiring a vital member to our team to join growing projects that support our health care system. The Digital Clinical Data Solutions team is Hybrid with onsite work at Assembly Row Somerville weekly.The OpportunityThe Sr Data Engineer will be assigned to a product team based on business needs when hired reporting to the Data Engineer Manager and assigned to the aligned Scrum Team. This team is comprised of multiple product teams within. DBT and snowflake areas most critical for this role.The Sr Data Engineer is responsible for designing developing and maintaining the data architecture and infrastructure within an organization. The Data Engineer plays a crucial role in managing large-scale data systems and ensuring the efficient flow storage and accessibility of data for various stakeholders such as data analysts data scientists and business users.- Design develop and implement data pipelines and ETL/ELT code to support business requirements. -Work on cross-functional teams delivering enterprise solutions for internal and external clients. -Assume ownership for delivering code revisions and enhancements from design through development and production installation. -Maintain and optimize various components of the data pipeline architecture. -Become subject matter expert for internal and external data products Ensure design solutions can scale and meet technical standards and performance benchmarks. -Identify inefficient processes and develop recommendations and design solutions. -Lead code review sessions to validate technical solutions and facilitate knowledge sharing.QualificationsSenior Data EngineerExperience in data engineering with a focus on building and maintaining engineering pipelines 5-7 years requiredData warehousing development in large reporting environments 3-5 years required and Hands-on development experience working with developing data pipelines using on DBT and leveraging Snowflake features (SnowSQL Snow Sight ) required and experience working in Agile software development environment required.Experience with EPIC health care modules would be a plus.Working knowledge of cloud computing platforms such as AWS GCP or Azure.Experience with enterprise database solutions in cloud or on-premise environments Adherence to sound engineering principles and practices when designing technical solutions.Data Engineer Requirements and Level can also be consideredBachelors Degree Related Field of Study requiredExperience in lieu of a degree may be reviewed for possible considerationMinimum 3-5 years of experience with data engineering and development experience on Snowflake platform.Minimum 1-2 years of experience with DBT development.Expert level knowledge in developing debugging and optimizing SQL queries.Having EPIC knowledge or experience will be a major plus ( would prefer candidates with EPIC experience )Must excel in working independently and meet individual goalsMust collaborate with data engineers on the team while also meeting individual goalsPerform EDW ETL/ELT ingestions and integrations to ensure support data and analytic needsBuild and enhance standard solution that provides efficient and scalable ETL/ELT solutions from multiple data sourcesEnsure the quality of data assets and robustness of data engineering processesExperience with change control release management and other ITIL processesParticipate in building out EDW on Snowflake expanding and optimizing the data ecosystem as well as optimizing data engineering processesSupport BI Developers Data Architects Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projectsConduct ETL solution code and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projectsCollaborate with Platform Architect on ETL/ELT new features and train peersPerform troubleshooting on ETLs and related componentsIdentify application bottlenecks and opportunities to optimize performanceAdditional Job Details (if applicable)Physical RequirementsM-F Eastern Business Hours requiredHybrid working model requires weekly onsite 1-2x weekly in officeRemote working days require a stable secure compliant free of others and free of distraction work station using MGB provided equipmentRemote TypeHybridWork Location399 Revolution DriveScheduled Weekly Hours40Employee TypeRegularWork ShiftDay (United States of America)Pay Range$92102.40 - $134056.00/AnnualGrade7At 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 account your skills relevant experience if applicable education certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however it does not encompass all elements contributing to your total compensation addition to competitive base pay we offer comprehensive benefits career advancement opportunities differentials premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.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 Veterans 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 FrameworkAt 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.Required Experience:Senior IC Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full-Time Experience: years Vacancy: 1 Monthly Salary Salary: 92102 - 134056