# Data Architect at The Emily Program

> United States · Staff · Other · open. Source: https://alderhq.app/jobs/greenhouse%3Athe858emily123program%3A5475957008 (read 2026-11-12).

## Facts (observed)

- Company: [The Emily Program](https://alderhq.app/companies/the-emily-program)
- Location text: 2355 Highway 36 W, Ste 202, Roseville, MN 55113; IT/EHR
- Where it can be done from (inferred): United States (evidence: "Location: 2355 Highway 36 W, Ste 202, Roseville, MN 55113; IT/EHR")
- Posted: 2026-11-06 (6 days ago)
- First seen by alder: 2026-11-07 · last verified: 2026-11-12
- Reposted: 0 times · edited: 0 times
- Apply on the employer's site: https://job-boards.greenhouse.io/the858emily123program/jobs/5475957008
- Skills listed (inferred): Azure, SQL

## Pay and sponsorship

- Posted pay: $140k–$160k per year (from the description)
- Market band for similar posted roles (United States, n 3557): p25 $120k, median $167k, p75 $210k

## Description (the employer's text)

Our vision is a world of peaceful relationships with food, weight, and body image, where everyone with an eating disorder can experience recovery. We believe that exceptional, individualized care leads to lasting recovery from eating disorders. That’s why our teams are comprised of compassionate, dedicated professionals from a variety of backgrounds who collaborate to provide the very best evidence-based care for our clients at all levels of care.

### Position Summary

The Data Architect defines and governs the enterprise data architecture for a modern Azure-based platform integrating Avatar NX, Salesforce, and financial systems. This role establishes a scalable, consistent, and governed data ecosystem aligned with business and regulatory requirements. A critical responsibility is reverse engineering the Avatar NX EHR data model, due to limited vendor documentation, to enable accurate integration, reporting, and long-term data governance.

### Schedule

- 8am-5pm CST
### Salary Range

$140,000- $160,000 commensurate with experience

Location: Remote- Must be US based, and able to work with no restrictions in the US in a remote home office.

### Visa / work permit sponsorship is not available for this position

### How Data Architects Empower Recovery

### Enterprise Data Architecture

- Design end-to-end Azure data architecture (ingestion, staging, curated, reporting layers)
- Define enterprise data domains (Clinical, RCM, CRM, Finance)
- Establish canonical data models (e.g., Patient, Encounter, Claim, Revenue)
- Reverse engineer and document the Avatar NX data model, including:
- Table structures, relationships, and data flows
- Enterprise ERDs and logical models
- Mapping vendor-specific schemas to normalized structures
- Interpreting and modeling data from a non-traditional database architecture (InterSystems Caché/IRIS), where the SQL layer represents an abstraction over a non-relational core, resulting in limited schema transparency, minimal documentation, and increased complexity in reverse engineering
### Integration Strategy

- Define integration patterns across:
- Avatar NX (EHR and billing logic)
- Salesforce (CRM and engagement)
- Financial systems (GL and revenue recognition)
- Standardize data contracts and exchange patterns (batch, API, event-driven)
### Data Governance & Standards

- 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 are managed using enterprise source control practices (e.g., Git) to support auditability and traceability
### Rule & Revenue Transparency

- Define architecture for rule outcome (inferred) tracking within Azure
- Enable reconciliation between NX and downstream financial systems
- Ensure billing logic is auditable, traceable, and explainable
### Collaboration

- Partner with Finance, RCM, Operations, IT, and Analytics leadership
- Provide architectural guidance to Data Modelers, Developers, and DBAs
### Education Qualifications

- Bachelor’s degree in computer science, Information Systems, Data Engineering, or a related technical field
### Professional Qualifications

- 7+ years in data architecture, data modeling, or enterprise data engineering
- Hands-on experience designing data platforms in Azure (ADF, Synapse, Data Lake, SQL)
- Demonstrated experience integrating EHR, CRM, and financial systems
- Proven experience working with EHR vendor databases (e.g., Netsmart Avatar NX, Epic, Cerner, or similar)
- Hands-on experience reverse engineering undocumented or poorly documented schemas, including:
- Identifying table relationships and key linkages
- Reconstructing data models from source systems
- Building ERDs from live databases rather than vendor documentation
- Experience translating complex clinical and billing data structures into usable enterprise models
- Ability to work with stakeholders to validate inferred logic (e.g., encounter flows, billing rules, documentation timing)
- Strong expertise in relational and dimensional data modeling

---
Data: alder (https://alderhq.app). Cite https://alderhq.app/jobs/greenhouse%3Athe858emily123program%3A5475957008 and the date you read it. Observed facts come from the employer's own listing; location reach, level, family and skills are inferences.