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. Health Catalyst has been named as one of the 30 Best Workplaces in Technology by Fortune Magazine and a winner of Gallup Great Workplace award. Health Catalyst earned the highest overall score in Healthcare BI by KLAS and, for the sixth year in a row, was named to the Best Places to Work in Healthcare list by Modern Healthcare. Health Catalyst is a leading provider of data and analytics technology and services to healthcare organizations, and is committed to being the catalyst for massive, measurable, data-informed healthcare improvement. As of December 31, 2019, Health Catalyst served greater than 125 customers including academic medical centers, integrated delivery networks, community hospitals, large physician practices, ACOs, health information exchanges, health insurers, and other risk-bearing entities. Its customers leverage the cloud-based data platform—powered by data from more than 100 million patient records and encompassing trillions of facts—as well as its analytics software and professional services expertise to make data-informed decisions and realize measurable clinical, financial and operational improvements. Health Catalyst envisions a future in which all healthcare decisions are data informed. Learn more about working at Health Catalyst here. 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 four team member resource groups include: Shades, Queers & Allies, Women Empowered, InspireAsian, Neurodivergent, and Veterans. We offer best in class benefits that encourage ownership and inclusion: mentoring and sponsorship programs, remote-work friendliness, career development, company equity, and flexible PTO.