Health Catalyst

Compensation

Full Description

Join one of the nation’s leading and most impactful health care performance improvement companies. Over the years, Health Catalyst has achieved and documented clinical, operational, and financial improvements for many of the nation’s leading healthcare organizations. We are also increasingly serving international markets. 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 Data Engineer, Senior – Vital CDM (Vitalware) Department: Product Development Reports To: Manager, Data Engineering Employment Type: Full-time Location: Remote, US Position Overview 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. 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 Engineering. This position includes helping scale and refactor an existing public facing website database and related services, moving resources to Azure, creating and releasing new features for the product, and managing related backend data services. This is a small dynamic team and a great opportunity to shape the future of a meaningful product. You will be expected to help support and expand the current product while thinking about scale and the future with Azure PaaS. What you'll own in this role: 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. Research, identify, analyze and correct any technical issues receiving claim transactions and/or provider data. Resolve complex data issues and perform quality data checks Receive and understand business requirements and create data mapping specifications Integrate client’s data into our product suite Maintain and optimize several complex databases. Investigate and troubleshoot complicated database applications and stability issues. Ensure MSSQL 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. What you'll bring to this role: BS or MS in Computer Science or equivalent professional experience. 6+ years MSSQL 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 Extended Events or similar, Statistics and their role). 3+ years of experience with high transaction OLTP environment with 4+ TB in size. A solid understanding of data structures (e.g., XML/SGML/DTD/JSON). A solid understanding of parsing and transforming JSON data in SQL Server. 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 Skill and Ability Requirements 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. NOTE: This job description is not intended to be all-inclusive. Applicants may perform other related duties as negotiated to meet the ongoing needs of the organization. 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. Studies show that candidates from underrepresented groups are less likely to apply for roles if they don’t have 100% of the qualifications shown in the job posting. While each of our roles have core requirements, please thoughtfully consider your skills and experience and decide if you are interested in the position. If you feel you may be a good fit for the role, even if you don’t meet all of the qualifications, we hope you will apply. If you feel you are lacking the core requirements for this position, we encourage you to continue exploring our careers page for other roles for which you may be a better fit. 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. Important Notice: Beware of Fraudulent Job Postings Health Catalyst has recently become aware of fraudulent job postings and recruitment activities impersonating our company on various job boards and social media platforms. These postings may include fake job offers, requests for personal information, or attempts to collect payment from applicants. Please note: Health Catalyst never asks for payment or financial information during the recruiting process All legitimate job openings are listed on our official career page Communications from Health Catalyst will come from official company email addresses ending @healthcatalyst.com and/or healthcatalyst@myworkday.com If you encounter a suspicious posting or communication claiming to represent Health Catalyst: Do not share personal or financial information. Report the incident to us immediately at careers@healthcatalyst.com. You may also report fraudulent activity to the job board or social media platform where it appeared. Your safety and trust are important to us. Thank you for helping us maintain the integrity of our hiring process. About Us: Health Catalyst is a leading provider of data and analytics technology and services that ignite smarter healthcare, lighting the path to measurable clinical, financial, and operational improvement. More than 1,100 organizations worldwide rely on Health Catalyst's offerings, including our cloud-based technology ecosystem, Health Catalyst Ignite™, AI-enabled data and analytics solutions, and expert services to drive meaningful outcomes across hundreds of millions of patient records. Powered by high-value data, standardized measures and registries, and deep healthcare domain expertise, Ignite helps organizations transform complex information into actionable insights. Backed by a multi-decade mission and a proven track record of delivering billions of dollars in measurable results, Health Catalyst continues to serve as the catalyst for massive, data-informed healthcare improvement and innovation. Health Catalyst has cultivated a workplace culture that recognizes, values, and supports each individual. This commitment to a compassionate and inclusive work environment has earned Health Catalyst more than 100 "Best Place to Work” awards to date, including multiple prestigious awards for its exemplary culture in 2025: Women Tech Council's Shatter List Modern Healthcare's Best Place to Work in Healthcare U.S. News & World Report's Best Companies to Work For Newsweek's America's Greatest Workplaces for Diversity Newsweek's America's Greatest Workplaces for Gen Z Newsweek's America’s Greatest Workplaces in Tech Becky Vea, Associate Chief People Officer at Health Catalyst, Awarded the HR Achievement Award by Utah Business At Health Catalyst, we celebrate and are committed to diversity and inclusion across all dimensions, including but not limited to race, gender, identity, age, and religion. Our six team member resource groups include: Shades; Queers & Allies; Women Empowered; InspireAsian; Neurodivergent; and Military, Veterans, Families, and Allies. We offer best-in-class benefits designed to promote ownership, inclusion, and a healthy work-life balance. Our team enjoys a remote-first work environment, flexible PTO, a professional development stipend, and meaningful opportunities for career growth and development.