Note: The job is a remote job and is open to candidates in USA. athenahealth provides healthcare technology solutions and services designed to support accessible, high-quality, and sustainable healthcare. The Lead Data Engineer will design and support ETL, data import, migration, transformation, export, and validation processes that move legacy healthcare data into athenahealth systems. The role collaborates with sales, product, implementation, operations, and engineering teams to resolve data issues and improve scalable migration workflows.
Responsibilities
- Develop and support ETL workflows that extract, transform, and load data from legacy EHRs systems into athenahealth environments
- Write and maintain functions used for data analysis, validation, reconciliation, and troubleshooting
- Build Python and SQL scripts and utilities that support import, migration, and automation activities
- Partner with internal teams to define source-to-target mappings, business rules, and migration requirements
- Review inbound and outbound data to identify gaps, defects, and transformation issues
- Support interoperability workflows using HL7 and FHIR standards
- Perform EHI export-related tasks and validate output for completeness and accuracy
- Investigate data issues, document findings, and help drive resolution across teams
- Maintain technical documentation for processes, dependencies, and validation steps
- Use AI to improve productivity in data analysis and development tasks, while applying human review to confirm accuracy and align outputs to the needs of the work
- Contribute to process improvements that increase the scalability and repeatability of migration work
- Support testing and validation activities for data import and export processes
- Participate in project planning, status updates, and issue triage as needed
- Help maintain reusable tools, templates, and standards for migration work
- Assist with documentation updates and knowledge sharing across the team
- Support coordination across product, implementation, operations, and engineering partners
- Help identify opportunities to reduce manual effort through automation and better process design
Skills
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience
- 5+ years of experience in data engineering, ETL, data migration, or a related technical discipline
- Experience working with ETL, SQL, and Python
- Experience supporting data imports, conversions, migrations, or similar data movement work
- Familiarity with HL7 and FHIR interoperability standards
- Ability to analyze data, identify issues, and document technical results clearly
- Ability to work effectively in a remote, cross-functional environment
- Strong problem-solving, communication, and collaboration skills
- Experience with EHI Export or related healthcare data export workflows preferred
- Experience working with healthcare data, healthcare technology, or implementation-focused teams preferred
Benefits
- Short- and long-term incentives, depending on role eligibility, through an annual discretionary bonus plan, variable compensation plan, and equity plans
- Health and financial benefits
- Location-specific commuter support
- Employee assistance programs
- Tuition assistance
- Employee resource groups
- Collaborative workspaces
- Flexible work arrangements that support work-life balance
- Digital collaboration tools
- Company-sponsored events, including book clubs, external speakers, and hackathons
- A company culture based on learning
- Support of an engaged team
- An inclusive environment where all employees are valued
Company Overview
Company H1B Sponsorship