Data Warehouse Architect
Role Overview
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.
Key Skills for This Role
Full Job Posting
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.
- Experience with electronic health record, health information systems and healthcare applications.
- Requires exceptional customer service skills, attention to detail and timeliness
- Experience with scripting languages such as PowerShell and Python for automation and data pipeline work.
- 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:
- 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
About Hebrew SeniorLife
Senior healthcare and housing provider.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Hebrew SeniorLife
Patient Care Associate Day Shift 24 hours
Roslindale, USA
Culinary Associate
Roslindale, USA
Patient Care Associate 16 Every Weekend Evening
Roslindale, USA
Expressive Therapist Assisted Living Dedham 40 hour
Dedham, USA
Nutrition Assistant I
Roslindale, USA
Affordable Housing Compliance Analyst 40 hour
Brookline, USA
Operations Associate
Randolph, USA
Life Safety & Incident Command Advisor Per Diem
Dedham, USA