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 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