Data Architect

The Emily Program • Roseville, MN

18d • Remote

About The Position

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.

Requirements

• Bachelor’s degree in computer science, Information Systems, Data Engineering, or a related technical field
• 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

Nice To Haves

• 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

Responsibilities

• 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
• 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)
• 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
• 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

Benefits

• 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
• Generous PTO plan accrues annually
• Seven paid holidays and one floating holiday in addition to their regular PTO

What This Job Offers

• Job Type: Full-time
• Career Level: Senior