Data Engineer, Onboarding

<h3>Accountabilities:</h3><li>Develop, implement, and maintain ETL/ELT data pipelines using Databricks, PySpark, and Python, following a Bronze/Silver/Gold lakehouse architecture.</li><li>Ingest, parse, transform, and validate healthcare data, including 837 healthcare claims, 835 remittance advice, and electronic medical record (EMR) data, ensuring accurate mapping to the target platform's data model.</li><li>Support data conversion and migration initiatives, including transitioning information from legacy systems such as Microsoft SQL Server to modern cloud-based data platforms.</li><li>Build reusable automation tools and data processing workflows using Python, PySpark, and SQL to reduce manual onboarding activities and improve operational efficiency.</li><li>Implement automated data validation, quality controls, and reconciliation procedures to identify inconsistencies, maintain data integrity, and resolve discrepancies promptly.</li><li>Monitor and maintain customer data feeds and file-processing workflows following implementation, troubleshooting failures and ensuring reliable ongoing operations.</li><li>Collaborate with Implementation, Product, Support, and IT teams to gather technical requirements, define data mappings, resolve integration challenges, and coordinate customer onboarding activities.</li><li>Investigate data ingestion and integration issues, perform root-cause analysis, and escalate complex technical problems to senior engineering team members when necessary.</li><li>Track assigned onboarding tasks and project milestones using project management tools such as Monday.com, providing regular progress updates and helping ensure timely delivery.</li><li>Document data pipelines, transformation logic, data flows, and operational procedures to facilitate knowledge transfer and effective handoffs to Support teams.</li><li>Apply appropriate data security, privacy, and access controls while adhering to HIPAA requirements and other relevant healthcare regulations.</li><li>Contribute to continuous improvement initiatives by identifying opportunities to optimize pipeline performance, strengthen data quality, and standardize onboarding processes.</li><li>Perform additional engineering and data integration responsibilities as needed to support team objectives.</li><h2>Requirements:</h2><li>
<strong>Education:</strong>Bachelor's degree in Computer Science, Data Science, Health Informatics, Information Systems, or a related field, or equivalent practical experience.</li><li>
<strong>Professional experience:</strong>At least three years of experience in data engineering, ETL/ELT development, and data warehousing.</li><li>
<strong>Programming expertise:</strong>A minimum of two years of hands-on experience with Python and SQL, including data transformation, automation, and troubleshooting.</li><li>
<strong>Databricks and PySpark:</strong>At least one year of practical experience using Databricks and PySpark to develop, maintain, and optimize data pipelines.</li><li>
<strong>Data warehousing:</strong>Working knowledge of Snowflake and SQL-based transformation techniques, with an understanding of modern cloud data architecture and lakehouse patterns.</li><li>
<strong>Healthcare industry experience:</strong>At least one year of experience in healthcare, preferably in revenue cycle management (RCM), with a solid understanding of healthcare billing, reimbursement, and the claims lifecycle.</li><li>
<strong>Healthcare data standards:</strong>Working knowledge of healthcare Electronic Data Interchange (EDI), particularly X12 transaction formats used for claims and remittance processing, including 837 and 835 transactions.</li><li>
<strong>Healthcare systems:</strong>Familiarity with electronic medical record systems, healthcare data integration, and the challenges associated with mapping and migrating data from different source systems.</li><li>
<strong>Cloud technologies:</strong>Familiarity with cloud platforms such as AWS or Microsoft Azure and their application to data engineering workflows.</li><li>
<strong>Data quality and troubleshooting:</strong>Ability to develop validation checks, reconcile datasets, investigate data discrepancies, and perform systematic root-cause analysis.</li><li>
<strong>Healthcare compliance:</strong>Understanding of data privacy, information security, and regulatory considerations, including HIPAA requirements for sensitive healthcare information.</li><li>
<strong>Analytical and problem-solving skills:</strong>Strong attention to detail and the ability to analyze complex datasets, resolve technical issues, and develop reliable, scalable solutions.</li><li>
<strong>Communication skills:</strong>Excellent written and verbal communication, with the ability to explain technical concepts and collaborate effectively with both technical and nontechnical colleagues.</li><li>
<strong>Teamwork and collaboration:</strong>A cooperative, team-oriented approach and the ability to work across engineering, implementation, product, support, and IT functions.</li><li>
<strong>Organization and time management:</strong>Ability to manage multiple onboarding tasks, maintain accurate documentation, track project milestones, and meet deadlines in a fast-paced environment.</li><li>
<strong>Adaptability and initiative:</strong>Willingness to learn new technologies, improve existing workflows, and contribute to evolving data engineering practices within a growing technology environment.</li><h2>Benefits:</h2><li>
<strong>Competitive compensation:</strong>Annual salary ranging from<strong>$125,000 to $135,000</strong>.</li><li>
<strong>Fully remote work:</strong>Work remotely within the United States.</li><li>
<strong>Comprehensive healthcare coverage:</strong>Medical, dental, and vision insurance.</li><li>
<strong>Retirement benefits:</strong>401(k) plan with employer matching contributions.</li><li>
<strong>Flexible paid time off:</strong>Unlimited vacation policy, designed to encourage employees to take time off and return refreshed.</li><li>
<strong>Learning and development:</strong>Access to an on-demand learning program to support continuous professional growth and technical skill development.</li><li>
<strong>Employee recognition:</strong>Peer-nominated awards and recognition programs that celebrate contributions and achievements.</li><li>
<strong>Team-building activities:</strong>Opportunities to participate in virtual cooking classes, yoga sessions, mixology classes, and other team activities.</li><li>
<strong>Career advancement:</strong>Opportunities to develop professionally, expand technical expertise, and pursue career growth within the organization.</li><li>
<strong>Inclusive workplace culture:</strong>A commitment to diversity, inclusion, and respect for different backgrounds, perspectives, and skills.</li><li>
<strong>Meaningful work:</strong>The opportunity to help healthcare organizations improve revenue cycle operations and compliance through reliable, data-driven technology solutions.</li>