Data Architect
$140,000–$160,000 year
RemoteUnited States
Job Summary
Design end-to-end Azure data architecture covering ingestion, staging, curated, and reporting layers for enterprise domains including clinical, RCM, CRM, and finance. Reverse engineer the Avatar NX EHR data model, including table structures, relationships, and data flows, to enable accurate integration and long-term governance. Establish canonical data models and define integration patterns across Avatar NX, Salesforce, and financial systems while implementing standards for naming, definitions, and data quality. Lead development of a data catalog, business glossary, and lineage framework, ensuring all architectural artifacts are version-controlled in Git. Partner with Finance, RCM, Operations, IT, and Analytics leadership to provide architectural guidance and validate inferred billing logic.
Required Qualifications
- 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
- Hands-on experience reverse engineering undocumented or poorly documented schemas, including: Reconstructing data models from source systems
- Hands-on experience reverse engineering undocumented or poorly documented schemas, including: 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
- Must be US based, and able to work with no restrictions in the US in a remote home office
- Requires long periods of sitting (95% sitting, 5% standing)
Desired Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.