Data Warehouse Architect

Hebrew Rehabilitation Center

Boston (MA)

Hybrid

USD 113,000 - 170,000

Full time

13 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Hebrew Rehabilitation Center seeks a Data Warehouse Architect and Technology Innovation Engineer to lead data models, warehousing, and BI integration in a HIPAA-conscious environment. The role partners with IT and clinical/operational leaders to assess new technologies and improve data processes.

You will design scalable data warehouses, ensure data accuracy and security, and present executives with actionable insights. Hybrid work in the Boston area supports collaboration and innovation.

Qualifications

  • Bachelor's degree or equivalent 10 years of related experience may be considered.
  • 5+ years in data warehouse design/development.
  • Hands-on Databricks experience (Spark, Delta Lake, notebooks).
  • Advanced SQL and BI tool proficiency.
  • Linux knowledge; migrate workloads to supported platforms.
  • Knowledge of data security, governance and HIPAA policies.

Responsibilities

  • Identify data requirements by interviewing customers and analyzing systems.
  • Design and implement data warehouse structures and data flows.
  • Ensure data accuracy, security, and encryption across systems.
  • Collaborate with IT, Operations, and security groups to test new technologies.
  • Maintain data quality, performance tuning, and backups/recovery.
  • Document data lineage, schemas, and refresh cadence.
  • Provide training and support to staff; deliver stakeholder reports.

Skills

Data warehousing concepts
Database design
ETL/ELT techniques
BI tooling
Leadership
Communication
Teamwork
Problem solving

Education

Bachelor's degree in IT/Healthcare Informatics/Public Health or related field

Tools

Databricks
SQL
Linux
Workday Prism Analytics
Power BI
SSRS/Crystal Reports

Job description

Job Description
Position Summary

Position Summary paragraph: The Data Warehouse Architect and Technology Innovation Engineer is responsible for identifying customer and organizational data needs, managing and implementing data procedures and standards, designing and developing databases and data models, distributing management practices for data, and managing information. The position will also work with the IT department and operational leaders to innovate, assess and test new technologies to the pursuit of our mission to Lead the Field of Aging. The Data Warehouse Architect designs, develops and optimizes data warehouses, with flexible and scalable data and architecture, to support business users and business intelligence (BI) applications. Daily tasks include ensuring that all data going through the system is accurate and appropriately protected and encrypted, analyzing data and presenting reports to executives, and working as a liaison between IT and other departments. Will work closely with members of the Applications, Technology Operations and IT Security group to assess and implement innovative technologies.

Core Competencies
  • Ability to identify and understand customer requirements and then design / develop solutions that successfully address those requirements
  • Keep current on new industry trends and developing technologies
  • Ability to liaise with Operational Leaders to analyze challenges and propose technological solutions
  • Strong business and leadership acumen
  • In-depth knowledge of data warehousing concepts
  • Strong understanding of database design, structure and operational use
  • Mastery of database query and reporting tools. Able to structure queries to pull data and accurately combine the results in a logical, meaningful and efficient manner. Able to interpret the results.
  • Strong understanding of data ingestion and transformation (ETL/ELT) techniques.
  • Proficiency with analytics/dashboarding/presentation tools
  • Ability to strictly abide by patient and employee confidentiality policies, procedures and regulations.
  • Familiarity and adherence to IT and HIPAA Security regulations
  • Ability to balance workload and adjust to shifting priorities
  • Able to work well in a team atmosphere.
  • Excellent organization skills
  • Excellent interpersonal and communication skills
Responsibilities/Accountability
  • Identifies data requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
  • Identifies sources of data that can be used to populate the data warehouse
  • Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
  • Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
  • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
  • Prepares users by conducting training; providing information; resolving problems.
  • Provides information by answering questions and requests.
  • Maintains quality service by establishing and enforcing organization standards.
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
  • Documents and maintains detailed knowledge of the data within the HSL environment, including sources, schemas, transformations, refresh cadence and data lineage, so that internal staff can support and troubleshoot independently of third party vendors.
  • Contributes to team effort by accomplishing related results as needed.
  • Performs a variety of tasks and a wide degree of creativity and latitude is expected
  • Provides exceptional customer service.
  • Completes projects accurately and on a timely basis.
Qualifications
Required
  • Bachelor's degree in Information Technology, Healthcare Informatics, Public Health or a related field. Equivalent of 10 years of relevant work experience may be considered in lieu of a degree.
  • Five or more years of related work experience, including experience designing and developing in a data warehouse environment.
  • Hands-on experience with Databricks (Spark, Delta Lake, notebooks, Workflows, and Unity Catalog or similar governance tooling).
  • Advanced proficiency in SQL and in database query, reporting, and BI tools.
  • Working knowledge of Linux environments, with experience migrating Linux-based systems and workloads to standard, supported platforms.
  • Expertise in: database performance tuning, database security, promoting process improvement, problem solving, presenting technical information, quality focus, database management, data maintenance, operating systems, attention to detail, information security policies
Preferred
  • Preferred: Workday Pro certification (Reporting, Integrations, or similar) or equivalent demonstrated experience.
  • Experience with Workday Prism Analytics.
  • Experience with retrieval-augmented generation (RAG), vector databases, and open-source LLM frameworks (e.g., Lang Chain, Llama Index) in a secure, on-premises environment.
  • Databricks certification (Data Engineer Associate/Professional or similar).
  • Experience with cloud platforms (e.g., Azure, AWS) and modern data orchestration tools (e.g., Airflow, Azure Data Factory).
  • Familiarity with creating and structuring data cubes and web-based reporting and deployment.
  • Experience with Microsoft SQL Server Reporting Services (SSRS), Power BI, or Crystal Reports.
  • Familiarity with medical center/hospital and senior care activities and operations.
  • Familiarity with Process Improvement and Lean methodologies, strong project management skills.
Requirements
  • Ability to travel to HSL local facilities.
  • Ability to lift light computer equipment.
  • Familiarity with Process Improvement and Lean methodologies
Remote Type

Hybrid

Salary Range

$113,141.00 - $169,711.00

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Architect
Data Warehouse Architect

Hebrew SeniorLife • Boston (MA)

Hybrid
USD 113,000 - 170,000
Hybrid work model
Data Warehouse Architect
Data Warehouse Architect

Hebrew SeniorLife, Inc. • Boston (MA)

Hybrid
USD 113,000 - 170,000
Data Engineer
Data Engineer

Shirley Ryan AbilityLab • Chicago (IL)

On-site
USD 71,000 - 125,000
Benefits package
Assistant Director of Enterprise Analytics
Assistant Director of Enterprise Analytics

DCH Health System • Tuscaloosa (AL)

On-site
USD 110,000 - 140,000
Sr. Data Architect
Sr. Data Architect

Sharp HealthCare • San Diego (CA)

On-site
USD 72,290 - 104,470
Sr. Data Architect healthcare san diego, ca
Sr. Data Architect healthcare san diego, ca

ESR Healthcare • Carlsbad (CA)

On-site
USD 130,000 - 160,000
Senior Data Engineer
Senior Data Engineer

Albert Heijn • United States

On-site
USD 97,000 - 181,000
Data Engineer
Data Engineer

South Texas Radiology Group, P.A. • San Antonio (TX)

On-site
USD 110,000 - 140,000
Data Architect – Healthcare Payer
Data Architect – Healthcare Payer

Employvision Inc. • Newtown Square

Hybrid
USD 120,000 - 155,000
Senior Data Engineer
Senior Data Engineer

Dell Medical School • Austin (TX)

On-site
USD 117,000 - 159,000