Data Warehouse Architect

Hebrew Rehabilitation Center•Roslindale, MA

5d•Hybrid

About The Position

The Data Warehouse Architect and Technology Innovation Engineer identifies customer and organizational data needs; manages and implements data procedures and standards; designs and develops databases and data models; distributes data management practices; and manages information. The position designs, develops, and optimizes flexible, scalable data warehouses to support business users and business intelligence applications. It ensures data accuracy, protection, and encryption; analyzes data and presents reports to executives; and serves as a liaison between IT and other departments. The role works with IT, operational leaders, and the Applications, Technology Operations, and IT Security groups to assess and implement innovative technologies in support of the organization’s mission to Lead the Field of Aging. The position identifies data requirements and sources, recommends database structures and capabilities, and supports database security, backup, recovery, performance, maintenance, and installation. It trains users, answers requests, maintains service and quality standards, and documents data sources, schemas, transformations, refresh cadence, and lineage so internal staff can support and troubleshoot the environment independently of third-party vendors. The role requires creativity, customer service, timely and accurate project delivery, and the ability to balance changing priorities.

Requirements

Bachelor’s degree in Information Technology, Healthcare Informatics, Public Health, or a related field; an 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.
Experience with electronic health records, health information systems, and healthcare applications.
Experience with scripting languages such as PowerShell and Python for automation and data pipeline work.
Hands-on experience with Databricks, including Spark, Delta Lake, notebooks, Workflows, and Unity Catalog or similar governance tooling.
Advanced proficiency in SQL and database query, reporting, and BI tools.
Working knowledge of Linux environments and experience migrating Linux-based systems and workloads to standard, supported platforms.
Expertise in database performance tuning, database security, process improvement, problem solving, presenting technical information, quality focus, database management, data maintenance, operating systems, attention to detail, and information security policies.
Exceptional customer service skills, attention to detail, and timeliness.
Ability to identify customer requirements and design and develop solutions that address them.
Ability to keep current with industry trends and developing technologies and to work with operational leaders to analyze challenges and propose technological solutions.
Strong business and leadership acumen; in-depth knowledge of data warehousing concepts and database design, structure, and operational use.
Mastery of database query and reporting tools, including the ability to construct efficient queries, combine results meaningfully, and interpret results.
Strong understanding of data ingestion and transformation techniques, including ETL/ELT.
Proficiency with analytics, dashboarding, and presentation tools.
Ability to comply strictly with patient and employee confidentiality policies, procedures, and regulations, and familiarity with and adherence to IT and HIPAA security regulations.
Ability to balance workload and adjust to shifting priorities; work well in a team; and demonstrate excellent organization, interpersonal, and communication skills.
Ability to travel to HSL local facilities.
Ability to lift light computer equipment.

Nice To Haves

Workday Pro certification in 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 such as LangChain or LlamaIndex in a secure, on-premises environment.
Databricks certification, such as Data Engineer Associate or Professional, or similar.
Experience with cloud platforms such as Azure or AWS and modern data orchestration tools such as Airflow or 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, and strong project management skills.

Responsibilities

Identify data requirements by interviewing customers, analyzing applications and operations, evaluating existing systems, and designing proposed systems.
Identify data sources that can populate the data warehouse.
Recommend database physical structures and functional capabilities, security, backup, and recovery specifications.
Install new or revised systems by proposing specifications and flowcharts, recommending access techniques, and coordinating installation requirements.
Maintain database performance by calculating parameter values, implementing releases, completing maintenance, and evaluating operating systems and hardware products.
Prepare users through training, information, and problem resolution.
Provide information by responding to questions and requests.
Establish and enforce organizational standards to maintain quality service.
Maintain professional and technical knowledge through education, publications, professional networks, benchmarking, and professional societies.
Document and maintain detailed knowledge of data in the HSL environment, including sources, schemas, transformations, refresh cadence, and data lineage, enabling internal support and troubleshooting without third-party vendors.
Contribute to team efforts and perform related tasks as needed.
Provide exceptional customer service and complete projects accurately and on time.
Work with IT and operational leaders to assess challenges and propose technological solutions, and collaborate with Applications, Technology Operations, and IT Security groups to assess and implement innovative technologies.
Ensure data moving through the system is accurate and appropriately protected and encrypted.
Analyze data and present reports to executives; serve as a liaison between IT and other departments.