> Markdown version of [/jobs/ext/1457800-data-architect](https://www.wearedevelopers.com/jobs/ext/1457800-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect - **Company:** Emily Program - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $109,300.0 - $141,900.0 - **Contract:** Permanent contract - **Skills:** Cerner, Application Programming Interfaces (APIs), Data Analysis, Microsoft Azure, Information Systems, Databases, Computer Literacy, Data Architecture, Information Engineering, Data Governance, Data Warehousing, Database Schema, Performance Tuning, Power BI, Reverse Engineering, Salesforce.Com, SQL Databases, SQL Server Reporting Services, Data Streaming, Systems Integration, Management of Software Versions, Enterprise Data Management, Azure Data Factory, Electronic Medical Records, Git, Data Lakes, Git Flow, Information Technology, Data Management, Tools for Reporting, Intersystems, Azure Synapse Analytics, Software Version Control - **Published:** July 27, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=3f46f555b14fc0e4 ## About the Role * 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 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, * Technical Architecture * Data Governance & Quality * Business & Strategy Alignment * Leadership & Influence ## Description 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., * 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 ## Related Videos - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Why Git Still Matters](https://www.wearedevelopers.com/videos/100288-why-git-still-matters) - [Applying DevOps in Flutter mobile development](https://www.wearedevelopers.com/videos/60-applying-devops-in-flutter-mobile-development) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)