Healthcare Data Engineer

Job Title: Healthcare Data Engineer

Location: Los Angeles, CA

Position Status: Full Time, Exempt

Reports to: Director of Technology Services

BACKGROUND

We have a diverse team of healthcare IT experts devoted to solving real-world healthcare problems. We’re looking for a driven, smart, creative, and fun candidate who shares our passion for optimizing the intersection of consumer health, engagement, technology, and innovation.

LANES is a community-based Qualified Health Information Organization (QHIO) whose mission is to improve health care delivery by building a platform that enables cost-effective and secure electronic exchange of patient medical records among public and private health care providers and health plans in the larger Los Angeles County region. LANES seeks to make personal health information available when and where it is needed for patient care, safely and securely.

LANES uses the Mirth technology, AWS cloud, Google Big Query and FHIR, to link healthcare organizations and to maintain the core technology infrastructure of the Health Information Organization.

Healthcare Data Engineer

Los Angeles Network for Enhaced Services (LANES) is a Qualified Health Information Organization (QHIO). We connect 250+ healthcare organizations in the Los Angeles region and exchange data on 15+ million persons in real time. LANES is a growing organization with dozens of new healthcare entities connected to our network each year. We are also an industry-leading organization with a state-of-the-art, proprietary technology platform.

LANES created a unique new opportunity for a talented and motivated Healthcare Data Engineer responsible for the development of LANES’ portfolio of SQL queries, stored procedures, dashboards, and other data and business intelligence products. By joining LANES, you will be able to learn from work-renowned experts in the fields of healthcare data interoperability and healthcare information technology. You could make an impact by changing healthcare and providing unique insights into healthcare data and by improving health outcomes, public health, and operational efficiencies.

Special Note: This is a virtual home-based position. Will be required to attend in-person meetings in Los Angeles area on an as-needed basis.

This is a full-time benefitted position.

ESSENTIAL FUNCTIONS

· Develop, document, and update SQL queries and stored procedures

· Develop clinical and operational reports

· Develop repeatable processes for reporting

· Develop and maintain dashboards and other Business Intelligence (BI) products providing actionable insights

· Develop data repositories and data analytics sandboxes for expert customers to execute their own queries and build their own analytics tools

· Optimize performance of large and complex queries.

· Contribute to strategy development for LANES’ future data products.

· Proactively identify new technologies, methodologies, and processes to address evolving data management challenges

JOB QUALIFICATIONS

· 5+ year data engineering experience in healthcare

· 5+ year hands-on SQL development experience

· Experience with Microsoft PowerBI

· Experience with postgres and Google BigQuery

· Experience with NodeJS

· Experience in relational and dimensional data modeling and schema design

· Experience with data architecture, data quality improvement, metadata, and data governance

· Experience with cloud-based data platforms (AWS and/or Google Cloud Services)

· Experience with dashboard development

· Familiarity with Clinical Informatics concepts, terminologies, and coding systems including ICD-10, SNOMED CT, LOINC, RxNorm, and CPT.

· Good software documentation skills

· BS degree in Computer Science or a related field.

· Familiarity with healthcare cybersecurity and privacy regulations and standards, e.g., HIPAA, HITECH, and HITRUST.

Other Knowledge, Skills, and Abilities

· Experience with ADT, CCD, DQ/DR messages and documents used in healthcare

· Experience with HL-7 and FHIR healthcare data standards

· Experience with Mirth Connect

· Experience with data modeling, data warehousing and building ETL pipelines

· Experience with Google Cloud Healthcare API

· Ability to work effectively independently and as a member of a diverse and cross-functional team of engineers, business system analysts, project managers, subject matter experts, management, and clinical stakeholders.

· Attention to detail and quality

· Ability to work in a fast-paced environment

· Experience working as a member of Agile Scrum project teams.

· Ability to work collaboratively using Atlassian JIRA, Confluence, Zephyr, and SharePoint productivity tools.

· Experience with big data in healthcare.

· Excellent problem-solving skills with a track record of ensuring data quality and integrity across complex datasets

Certificates/ License/ Clearance

· Successful background and reference check clearance.

PHYSICAL DEMANDS

Stand Frequently

Walk Frequently

Sit Frequently

Handling/ Fingering Occasionally

Reach Outward Occasionally

Reach Above Shoulder Occasionally

Climb, Crawl, Kneel, Bend Occasionally

Lift/ Carry Occasionally up to 50 lbs

Push/ Pull Occasionally up to 50 lbs

See Constantly

Taste/ Smell Not Applicable

Not Applicable Not required for essential functions

Occasionally (0-2 hrs/ day)

Frequently (2-5 hrs/ day)

Constantly (5+ hrs/ day)

WORK ENVIROMENT

General Office Setting, Indoors Temperature Controlled

Heluna Health is an Affirmative Action, Equal Opportunity Employer that encourages minorities, women, veterans, and disabled to apply.

Job Type: Full-time

Pay: $150,000.00 - $180,000.00 per year

Work Location: Hybrid remote in Los Angeles, CA 90064