Data Architect

The Emily Program • Roseville, MN

8d • $140,000 - $160,000 • 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. The 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, given limited vendor documentation, to enable accurate integration, reporting, and long-term data governance.

The position designs end-to-end Azure data architecture and enterprise data domains, establishes canonical data models, and defines integration patterns and data exchange standards. It also establishes data governance, naming, quality, lineage, and source-control practices; supports transparent and auditable billing and revenue logic; and provides architectural guidance to data modelers, developers, and DBAs. The role partners with Finance, RCM, Operations, IT, and Analytics leadership.

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 Azure data platforms using ADF, Synapse, Data Lake, and SQL.
• Demonstrated experience integrating EHR, CRM, and financial systems.
• Experience with EHR vendor databases such as Netsmart Avatar NX, Epic, Cerner, or similar.
• Hands-on experience reverse engineering undocumented or poorly documented schemas, identifying table relationships and key linkages, reconstructing source-system data models, and building ERDs from live databases.
• Experience translating complex clinical and billing data structures into usable enterprise models.
• Ability to work with stakeholders to validate inferred logic, such as encounter flows, billing rules, and documentation timing.
• Strong expertise in relational and dimensional data modeling.
• Experience establishing canonical data models across clinical, financial, and operational domains.
• Experience implementing data governance frameworks, lineage, and data quality controls.
• Advanced SQL Server expertise, including querying, schema analysis, and performance tuning.
• Experience with large, complex, highly normalized transactional systems.
• Proficiency with source-control and version-management tools such as Git, including branching strategies, pull requests, and versioning of data models, pipelines, and schema definitions.

Nice To Haves

• Experience in the healthcare industry, including clinical workflows, RCM, or compliance data domains.
• Experience supporting finance and revenue cycle reporting, including AR, billing, and 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 across ingestion, staging, curated, and reporting layers.
• Define enterprise data domains, including Clinical, RCM, CRM, and Finance.
• Establish canonical data models for entities such as Patient, Encounter, Claim, and Revenue.
• Reverse engineer and document the Avatar NX data model, including table structures, relationships, data flows, ERDs, logical models, and mappings to normalized structures.
• Interpret and model data from InterSystems Caché/IRIS, where the SQL layer abstracts a non-relational core.
• Define integration patterns across Avatar NX, Salesforce, and financial systems.
• Standardize data contracts and batch, API, and event-driven exchange patterns.
• Establish standards for naming, definitions, and data quality, and implement governance for billing rules and derived logic.
• Lead development of a data catalog, business glossary, and lineage framework.
• Document and version-control reverse-engineered models.
• Manage data models, pipelines, and architectural artifacts using enterprise source-control practices to support auditability and traceability.
• Define Azure architecture for tracking inferred rule outcomes.
• 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 through Blue Cross Blue Shield.
• Dental insurance through Delta Dental.
• Vision insurance through 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 the employee’s contribution, up to 6% of compensation.
• Paid time off that accrues annually and begins with the first whole pay period.
• Seven paid holidays and one floating holiday in addition to regular PTO.

What This Job Offers

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