Data Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design and sustain ETL/ELT pipelines on Databricks utilizing PySpark and Python, adhering to a Bronze/Silver/Gold lakehouse architecture.

• Integrate customer healthcare data by ingesting, parsing, and transforming 837 claims, 835 remittance, and EMR data.

• Accurately map customer data to the MDaudit data model.

• Assist in the conversion and migration of data from legacy systems such as Microsoft SQL Server.

• Create automation and reusable tools in Python, PySpark, and SQL to enhance ETL processes and minimize manual onboarding efforts.

• Implement automated data validation, quality checks, and reconciliation, and address discrepancies.

• Oversee, maintain, and troubleshoot customer data feeds and file processing following setup.

• Work collaboratively with Implementation, Product, Support, and IT teams on requirements and data mapping.

• Address onboarding challenges, conduct root-cause analyses, and escalate intricate issues to senior engineers.

• Ensure assigned onboarding tasks remain on schedule in project management tools like Monday.com and provide consistent status updates.

• Document pipelines, data flows, and runbooks to facilitate handoff to Support.

• Comply with HIPAA and other regulatory standards while ensuring data integrity and security.

• Aid in the onboarding and conversion of customer healthcare data for MDaudit’s revenue cycle and compliance platform.

⛳️ Requirements

• Bachelor’s degree in computer science, Data Science, Health Informatics, Information Systems, or a related field, or equivalent professional experience.

• 3+ years of experience in data engineering, ETL/ELT processes, and data warehousing.

• 2+ years of programming experience in Python and SQL.

• 1+ year of practical experience with Databricks and PySpark.

• Proficient knowledge of Snowflake and SQL transformations.

• 1+ year of experience in the healthcare sector, ideally in revenue cycle management (RCM).

• Understanding of healthcare billing practices and the claims lifecycle.

• Familiarity with healthcare EDI (X12) transaction data and its application in claims and remittance processing.

• Knowledge of cloud platforms (AWS or Microsoft Azure).

• Strong grasp of healthcare revenue cycle processes and experience with SaaS applications.

• Excellent analytical and problem-solving abilities with a keen attention to detail.

• Strong written and verbal communication skills, capable of engaging with both technical and non-technical colleagues.

• Team-oriented, collaborative work style.

• Ability to thrive in a fast-paced environment.

🏝️ Benefits

• On-demand learning program.

• Remote Cooking Classes, Yoga Sessions & Mixology Classes.

• Medical, Dental & Vision Coverage.

• 401K with company match.

• Unlimited vacation policy.

• Peer Nominated Awards & Recognition.

• Career growth and advancement opportunities.