Data Warehouse Architect

Hebrew SeniorLife Hospice Care; Boston (MA); Presencial; USD 140.000 - 200.000; Jornada completa

Descripción de la vacante

Hebrew SeniorLife Hospice Care is seeking a Data Warehouse Architect and Technology Innovation Engineer to design, develop, and optimize data warehouses supporting BI and analytics across the organization. You will collaborate with IT, clinical and operational leaders to innovate, assess new technologies, and ensure data accuracy, security, and governance.

A strong background in data warehousing, SQL, ETL/ELT, and healthcare data systems is essential.

Formación

• 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 in a data warehouse environment.
• Experience with electronic health records and healthcare applications.
• PowerShell and Python for automation and data pipelines.
• Hands-on experience with Databricks (Spark, Delta Lake, notebooks, Workflows, Unity Catalog or similar governance tooling).
• Advanced proficiency in SQL and in database query, reporting, and BI tools.
• Working knowledge of Linux environments and migrating Linux-based systems.

Responsabilidades

• Identifies data requirements by interviewing customers and analyzing department applications, programming, and operations.
• Identifies sources of data to populate the data warehouse.
• Defines database structure, security, backup, and recovery specifications.
• Maintains database performance and evaluates computer operating systems and hardware products.
• Provides training and support to users; resolves problems.
• Maintains data lineage and governance documentation.

Conocimientos

Data warehousing

Database design

ETL/ELT

SQL proficiency

Analytics dashboards

HIPAA security

Leadership

PowerShell

Python

Communication

Educación

Bachelor's degree in IT/Health Informatics

Herramientas

Databricks

Unity Catalog

Linux

Descripción del empleo

Job Description:

Position Summary:

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.
• 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 platf