What you'll own in this role
Acquire and integrate data from multiple source systems, ensuring accuracy and consistency.
Design, implement, and maintain scalable database solutions for long-term reliability and performance.
Build automated, sustainable solutions while minimizing defects and technical debt.
Evaluate and optimize system architecture to improve uptime and responsiveness.
Develop and maintain ETL processes and data pipelines.
Perform data mapping, integration, and quality checks to ensure valid and relevant data.
Troubleshoot and resolve complex data issues and database stability problems.
Optimize SQL queries, indexes, and stored procedures for maximum efficiency.
Participate in code reviews and ensure compliance with standards and best practices.
Incorporate unit and regression testing for defect-free builds and releases.
Maintain compliance with security and privacy regulations (e.g., HIPAA).
What you bring to the role
Proficiency in SQL and relational database principles.
2+ years of experience with RDBMS (e.g., SQL Server, Oracle) and SQL optimization techniques.
Experience with ETL concepts, data integration, and troubleshooting.
Strong analytical and problem-solving skills.
Familiarity with high-volume OLTP environments and performance tuning strategies.
Working knowledge of NoSQL technologies (e.g., MongoDB, Elasticsearch).
Exposure to cloud platforms (Microsoft Azure preferred).
Ability to work independently and communicate effectively with technical and non-technical stakeholders.
You may also bring this
Experience with stored procedures, T-SQL, and SSIS.
Knowledge of HL7, CCD documents, and EDI X12 claims processing.
Familiarity with Agile/Scrum development methodologies.
Understanding of data structures (XML, JSON) and REST API integration.
Experience with Big Data technologies (e.g., Hadoop).
Git and version control proficiency.
Preferred Experience & Education
Bachelor’s degree in Computer Science, Information Technology, or related field.
2+ years of experience in technology or healthcare-related data engineering roles.
Information Security and Compliance Responsibilities
Maintain compliance with training directives required by the organization pertaining to Information Security, Acceptable Use Policy and HIPAA Privacy and Security.
Adhere to and comply with the organizations Acceptable Use Policy.
Safeguard information system assets by identifying and reporting potential and actual security events to the organization Security and Compliance Officers.
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.
