Healthcare Data Engineer (LANES)

See job description

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.   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, exempt, benefitted position. Employment is provided by Heluna Health. The pay rate for this position is $150,000-$180,000 annually 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 NON-ESSENTIAL FUNCTIONS
• Other duties as assigned JOB QUALIFICATIONS Education / Experience
• A bachelor’s degree in computer science or a related field. 5 year data engineering experience in healthcare. 5 year hands-on SQL development experience
• 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 postgres and Google BigQuery
• Experience with Microsoft PowerBI
• Experience with cloud-based data platforms (AWS and / or Google Cloud Services)
• Familiarity with Clinical Informatics concepts, terminologies, and coding systems including ICD-10, SNOMED CT, LOINC, and CPT.
• Good software documentation skills
• 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
• Experience with dashboard development
• 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
• Experience working as a member of Agile Scrum project teams.
• Ability to work collaboratively using Atlassian JIRA, Confluence, 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 / Licenses / Clearances
• Successful clearance of background and reference check. 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 25 lbs.
• Push / Pull=Occasionally - Up to 25 lbs.
• See=Constantly
• Taste / Smell=Not Applicable Key
• Not Applicable :  Not required for essential functions
• Occasionally :  (0 - 2 hrs. / day)
• Frequently :  (2 - 5 hrs. / day)
• Constantly :  (5 hrs. / day) WORK ENVIRONMENT General Office Setting, Indoors Temperature Controlled. APLICATION PROCEDURES Interested candidates should submit a resume and cover letter for consideration.   EEOC STATEMENT It is the policy of Heluna Health to provide equal employment opportunities to all employees and applicants, without regard to age (40 and over), national origin or ancestry, race, color, religion, sex, gender, sexual orientation, pregnancy or perceived pregnancy, reproductive health decision making, physical or mental disability, medical condition (including cancer or a record or history of cancer), AIDS or HIV, genetic information or characteristics, veteran status or military service.   Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Salary : $150,000 - $180,000