Site: Mass General Brigham Incorporated

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.

MGB Digital is hiring a Full Time Sr Data Warehouse Architect, this role is vital to the team handling a major migration to Cloud that is ongoing and vital the MGB system. We will provide extensive and hands on training to understands our system and complex environment.

o DBT is highly preferred, the team uses the tool now
o Required- Experience in data warehousing, database design, and data modeling 8-10+ years required

Job Summary

The Opportunity

MGB Digital is hiring a vital member of the team! The Sr Data Warehouse Architect will be designing, developing, and maintaining data warehouse solutions for an organization. This position plays a crucial role in ensuring the efficient storage, organization, and accessibility of data to support the company's business intelligence and reporting needs.

The migration began early 2024 and is going and long term. MGB continues to ensure the quality of this project. You will play a vital role as we continue to move the Cloud. DBT is highly preferred, the team uses the tool now.



What You'll Do

-Develops data warehouse architectures that align with the organization's business goals and requirements.
-Designs and implements data models that support the reporting and analytical needs of the organization.
-Establishes data governance policies and procedures to ensure data integrity, security, and compliance.
-Identifies performance bottlenecks and optimizes data warehouse processes, including ETL (Extract, Transform, Load), data transformation, and query execution.
-Evaluates and selects appropriate data integration tools and technologies to support the data warehouse architecture.
-Leads other developers, analysts, and data warehouse architects, providing guidance, mentoring, and technical expertise.

• Bachelor's Degree Related Field of Study required
• Can this role consider and review experience in lieu of a degree? Yes
• Experience in data warehousing, database design, and data modeling 8-10+ years required

Skills for Success

• In-depth knowledge of data warehousing concepts, methodologies, and best practices.
• Knowledge of Cloud Data Warehouse platforms.
• Knowledge of Azure.
• Proficiency in data integration and ETL tools (e.g., Informatica, DataStage, SSIS). DBT is highly preferred, the team uses the tool now.
• Strong understanding of relational databases (e.g., Oracle, SQL Server) and SQL query optimization techniques.
• Familiarity with dimensional modeling and star schema design.

Working Model Requirements

• M-F Eastern business hours required
• Hybrid onsite days in office, candidate must be flexible for business needs
• This team is currently onsite 4 days per month with planning
• On remote workdays, employees must use a stable, secure, and compliant workstation in a quiet environment. Teams video is required and must be accessed using MGB-provided equipment.

Hybrid

399 Revolution Drive

40

Regular

Day (United States of America)

Pay Range

$115,398.40 - $167,845.60/Annual

Grade

8

At 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 package. In 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.

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.

Mass General Brigham Competency Framework