A

Accanto Health

National eating disorder treatment provider

Data Architect

Data ManagementPosted on Nov 6
Full-timeRemote in USA$140k - $160k

About the Job

Requirements

  • A bachelor's degree in computer science, information systems, data engineering, or a related technical field is required.
  • At least 7 years of experience in data architecture, data modeling, or enterprise data engineering is required.
  • Hands-on experience designing data platforms in Azure, including Azure Data Factory, Synapse, Data Lake, and SQL, is required.
  • Demonstrated experience integrating electronic health record, customer relationship management, and financial systems is required.
  • Proven experience working with electronic health record vendor databases such as Netsmart Avatar NX, Epic, Cerner, or similar is required.
  • Hands-on experience reverse engineering undocumented or poorly documented schemas is required, including identifying table relationships and key linkages, reconstructing data models from source systems, and building entity relationship diagrams from live databases rather than vendor documentation.
  • Experience translating complex clinical and billing data structures into usable enterprise models is required.
  • Ability to work with stakeholders to validate inferred logic, such as encounter flows, billing rules, and documentation timing, is required.
  • Strong expertise in relational and dimensional data modeling is required.
  • Experience establishing canonical data models across clinical, financial, and operational domains is required.
  • Experience implementing data governance frameworks, lineage, and data quality controls is required.
  • Advanced SQL Server expertise, including querying, schema analysis, and performance tuning, is required.
  • Experience with large, complex, highly normalized transactional systems is required.
  • Proficiency with source control and version management tools such as Git is required, including branching strategies, pull requests, and versioning data models, pipelines, and schema definitions.
  • Must be based in the United States and able to work in the United States without restrictions.
  • The role requires long periods of sitting and extensive computer use.

Responsibilities

  • Design end-to-end Azure data architecture, including ingestion, staging, curated, and reporting layers.
  • Define enterprise data domains for clinical, revenue cycle management, customer relationship management, and finance.
  • Establish canonical data models, such as patient, encounter, claim, and revenue.
  • Reverse engineer and document the Avatar NX data model, including table structures, relationships, data flows, enterprise entity relationship diagrams and logical models, and mappings from vendor-specific schemas to normalized structures.
  • Interpret and model data from the InterSystems Caché/IRIS database architecture, where the SQL layer abstracts a non-relational core, resulting in limited schema transparency, minimal documentation, and greater reverse-engineering complexity.
  • Define integration patterns across Avatar NX, Salesforce, and financial systems.
  • Standardize data contracts and exchange patterns, including batch, API, and event-driven patterns.
  • Establish standards for naming, definitions, and data quality.
  • Implement governance for billing rules and derived logic.
  • Lead development of a data catalog, business glossary, and lineage framework.
  • Ensure reverse-engineered models are documented and version-controlled.
  • Ensure data models, pipelines, and architectural artifacts follow enterprise source-control practices, such as Git, to support auditability and traceability.
  • Define architecture for tracking inferred rule outcomes within Azure.
  • Enable reconciliation between NX and downstream financial systems.
  • Ensure billing logic is auditable, traceable, and explainable.
  • Partner with Finance, Revenue Cycle Management, Operations, IT, and Analytics leadership.
  • Provide architectural guidance to data modelers, developers, and database administrators.

Desired Qualifications

  • Experience in the healthcare industry and data domains such as clinical workflows, revenue cycle management, and compliance is preferred.
  • Experience supporting finance and revenue cycle reporting, including accounts receivable, billing, and reconciliation, is preferred.
  • Familiarity with Power BI, SQL Server Reporting Services, or other reporting platforms is preferred.
  • Experience working in environments with limited vendor transparency or documentation is preferred.

About the Company

Accanto Health

National eating disorder treatment provider

Accanto Health provides specialized behavioral healthcare for eating disorders and related mental health conditions. It runs a national network through brands like The Emily Program and Gather Behavioral Health, offering a continuum of care from 24/7 inpatient and residential services to outpatient programs (PHP and IOP) for children, teens, and adults across multiple states, with both in-person and virtual treatment options. Care is delivered by multidisciplinary teams using evidence-based therapies such as CBT and DBT to treat conditions including anorexia, bulimia, binge eating disorder, ARFID, and co-occurring mental health issues. The company unifies established brands under one national umbrella to improve access and continuity of care, supported by private equity to expand reach, with the goal of widening access to high-quality treatment and supporting patients throughout recovery.

Company size
11-50
Company stage
Not listed
Total funding
Not listed
Headquarters
St Paul, MN
Founded
2021

Recently Posted Jobs

Explore more opportunities at Accanto Health

See more jobs