Data Architect

The Emily ProgramRemote · Posted 1 month ago

Full-timeRemoteEst. 150,000 USD

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.

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
Experience establishing canonical data models across domains (clinical, financial, operational)
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

Workplace Environment:

Requires long periods of sitting (95% sitting, 5% standing)
Extensive computer use

Competencies:

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)
Dental insurance (Delta Dental)
Vision insurance (EyeMed)
Short-term and long-term disability insurance
Company-paid life insurance
401(k) plan available two months after start date
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.

Similar jobs

Senior EHR Analyst7 days ago

The Emily ProgramRoseville, Minnesota, United States

Est. 77,500 USD

Full-time

Director of Talent Acquisition15 days ago

The Emily ProgramRoseville, Minnesota, United States

Est. 115,000 USD

Full-time

Family Practice MD - Director of Medical Services1 month ago

The Emily ProgramSeattle, Washington, United States

Est. 275,000 USD

Full-time

Site Nurse Director27 days ago

The Emily ProgramDurham, North Carolina, United States

Est. 122,500 USD

Full-time

Senior Applications Analyst3 months ago

The Emily ProgramRemote

Est. 107,500 USD

Full-timeRemote

Senior Enterprise Performance Analyst7 months ago

Care AccessRemote

Est. 80,000 USD

About Care Access Care Access is working to make the future of health better for all. With hundreds of research locations, mobile clinics, and clinicians across the globe, we bring world-class research and health service…

Full-timeRemote

Enterprise Performance Analytics Engineer10 months ago

Care AccessRemote

Est. 95,000 USD

Full-timeRemote

Data Platform Architect1 month ago

Accenture Federal ServicesSuitland, Maryland, United States

Est. 148,450 USD

At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the li…

Full-time

Senior Manager, Accounting1 month ago

Care AccessRemote

Est. 155,000 USD

Full-timeRemote

Data Architect3 months ago

Accenture Federal ServicesArlington, Virginia, United States

Est. 119,400 USD

Full-time

Senior Data Architect3 months ago

Accenture Federal ServicesArlington, Virginia, United States

Est. 163,700 USD

Full-time

Residential Therapist13 days ago

The Emily ProgramMinneapolis, Minnesota, United States

Est. 57,500 USD

Full-time

Data Engineer2 months ago

SRS AcquiomRemote

Est. 132,500 USD

About SRS Acquiom SRS Acquiom delivers the smartest way to run a deal™ through a platform and services designed to help deal parties manage complex M&A and loan agency transactions more efficiently. Based in Denver,…

Full-timeRemote

Senior .NET Azure AI Developer - Baltimore, MD2 months ago

Accenture Federal ServicesBaltimore, Maryland, United States

Est. 151,800 USD

Full-time

Data Architect3 months ago

Accenture Federal ServicesArlington, Virginia, United States

Est. 163,700 USD

Full-time

Admissions Manager2 days ago

The Emily ProgramDurham, North Carolina, United States

Est. 85,000 USD