Senior Enterprise Data Warehouse ETL Architect
Mass General Brigham(PHS)

Job Info

---

About Us

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.

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

Mass General Brigham Data Analytics Organization EDW platform and data engineering team is on the journey to build best-in-class Cloud data warehouse platform to host various data-driven products to support MGB data and analytic community. The team consists of platform architect, ETL/ELT architect, data integration and data quality engineer who work in Development and Operation scrum teams to deliver enterprise analytic solutions.

Role Summary/Overview

We are looking for a talented Senior ETL Architect to join our Platform and Data Engineering team. You will be leading ETL/ELT data warehouse design on prem and in the Azure cloud - handles both near real time and batch ETL/ELT. You will be helping data engineers, analysts and scientists perform their functions by building scalable and robust solutions. This role will give you the ability to utilize your technical leadership and drive complex cross-functional data solutions.

Principal Duties and Responsibilities

• Hand on designing and implementing of ETL solution
• Set technical guideline, standards and best practices to effectively leverage the functionalities of ETL tool and database engine
• Provide optimal solutions for complex ELT/ETL production problems
• Mentor technical design with data engineers
• Influence for defining technical evaluation criteria for product and technology selection
• Determine technical approaches to ensure all architectural solutions result in a coherent systems design
• Work with stakeholders, product owners, data architect team and data engineers to ensure optimal data ingestion and integration architecture is consistent across Dev and Operation teams

Qualifications
Required Qualifications

• 5 + years of enterprise data warehouse and/or data lake experience
• 3 + years hands-on experience in leading/managing large scale MPP enterprise data warehouse databases
• 3 + years of experience architecting and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions
• At least one year of experience in delivering and architecting Azure or AWS data warehouse or data lake is a plus
• Experience with Kimball modeling
• Experts on SQL tuning and store procedure development
• Experience with ETL tool Informatica or Talend or others

Preferred Skills, Abilities, Competencies

• Strong SQL skills and workload management on multi-processing data platform (preferred MPP systems). Experience with Snowflake/Teradata/Oracle is a plus
• At least one year of experience with building large data warehouse in SQL Server, SSIS is a must
• 3 years Informatica, Talend data or other integration tool is a plus
• Ability to troubleshoot system bottleneck and conduct performance tuning in large data warehouse or data lake
• Experience with real time data processing and analytics products is a plus
• 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
• Health Catalyst knowledge is a plus
• Experience with logical and physical data modeling

Supervisory Responsibility

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

Fiscal Responsibility

• No direct budgetary responsibility
• Demonstrates fiscal responsibility by effectively using Mass General Brigham resources

Working Conditions:

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 September 2021

If onsite:

• Standard Office Environment

• Possible local travel to Mass General Brigham sites
• 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. Normal office working conditions. The noise level in the work environment is quiet to moderate.

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.

This job has expired.