Data Engineer. Sr. (Vitalware)

Health Catalyst

Remote / United States of America
  • Job Type: Full-Time
  • Function: Data Science
  • Post Date: 06/14/2021
  • Website: healthcatalyst.com
  • Company Address: 3165 East Millrock Drive Suite 400, Salt Lake City, UT, 84121

About Health Catalyst

Comprehensive performance management and predictive analytics platform for health systems

Job Description

Our mission is to be the catalyst for massive, measurable, data-informed healthcare improvement through:

    Data: integrate data in a flexible, open & scalable platform to power healthcare’s digital transformation​
    Analytics: deliver analytic applications & services that generate insight on how to measurably improve​
    Expertise: provide clinical, financial & operational experts who enable & accelerate improvement​
    Engagement: attract, develop and retain world-class team members by being a best place to work​

Role: Sr. Data Engineer

Team: Vitalware

Location: US Remote

Travel: <10%, US

As part of the Health Catalyst mission to be the catalyst for massive, measurable, data-informed healthcare improvement, we are so excited to announce the addition of Vitalware team members, revenue cycle management products, and solutions to our family.

The Senior Data Engineer supports the Product Development department and is responsible for working with a team of web application and data engineers to implement database solutions for long term scalability, reliability and performance in a multi-platform, SaaS environment, leveraging both RDBMS and NoSQL Solutions.  This role requires working with several complex broker based high transactional databases, maintaining the existing system and will help create and shape the future data architecture for products.  The position requires cross-team communication, attention to detail and the ability to develop innovative technologies and approaches for building high availability data persistent systems.  The Senior Data Engineer takes direction from the Manager, Data Management.   

Duties and Responsibilities

    Implement features in collaboration with Product Managers and developers within Agile / Scrum methodology.

    Build solutions that are automated, scalable, and sustainable while minimizing defects and technical debt.

    Evaluate and analyze the current system architecture.  Create scalable solutions to improve uptime and responsiveness while providing direction for future state.

    Drive development effort End-to-End for on-time delivery of high-quality solutions that conform to requirements and comply with all applicable standards.

    Maintain and optimize several complex databases.

    Investigate and troubleshoot complicated database applications and stability issues.

    Ensure SQL databases are operational and provide valid and relevant data.

    Guide our efforts in all areas of database design, performance, and reliability.

    Participate in code reviews that include database changes and effectively communicate issues and risks.

    Integrate new products and software packages and ensure data produced is accurate.

    Optimize code for maximum scalability and maintainability.

    Incorporate unit testing and regression testing to ensure defect-free builds and releases.

Recommended Qualifications and Experience   

    BS or MS in Computer Science or equivalent professional experience.

    6+ years SQL Server and/or RDBMS experience with current technology required.

    6+ years SQL optimization experience required (Index optimization strategies, Data normalization/de-normalization strategies, Plan analysis, Recompilation, Caching and buffering, Optimization tools including SQL Server Profiler or similar, Statistics and their role).

    6+ years of experience with high transaction OLTP environment with 6+ TB in size.

    A solid understanding of data structures (e.g., XML/SGML/DTD/JSON).

    Experience writing complex and efficient SQL stored procedures.

    Deep SQL Server working knowledge including order of operations, transactions and concurrency, file tables and security, brokering technologies, transactional replication, indexing strategies and maintenance, backup and recovery models, multi-node clustering and high availability.

    Familiar with Git and branching strategies.

    Familiar with creating and/or consuming REST APIs using C#, NodeJS, Python, etc.

    Familiar with NoSQL (MongoDB and/or Elasticsearch).

    Azure knowledge highly desired.

    Demonstrable experience implementing enterprise-scale, high volume, high availability systems.

    Demonstrated ability to deliver major critical projects.  

    Experience with Agile and Scrum team development environments.

    Experience providing leadership, coaching, and/or mentoring to subordinate a group.  Experience acting as a lead or first-level supervisor a plus.

Skills and Ability  

    Must be well organized, accurate and detail oriented.

    Excellent written and verbal communication with technical and non-technical staff.

    Ability to work in complex code bases written by others.

    Strong organizational, presentation, interpersonal and consultative skills a must.

    Ability to manage multiple projects/tasks simultaneously.

    Good judgment and decision-making skills.

    Enthusiastic about sharing knowledge and experience.

    Maintains a positive and results-oriented attitude.

The above statements describe the general nature and level of work being performed in this job function.  They are not intended to be an exhaustive list of all duties, and indeed additional responsibilities may be assigned by Health Catalyst.

At Health Catalyst, we appreciate the opportunity to benefit from the diverse backgrounds and experiences of others. Because of our deep commitment to respect every individual, Health Catalyst is an equal opportunity employer.

Related Jobs

Sr. Director of Quality Management

Health Catalyst - Remote

Analytics Engineer (Intermediate/Sr. Level) - ASO

Health Catalyst - Remote

Data Engineer (Master Data Management)

Health Catalyst - Salt Lake City, UT, US

Director of Engineering - Technology Platform - Network

Health Catalyst - RemoteUnited States of America

Senior Build and Release Engineer

Health Catalyst - RemoteUnited States of America
Disclaimer: Local Candidates Only
This company does NOT accept candidates from outside recruiting firms. Agency contacts are not welcome.