EDW Data Engineering Manager (Enterprise Data & Digital Health)
MGH Institute of Health Professions
Location: Somerville, Massachusetts
Internal Number: 3134360-1435_1607615369
As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.
We're focused on a people-first culture for our system's patients and our professional family. That's why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees' personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development-and we recognize success at every step.
Our employees use the Mass General Brigham values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration. GENERAL SUMMARY / OVERVIEW Description As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to our community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.
We seek employees who bring passion, are highly collaborative, and thrive in a dynamic, diverse, and inclusive team. We work in a highly agile environment with a focus on quality and achieving real impact with our work. We are excited to have a team with a rich mix of experiences, with people who bring innovative approaches to their work, an excitement for looking at things from new angles, and a spirit of continuous improvement. Finally, we seek employees who embrace and live our core values of respect, recognition, communication, commitment, trust, innovation, and service. If this sounds like you, we invite you to apply. Mass General Brigham's main office is in Somerville, MA. We are currently working as a fully-remote team due to COVID-19 and encourage applications from across the US as telecommuting becomes part of our new normal. We are committed to building an engaged, inclusive community and offer a variety of opportunities to come together virtually and facilitate learning and collaboration. Overview Mass General Brigham's board and system-wide executive leadership are making significant investments in enterprise data and digital health, enabling innovation and transformation in the delivery of health care, research and discovery. By building out core digital and data capabilities, we are supporting the achievement of Mass General Brigham's mission to drive growth and innovation in inpatient, ambulatory, and digital care. We are at the start of this journey and we are looking for talented individuals from across the nation to join us in transforming healthcare and in achieving the expected outcomes of this strategy: improved patient care, quality of care, patient engagement, and efficiency in the delivery of healthcare with excellence.
In the achievement of these goals, Mass General Brigham's data and analytic teams are working together to build a system-wide data ecosystem. We are both leveraging current assets and building new, integrated solutions to provide a holistic set of industry-leading data and analytic capabilities, supporting Artificial Intelligence (AI), Machine Learning (ML), and real-time insights. Teams from Data and Analytics, Research Analytics, Clinical Data Science, and Information Systems are collaborating to build this new data and analytic ecosystem. To ensure success of this effort, Mass General Brigham is standing up a new Data and Analytics operating model with a goal of driving a level of standardization for data and analytic operations across the teams involved.
The value of investments in data and analytics were proven out during our response to COVID-19 as these investments were leveraged to stand up new reporting and analytic capabilities to support executive and clinical leadership on managing the pandemic. Our broad data and analytic community has come together across Mass General Brigham 's 14 healthcare sites with shared urgency, delivering analytic tools to our system that drove timely insights in both clinical and operational domains, resulting in effective delivery of critical care and in organizational efficiencies during a time of reduced resources. Team Description
EDW data engineering team supports various data source ingestion and builds analytics data layer in EDW. The team also manages ETL/ELT operation, performance and site -specific security for our broad data and analytics community. Role Summary/Overview We are looking for a self-motivated EDW Engineer Manager to join our data engineering team to lead design, build, test and maintain architectures such as EDW, data lake and large -scale data processing systems. Lead a team of data engineers to build, monitor and support EDW ingestions, data marts and extracts to meet various SLAs for our broad data and analytic community. The ideal candidate also leads on-going operation performance and security activities to support EDW access and optimization of user queries. The right candidate will be excited by the prospect of optimizing and/or redesigning our data landscape to support the next generation of products and data initiatives. PRINCIPAL DUTIES AND RESPONSIBILITIES • Oversee EDW ingestions and integrations to ensure SLAs are met in all EDW environments • 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 existing EDW in SQL Server and new Data Lake, 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 • Collabrate and lead ETL/DB solution, code and pre-prod review to ensure data build and delivery architecture is efficient and consistent throughout ongoing projects • Lead a group of 5-6 data engineers to ensure data loads meet SLA and manage proper data availability communication • Use/s the Mass General Brigham values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration
Qualifications • 3 plus years of experience architecting and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions • Expert/advanced level of experience with ETL/ELT tools • Experience leading a team • Experience leading development and support of Enterprise Data Warehouse or Data Lake Architectures • Designed systems that are highly reliable, self-recovering, and require little or no supporting manpower • Has mentored and developed technical competency of junior team members PREFERRED SKILLS/ABILITIES/COMPETENCIES
• Strong SQL skills and workload management on multi-processing data platform (preferred MPP systems) • Ability to troubleshoot system bottleneck and conduct performance tuning in large data warehouse or data lake • Experience with logical and physical data modeling • 3 plus years of experience with building larger data warehouse in SQL Server, SSIS • Familiarity with data engineering, data governance and data quality principles • Experience with real time data processing and analytics products is a plus • 3 years Informatica, Talend data integration tool is a plus • Healthcare experience, most notably in Clinical data, Epic, Payer data and reference data is a plus • Health Catalyst knowledge is a plus
MGB has implemented special remote working policies due to COVID-19. These policies are subject to change; however, it is currently expected that this position will work remotely (e.g. from home) full time through June 2021
If onsite: • Possible local travel to Partners sites, vendors, and conferences • 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. • The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. SUPERVISORY RESPONSIBILITY
• Will manage team of 5-6 Data Engineers
EEO Statement Mass General Brigham 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.
Partners Healthcare System Inc. is acting as an Employment Agency in relation to this vacancy.
MGH Institute of Health Professions, founded by Massachusetts General Hospital in 1977, is an innovative and independent graduate school in Boston that is a member of Partners HealthCare. A progressive leader in developing comprehensive models of health care education, the MGH Institute prepares advanced practice professionals in the fields of nursing, physical therapy, occupational therapy and communication sciences and disorders through a distinctive combination of academic study, clinical practice, and research. More than 1,200 students are enrolled in graduate level and certificate programs, with an increasing number of courses available online. The Institute is accredited by the New England Association of Schools and Colleges (NEASC).