Overview
Remote
On Site
USD 115,398.40 - 167,845.60 per year
Full Time
Skills
Research
Teaching
Team Management
Training
Storage
Accessibility
Business Intelligence
Migration
Reporting
Analytical Skill
Data Governance
Policies and Procedures
Data Integrity
Regulatory Compliance
Data Warehouse Architecture
Mentorship
Database Design
Data Modeling
Cloud Computing
Data Warehouse
Microsoft Azure
Data Integration
Extract
Transform
Load
Informatica
IBM InfoSphere DataStage
Datastage
Microsoft SSIS
Relational Databases
PL/SQL
SQL
Optimization
Dimensional Modeling
Star Schema
Video
Military
Law
Human Resources
MASS
Leadership
Recruiting
Job Details
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 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.
Qualifications
Skills for Success
Additional Job Details (if applicable)
Working Model Requirements
Remote Type
Hybrid
Work Location
399 Revolution Drive
Scheduled Weekly Hours
40
Employee Type
Regular
Work Shift
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.
EEO Statement:
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 .
Mass General Brigham Competency Framework
At Mass General Brigham, our competency framework defines what effective leadership "looks like" by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.
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 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.
Qualifications
- 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.
Additional Job Details (if applicable)
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.
Remote Type
Hybrid
Work Location
399 Revolution Drive
Scheduled Weekly Hours
40
Employee Type
Regular
Work Shift
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.
EEO Statement:
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 .
Mass General Brigham Competency Framework
At Mass General Brigham, our competency framework defines what effective leadership "looks like" by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.