Data Engineer, Senior – Vital CDM (Vitalware)

Health Catalyst

49d•Remote

About The Position

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.

Requirements

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

Nice To Haves

Azure knowledge highly desired.

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