Data Engineer, Senior – Vital CDM (Vitalware)

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.