New

Sr Data Warehouse Architect

Mass General Brigham (Enterprise Services)
United States, Massachusetts, Somerville
399 Revolution Drive (Show on map)
Nov 07, 2025
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. Mass General Brigham Incorporated 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. 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.