Lead Data Engineer

Essential Job 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.

Additional Job Responsibilities:

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.

Expected Education & Experience:

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.

Experience with EHI Export or related healthcare data export workflows preferred.

Experience working with healthcare data, healthcare technology, or implementation-focused teams preferred.

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

Expected Compensation

The base salary range shown reflects the full range for this role from minimum to maximum. At athenahealth, base pay depends on multiple factors, including job-related experience, relevant knowledge and skills, how your qualifications compare to others in similar roles, and geographical market rates. Base pay is only one part of our competitive Total Rewards package - depending on role eligibility, we offer both short and long-term incentives by way of an annual discretionary bonus plan, variable compensation plan, and equity plans.

About athenahealth

Our vision:In an industry that becomes more complex by the day, we stand for simplicity. We offer IT solutions and expert services that eliminate the daily hurdles preventing healthcare providers from focusing entirely on their patients — powered by our vision to create a thriving ecosystem that delivers accessible, high-quality, and sustainable healthcare for all.

Our company culture:Our talentedemployees — or athenistas, as we call ourselves — spark the innovation and passion needed to accomplish our vision. We are a diverse group of dreamers and do-ers with unique knowledge, expertise, backgrounds, and perspectives. We unite as mission-driven problem-solvers with a deep desire to achieve our vision and make our time here count. Our award-winning culture is built around shared values of inclusiveness, accountability, and support.

Our DEI commitment:Our vision of accessible, high-quality, and sustainable healthcare for all requires addressing the inequities that stand in the way. That's one reason we prioritize diversity, equity, and inclusion in every aspect of our business, from attracting and sustaining a diverse workforce to maintaining an inclusive environment for athenistas, our partners, customers and the communities where we work and serve.

What we can do for you:

Along with health and financial benefits, athenistas enjoy perks specific to each location, including commuter support, employee assistance programs, tuition assistance, employee resource groups, and collaborativeworkspaces  — some offices even welcome dogs.

We also encourage a better work-life balance for athenistas with our flexibility. While we know in-office collaboration is critical to our vision, we recognize that not all work needs to be done within an office environment,full-time. With consistent communication and digital collaboration tools, athenahealthenablesemployees to find a balance that feels fulfilling and productive for each individual situation.

In addition to our traditional benefits and perks, we sponsor events throughout the year, including book clubs, external speakers, and hackathons. We provide athenistas with a company culture based on learning, the support of an engaged team, and an inclusive environment where all employees are valued.

Learn more about our culture and benefits here: athenahealth.com/careers

https://www.athenahealth.com/careers/equal-opportunity