Sr. Data Warehouse Architect

Post Date

Jan 18, 2023

Location

Somerville,
Massachusetts

ZIP/Postal Code

02145
US
Sep 14, 2025 Insight Global

Job Type

Perm

Category

Architect (Engineering)

Req #

HSE-596896

Pay Rate

$140k - $165k (estimate)

Job Description

A large hospital system in Boston, MA is looking for an Sr. Data Warehouse Architect to join their Data and Analytics Organization. This is a permanent, fully remote position, with potential to travel onsite quarterly. To be considered for this position, candidates must be fully vaccinated against COVID-19.



As a Senior Data Architect, you are a critical member of the organization's Data & Analytics Organization (DAO) 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. The EDW team is in the process of migrating to a Cloud Data platform and looking for a Cloud enthusiast as they move to Azure Cloud. You will directly report to the Manager of the Enterprise Data Warehouse and will develop and revise the most complex conceptual, logical, and physical data models for the Enterprise. You will build and maintain a deep understanding of the data and analytic landscape across the hospitals including data sources, data and analytic assets and products, analytic tools and software, and master data. The Sr. Data Warehouse Architect will also act as the Technical Lead on data projects and guide and mentor other Data Architects and Data Engineers. You will work with the business to determine database structural requirements and review various objectives with business partners. The Sr. Data Architect will also develop and revise data dictionary definitions and provide input to data governance practices and standards including security and privacy standards.



If you are interested in working in a healthcare environment for a company that encourages great culture and collaboration, let's set up a time to chat!

Required Skills & Experience

* 8+ years of experience as a Data Architect (including data architecture design and deployment, data modeling especially dimensional data modeling (OLAP), and database development)

* Dimensional modeling experience

* Demonstrated understanding of overall data architecture

* Strong experience in SQL Programming

Nice to Have Skills & Experience

- Experience working for a healthcare organization

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.