Data Engineer II - ETL

Lumere, a GHX company, is at the forefront of clinical decision making for medical devices. We offer evidence-based software solutions and services that empower health systems across the US to reduce unwarranted variation and provide high-value care for their patients. Lumere has offices in Chicago, but we primarily work remotely across the country.
The ETL-focused Data Engineer II will work on some of our most impactful data problems alongside other ETL engineers and analysts. This role will support development, execution, and monitoring of scalable, automated pipelines for collecting data from our healthcare system subscribers and third-party data sources. We treat these resources as a product to provide accurate and timely data for internal teams and externally to our clients. Our stack includes Clover, Kubernetes, Redis, Postgres, and Python and we manage our work through AWS tools and Docker.
You will thrive if you love exploring datasets, applying novel data management processes, identifying and implementing performance improvements, and collaborating cross-functionally to solve challenging data engineering problems in healthcare.
As an ETL-focused Data Engineer II at Lumere, you will:

• Work with business and technical staff to distill technical requirements from business requests, applying agile principles to iterate quickly and obtain feedback
• Design, develop, and maintain HIPAA-compliant, scalable, performant, and reliable data pipelines and processes
• Map healthcare data to proprietary data structures, assess data quality, support data cleansing, and collaborate on development of QA test plans for incoming and stored data
• Ship well-tested, secure, and maintainable code by utilizing development practices such as continuous deployment, code review, and technical documentation of data lineage and processes
• Clearly and concisely write advanced SQL queries or Python scripts to standardize and enhance data assets
• Become a subject matter expert (SME) in the domain of healthcare data, and communicate the intricacies and downstream impacts of this data to stakeholders
• Support software configuration and integration activities

Necessary requirements for you to hit the ground running :

• Have a BS degree or equivalent practical experience: the major doesn't matter and could be from CS, public health, math, or pre-med; what does matter is your expertise and interest in building and maintaining impactful healthcare data pipelines
• Experience using ETL tools (e.g., CloverDX, SSIS) to stage and transform data, and conduct performance optimization
• Operate as an empathetic team player, contributing to team objectives, displaying trust and mutual understanding, accepting feedback, and handling disagreement constructively
• Articulate technical concepts, designs, and data issues to cross-functional teams who have varying levels of technical experience
• Are proactive and take the initiative to implement improvements
• Are data driven, testing and measuring whatever you can
• Display an ability to learn rapidly and adapt quickly to changing situations
• Have a user-centric and security-first mindset to designing cloud-based data systems

You'll be a great fit if you have at least two years of relevant professional data engineering experience demonstrating some combination of:

• Familiarity with healthcare data rules and standards (such as HIPAA) from working with health or healthcare data (especially from EHR/EMR systems like Epic or Cerner)
• Working with product management and design teams through the full cycle of data system or software development in an agile development environment
• Developing data pipelines with cloud services and tools (AWS, Azure, GCP, Snowflake)
• Automated test frameworks (pgTAP, tSQLt) and monitoring tools and procedures in a data infrastructure environment (Datadog, Great Expectations)
• Deploying code in a containerized, continuous integration, and automated deployment environment (Kubernetes, Docker)
• Software engineering, modern application development, or API development
• Using DAG/workflow management tools (Airflow)

Estimated Salary range for this position: $75,000-$100,000
The base salary range represents the anticipated low and high end of the GHX's salary range for this position. Actual salaries will vary and will be based on various factors, such as candidate's qualifications, skills, competencies and proficiency for the role. The base salary is one component of GHX's total compensation package for employees. Other rewards and benefits include: health, vision, and dental insurance, accident and life insurance, 401k matching, paid-time off, and education reimbursement, to name a few. To view more details of our benefits, visit us here: https://www.ghx.com/about/careers/
#LI-Remote #LI-MC
GHX: It's the way you do business in healthcare
Global Healthcare Exchange (GHX) enables better patient care and billions in savings for the healthcare community by maximizing automation, efficiency and accuracy of business processes.
GHX is a healthcare business and data automation company, empowering healthcare organizations to enable better patient care and maximize industry savings using our world class cloud-based supply chain technology exchange platform, solutions, analytics and services. We bring together healthcare providers and manufacturers and distributors in North America and Europe - who rely on smart, secure healthcare-focused technology and comprehensive data to automate their business processes and make more informed decisions.
It is our passion and vision for a more operationally efficient healthcare supply chain, helping organizations reduce - not shift - the cost of doing business, paving the way to delivering patient care more effectively. Together we take more than a billion dollars out of the cost of delivering healthcare every year. GHX is privately owned, operates in the United States, Canada and Europe, and employs more than 1000 people worldwide. Our corporate headquarters is in Colorado, with additional offices in Europe, Illinois, Florida, and Nebraska.
Disclaimer
Global Healthcare Exchange, LLC and its North American subsidiaries (collectively, "GHX") provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. All qualified applicants will receive consideration for employment without regard to any status protected by applicable law. This EEO policy applies to all terms, conditions, and privileges of employment, including hiring, training and development, promotion, transfer, compensation, benefits, educational assistance, termination, layoffs, social and recreational programs, and retirement.
GHX believes that employees should be provided with a working environment which enables each employee to be productive and to work to the best of his or her ability. We do not condone or tolerate an atmosphere of intimidation or harassment based on race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. GHX expects and requires the cooperation of all employees in maintaining a discrimination and harassment-free atmosphere. Improper interference with the ability of GHX's employees to perform their expected job duties is absolutely not tolerated.