Data Engineer - Healthcare Reporting

Carina Health Network supports community health organizations across Colorado with technology, data, and resources to improve patient care and outcomes. The Healthcare Reporting Engineer will manage clinical data and develop data sources for clinical reporting within the Community Analytics Platform, while integrating healthcare code sets, validating data, and documenting reporting processes.

Responsibilities

Collaborate with internal teams and external stakeholders to translate clinical report requirements into technical specifications

Translate technical report specifications into high quality, clinical reporting data sources to be utilized by Carina Health Network business intelligence developers for production in the Community Analytics Platform

Provide automated solutions whenever possible and proactively suggest alternative solutions

Integrate standard healthcare code sets like LOINC, ICD-9/10-CM, CPT4, HCPCS, and SNOMED

Collaborate with internal teams and external and other stakeholders to maintain, enhance, and troubleshoot existing health reporting across programs

Ingest, normalize, and maintain population cohorts from a variety of input sources consistent with database management best practices

Develop data validation reports and analyses where applicable

Develop technical documentation of reports, processes, and automations

Utilize up-to-date knowledge of databases and data quality best practices to deliver effective reporting

Remain knowledgeable in healthcare data standards, measures, and code sets as well as applicable data privacy practices and legal requirements

Preferred

Bachelor's degree in data analytics, computer science, public health, or other health or technology-related field preferred, or equivalent experience

Data Analytics

Computer Science

Public Health

Health Technology

Benefits

Insured group health, dental, and vision plans (employer covers 100% of the cost for dental and vision)

Medical and dependent care flexible spending account options

Employer contributions of $900 annually toward a Health Reimbursement Arrangement (HRA) or Health Savings Account (HSA), depending on the health plan selected

401(k) retirement plan with up to a 4% employer contribution match

100% employer-paid life, AD&D, short-term, and long-term disability plans for employees

Free 24/7 access to confidential resources through an employee assistance program (EAP)

Voluntary benefit plans to complement health care coverage, including accident insurance, critical illness, and hospital indemnity coverage

17 days of paid vacation within one year of service

12 paid sick days accrued by one year of service

14 paid holidays (which includes two floating holidays)

One paid volunteer day

Employer-paid programs/courses for professional growth and development

Cell phone and internet reimbursement

Annual, all-expenses-paid staff retreat

Flexible work (remote or hybrid)

Supportive, mission-driven team

Opportunities to learn and grow

Company

Statewide network supporting community healthcare organizations with data infrastructure

Denver, Colorado, USA

https://carinahealthnetwork.org/

Founded in 1994

11-50 employees

Qualifications

Works in a SQL environment, especially with data transformation, stored procedures, and query development

Knowledge of data warehousing best practices, concepts, and processes

Ability to work with multiple complex data sources and collaborate with internal teams to identify solutions to ensure project success

Expertise in developing reporting for business intelligence solutions, knowledge of data structures, best practices, and health care related quality or performance measures

Strong analytical and problem-solving skills, with demonstrated change management experience

Knowledge of common healthcare code sets like LOINC, ICD-9/10-CM, CPT4, HCPCS, and SNOMED

Demonstrated ability to set and meet project timelines and deliverables

Effective interpersonal and communications skills with the ability to interact with various levels of personnel using plain language

Is flexible, organized, self-directed, able to prioritize multiple tasks, and able to manage a full workload

Experienced in Microsoft Office and Microsoft Operating Systems

Ability to work with minimal supervision and maximum accountability

Bachelor's degree in data analytics, computer science, public health, or other health or technology-related field preferred, or equivalent experience

Required skills

Microsoft SQL Server, Snowflake, Clinical Data Integration, Healthcare Data Warehousing, Business Intelligence Reporting, Healthcare Code Sets LOINC, Healthcare Code Sets ICD-9/10-CM, Healthcare Code Sets CPT4, Healthcare Code Sets HCPCS, Healthcare Code Sets SNOMED, Data Transformation, Stored Procedures, SQL Query Development, Healthcare Quality and Performance Measures, Data Validation, Microsoft Office

Experience

Mid level