Data Engineer, Sr. - Remote
About the Company:
Atlas Medical Data Group is a founder-owned portfolio of healthcare businesses. Its core business is a healthcare price intelligence company that processes the price transparency files insurers are required to publish, turning large and complex negotiated-rate data into useful price intelligence. The company is also expanding into care delivery by acquiring or partnering with clinics and providing their non-clinical operations through a management services organization (MSO). Its first acquisition is a multi-site autism therapy (ABA) practice.
About the Role:
Atlas Medical Data Group is seeking a hands-on Data Engineer to take ownership of and extend the Azure data warehouse supporting ABES, an ABA therapy practice with two clinics in Illinois, and its growing management services organization. The warehouse is already operational, with its main data sources loaded. The focus now is to expand integrations, develop reliable data models, automate financial processes, and deliver reporting that the finance team can depend on. The role will also support ABES's transition from QuickBooks to ERPNext and help prepare the data platform to support multiple practices as the portfolio grows. This is a contract engagement with an open duration and an opportunity for continued work as the business expands.
Key Responsibilities:
Take ownership of the existing Azure data warehouse, understand its architecture, and extend its capabilities.
Maintain and expand existing integrations while adding new data sources, beginning with banking systems.
Integrate systems through APIs and data exports, accounting for different formats and authentication methods.
Build transformation layers and data models covering clients, sessions, authorizations, claims, payments, staff, hours, and pay.
Develop gross profit reporting and reconcile payroll data against billed services.
Prepare clean, reconciled warehouse data to feed ERPNext and support the transition from QuickBooks.
Build reporting and data delivery capabilities within ERPNext where appropriate.
Support finance operations and the year-end accounting close.
Identify and automate manual processes between source systems, the warehouse, and accounting systems.
Implement data quality checks and documentation so finance teams can rely on reported figures.
Design the data model to support multiple organizations as the MSO expands to additional practices.
Contribute to platform and tooling decisions as Microsoft Fabric, Snowflake, Databricks, and transformation tools are evaluated.
Use AI developer tools as part of the regular development workflow.
Required Qualifications:
Hands-on data engineering experience with cloud infrastructure on at least one major cloud platform: Azure, AWS, or GCP.Experience setting up, deploying, and managing cloud resources.
Strong SQL skills and experience with dimensional data modeling.
Experience designing data warehouses used by finance or operations teams.
Strong Python skills for data integration and automation.
Experience integrating SaaS and business systems through APIs and exports, including handling different data formats and authentication methods.
Ability to build reusable integrations that make adding future data sources easier.
Experience building, operating, and supporting an end-to-end data platform in production.
Ability to translate finance and operations requirements into data models and working reports.
Comfortable working independently in an ambiguous environment and turning business questions into technical specifications.
Clear written communication and the ability to work remotely with a small, distributed team.
Availability to start quickly.
Must be based in the United States and authorized to work in the U.S. without sponsorship.
Preferred Experience:
Experience with finance data, including general ledger, accounting close, ERP systems, and reconciliation.
Experience with healthcare data, including claims, revenue cycle, and HIPAA requirements.
Experience across both finance and healthcare data is ideal.
Technical Environment:
Azure-based data warehouse.
ERPNext as the ERP and finance platform, replacing QuickBooks.
Applications deployed on Azure Container Apps.
Existing codebase primarily built with Python.
Microsoft Fabric, Snowflake, and Databricks under evaluation for the warehouse platform.
Claude Code or equivalent AI developer tooling used in daily development.
Location & Engagement Details:
Remote position for candidates based in the United States.
Contract engagement starting as soon as possible.
Engagement length is open, with the potential to continue as the portfolio grows.
What the Engagement OffersWork that directly supports business operations and financial reporting.
The opportunity to shape the design and direction of a relatively new data warehouse.
Scope to grow with the data platform as the portfolio adds more healthcare practices.
The opportunity to work closely with the technical lead and finance and operations teams.
Working Environment & Challenges:
Data comes from multiple practice systems, some of which are difficult to work with and are not expected to be replaced soon. Inconsistent identifiers, exports, and manual workarounds are part of the work.
The healthcare data includes protected health information, so HIPAA requirements influence how information is stored and accessed.
The data engineer will work closely with the technical lead without the support of a larger data team.
Requirements will often come from finance and operations stakeholders, and the engineer will need to translate their processes into clear specifications.