Data Architect

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 SummaryThe 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.Schedule8am-5pm CSTSalary Range$109,300- $141,900 commensurate with experienceLocation: Remote- Must be US based, and able to work with no restrictions in the US in a remote home office.How Data Architects Empower RecoveryEnterprise Data ArchitectureDesign 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 flowsEnterprise ERDs and logical modelsMapping vendor-specific schemas to normalized structuresInterpreting 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 engineeringIntegration StrategyDefine 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 & StandardsEstablish standards for naming, definitions, and data qualityImplement governance for billing rules and derived logicLead development of a data catalog, business glossary, and lineage frameworkEnsure reverse-engineered models are documented and version-controlledEnsure data models, pipelines, and architectural artifacts are managed using enterprise source control practices (e.g., Git) to support auditability and traceabilityRule & Revenue TransparencyDefine architecture for rule outcome (inferred) tracking within AzureEnable reconciliation between NX and downstream financial systemsEnsure billing logic is auditable, traceable, and explainableCollaborationPartner with Finance, RCM, Operations, IT, and Analytics leadershipProvide architectural guidance to Data Modelers, Developers, and DBAsEducation QualificationsBachelor’s degree in computer science, Information Systems, Data Engineering, or a related technical fieldProfessional Qualifications7+ years in data architecture, data modeling, or enterprise data engineeringHands-on experience designing data platforms in Azure (ADF, Synapse, Data Lake, SQL)Demonstrated experience integrating EHR, CRM, and financial systemsProven 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 linkagesReconstructing data models from source systemsBuilding ERDs from live databases rather than vendor documentationExperience translating complex clinical and billing data structures into usable enterprise modelsAbility to work with stakeholders to validate inferred logic (e.g., encounter flows, billing rules, documentation timing)Strong expertise in relational and dimensional data modelingExperience establishing canonical data models across domains (clinical, financial, operational)Experience implementing data governance frameworks, lineage, and data quality controlsAdvanced SQL Server expertise (querying, schema analysis, performance tuning)Experience with large, complex, highly normalized transactional systemsProficiency with source control and version management tools (e.g., Git), including branching strategies, pull requests, and versioning of data models, pipelines, and schema definitionsPreferred ExperienceExperience 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 platformsExperience working in environments with limited vendor transparency or documentationWorkplace EnvironmentRequires long periods of sitting (95% sitting, 5% standing)Extensive computer useCompetenciesTechnical ArchitectureData Governance & QualityBusiness & Strategy AlignmentLeadership & InfluenceAccanto’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 statusWhat We OfferEmployee 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 OfferHSA 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 dateCompany 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.