T

The Emily Program

Provides personalized eating disorder treatment programs

Data Architect

Data ManagementConfirmed live in the last 24 hours
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

The Emily Program

Provides personalized eating disorder treatment programs

The Emily Program helps people with eating disorders across the United States by providing personalized treatment in multiple settings, including residential, day treatment, outpatient care, and telehealth. It serves adolescents and adults with conditions such as anorexia, bulimia, and binge eating disorder, and develops individualized care plans that address each client’s needs. Its care works through a combination of in-person and remote services, designed to support long-term recovery and is supported by collaborations with healthcare providers and the University of Minnesota Medical School for clinical expertise and research. Revenue comes from private pay, insurance reimbursements, and healthcare partnerships. The program also offers family resources and community events to support the client’s recovery and maintain accessibility for families.”} EMT 2.0 002? Please ignore the extraneous text. } 》 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Company size
501-1,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Houston, TX
Founded
1993

Recently Posted Jobs

Explore more opportunities at The Emily Program

See more jobs