About this opportunity
The Emily Program lists this Data Architect opportunity in workfromhome, California. Review the employer’s description below for duties, qualifications and application requirements.
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.
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.
Voluntary Self‑Identification
For government reporting purposes, we ask candidates to respond to the below self‑identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.
As set forth in The Emily Program’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.
If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Re‑adjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:
A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service‑connected disability.
A "recently separated veteran" means any veteran during the three‑year period beginning on the date of such veteran’s discharge or release from active duty in the U.S. military, ground, naval, or air service.
An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Voluntary Self‑Identification of Disability
Form CC‑305
Page 1 of 1
OMB Control Number 1250‑0005
Expires 07/31/2029
Why are you being asked to complete this form?
We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.
Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at .
How do you know if you have a disability?
A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:
Alcohol or other substance use disorder (not currently using drugs illegally)
Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
Blind or low vision
Cancer (past or present)
Cardiovascular or heart disease
Celiac disease
Cerebral palsy
Deaf or serious difficulty hearing
Diabetes
Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
Epilepsy or other seizure disorder
Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
Intellectual or developmental disability
Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
Missing limbs or partially missing limbs
Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
Neurodivergence, for example, attention‑deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
Partial or complete paralysis (any cause)
Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
Short stature (dwarfism)
Traumatic brain injury
PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.
#J-18808-Ljbffr
Worksite address
workfromhome, CA, 95678, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.