Data Warehouse Architect (Enterprise Data & Digital Health)

Company: Partners Healthcare
Location: Somerville
Posted on: January 6, 2021

Job Description:

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.

GENERAL SUMMARY / OVERVIEW

As a not-for-profit organization, Mass General Brigham (MGB) 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
The Data Architect is a critical member of the MGB Data & Analytics Organization Enterprise Data Warehouse Data Architecture team. The Data Architecture team works together with other DAO teams to design, develop, validate, maintain, and support the EDW platform and many different analytic data assets and products.

Role Summary/Overview
The Data Architect reporting directly to the Director of Enterprise Data Architecture will specifically be responsible to:

---Develop and revise conceptual, logical, and physical data models
---Build and maintain a deep understanding of the data and analytic landscape at Mass General Brigham including data sources, data and analytic assets and products, analytic tools and software, and master data
---Determine database structural requirements by analyzing business operations, applications, and programming; reviewing objectives with business partners; evaluating current systems;
---Create data models that conform to current standards and conventions
---Apply expertise and best practices to the development and revision of data architecture standards and conventions
---Develop and revise data dictionary definitions, governance practices, and standards;
---Partner with security architects to ensure compliance with data security and privacy policies and procedures

PRINCIPAL DUTIES AND RESPONSIBILITIES

---Understands how data is used to support analytical and/or operational reporting
---Interviews business users to obtain requirements for enhancements and/or new analytic assets
---Maps source system data to data warehouse models
---Assists in the Development of data asset training and documentation
---Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data
---Develops and tests extraction, transformation, and load (ETL) processes
---Follows standards for technology and technical processes
---Presents technical solutions to stakeholders and end users


---Minimum of 3 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling
---Must possess excellent oral and written communication skills
---Must possess strong data modeling skills
---Must possess experience using Erwin or similar tools for developing and maintaining data models
---Must possess strong data analysis skills into source systems to profile source system data
---Must have strong experience with SQL

PREFERRED SKILLS/ABILITIES/COMPETENCIES

---Experience with SQL Server platform is preferred
---Healthcare industry experience and Epic data experience is preferred
---Experience with Health Catalyst a plus but not required
---Experience with Tableau reporting tools a plus but not required
---Experience in agile development data projects a plus but not required
---Excellent consultative skills, understanding business needs and translating those needs to technical requirements and solutions.
---Strong creative problem solving with ability to craft Mass General Brigham-specific solutions to meet the wide range of business needs across the organization
---Adept at establishing trusted relationships at all levels across the organization and collaborating across multi-functional teams
---Relational and dimensional data modeling and database design skills
---Knowledge of data warehousing architectural approaches
---Understanding of SQL and relational and multidimensional designs
---Ability to construct queries using a supported query tool
---Understands BI tool architecture, functions, features
---Flexibility, diplomacy, and problem-solving
---Ability to communicate effectively with all levels of the organization including senior business and clinical leaders and executives


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

If onsite:
---Possible local travel to Mass General Brigham 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

---May lead project teams

Keywords: Partners Healthcare, Somerville , Data Warehouse Architect (Enterprise Data & Digital Health), Healthcare , Somerville, Massachusetts