Data Architect

The Emily Program; United States; Remote; USD 140,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Vision insurance

Disability insurance

Life insurance

401(k) matching

Paid time off

Job summary

Accanto is seeking a Data Architect to define and govern an Azure-based platform integrating Avatar NX, Salesforce, and financial systems. You will reverse engineer the Avatar NX data model and establish scalable, governed data ecosystems aligned with regulatory requirements.

You’ll lead data cataloging, data governance, and lineage frameworks, while ensuring auditability through Git-based version control and robust ERDs. Remote work within the US is supported.

Qualifications

• Bachelor's degree in computer science or related field.
• 7+ years in data architecture, data modeling, or enterprise data engineering.
• Experience with Azure data services (ADF, Synapse, Data Lake).
• Experience reverse engineering undocumented or poorly documented schemas.

Responsibilities

• Reverse engineer Avatar NX data model and document ERDs.
• Define integration patterns across Avatar NX, Salesforce, and finance.
• Establish data governance, catalogs, and lineage frameworks.
• Ensure version-controlled data models and pipelines.

Skills

Data architecture

Data modeling

Azure

SQL Server

Reverse engineering

Stakeholder collaboration

Data governance

Education

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

Tools

Avatar NX

Salesforce

Git

Azure Synapse

Data Lake

Job description

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:

• 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
• 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
• 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
• Experience implementing data governance frameworks, lineage, and data quality controls
• Advanced SQL Server expertise (querying, schema analysis, performance tuning)
• Experience with large, complex, highly normalized transactional systems
• Proficiency with source control and version management tools (e.g., Git), including branching strategies, pull requests, and versioning of data models, pipelines, and schema definitions

Preferred Experience

• Experience in the Healthcare industry, data domains (clinical workflows, RCM, compliance)
• Experience supporting finance and revenue cycle reporting (AR, billing, reconciliation)
• Familiarity with Power BI, SSRS, or other reporting platforms
• Experience working in environments with limited vendor transparency or documentation
• Requires long periods of sitting (95% sitting, 5% standing)
• Technical Architecture
• Data Governance & Quality
• Business & Strategy Alignment
• Leadership & Influence

Accanto’s Commitment to Equal Opportunity: Accanto is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, physical or mental disability, genetic factors, military/veteran status

What we offer:

Employee Benefits: We understand the importance of a well-rounded benefits package. That’s why we’re dedicated to providing a range of plans to meet your needs.

For full-time employees, we offer:

• HSA and PPO insurance with HSA or FSA options (Blue Cross Blue Shield)
• Vision insurance (EyeMed)
• Short-term and long-term disability insurance
• Company-paid life insurance
• Company 401(k) matching for up to 50% of your contribution, up to 6% of your compensation

Paid time off is a crucial part of maintaining work and life balance. Our generous PTO plan accrues annually and begins with your first whole pay period. Eligible employees enjoy seven paid holidays and one floating holiday in addition to their regular PTO.