Senior Data Engineer, Onboarding

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

📋 Description

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

• Ingest, parse, transform, and map 837I/P/D claims, 835 remittance advice, and EMR data to the MDaudit data model.

• Construct and enhance Snowflake data models, SQL transformations, and warehousing operations.

• Migrate and convert data from legacy systems and databases such as Microsoft SQL Server.

• Create reusable frameworks, tools, and automation using Python, PySpark, and SQL.

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

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

• Integrate and validate EMR data—including Epic, Cerner, Meditech, and Athenahealth—with claims data.

• Collaborate with Implementation, Product, Support, and IT teams regarding requirements, data mapping, and priorities.

• Address onboarding escalations through root-cause analysis and establish permanent solutions.

• Track onboarding tasks, escalate risks, and provide status updates to internal stakeholders.

• Document pipelines, data flows, and runbooks, and transition completed work to Support.

• Mentor junior engineers, perform code reviews, and disseminate technical knowledge.

• Ensure compliance with HIPAA, regulatory requirements, data integrity, and security.

⛳️ Requirements

• Bachelor's degree in Computer Science, Data Science, Health Informatics, Information Systems, or a related field, or equivalent experience.

• Over 8 years of experience in data engineering, ETL/ELT, and data warehousing.

• At least 3 years of programming experience with Python and advanced SQL.

• Minimum of 2 years of hands-on experience with Databricks, including Delta Lake, notebooks, jobs/workflows, and PySpark.

• Practical experience with Snowflake, encompassing data modeling and SQL transformations.

• A minimum of 2 years of experience in the healthcare industry, preferably in revenue cycle management (RCM).

• Comprehensive understanding of healthcare billing processes, claims lifecycle, and reimbursement models.

• Familiarity with healthcare EDI (X12) transaction data and claims/remittance processing.

• Experience with cloud platforms such as AWS or Microsoft Azure.

• Strong understanding of healthcare revenue cycle processes and familiarity with SaaS applications.

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

• Strong written and verbal communication skills with both technical and non-technical colleagues.

• Collaborative and team-oriented working approach.

• Ability to thrive in a fast-paced environment.

• Capacity to comply with HIPAA and other regulatory requirements while maintaining data integrity and security.

🏝️ 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.

• Opportunities for career growth and advancement.

• Remote work arrangement.