Sr Data Warehouse Architect

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.

oDBT is highly preferred the team uses the tool now
oRequired- 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 companys 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 Youll Do

-Develops data warehouse architectures that align with the organizations 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.

• Bachelors 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

$115398.40 - $167845.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 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 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 Framework