Data Architect

Confidential; Charlotte (NC); On-site; USD 120,000 - 180,000; Full time

Job summary

Confidential in Charlotte, NC seeks a Data Architect to unify multi-platform data architectures and guide convergence to a single scalable model. You will own the architecture end-to-end, work hands-on with AI coding agents to build and review production SQL/pipelines, and ensure security, governance, and compliance across PHI data.

You will partner with engineering, product, and security to align data strategy with business goals.

Qualifications

• 7+ years in data engineering/architecture, with architect-level experience
• Experience in data modeling across relational, dimensional, and NoSQL
• Hands-on with SQL Server, PostgreSQL, BigQuery and orchestration/tools like Airflow, dbt
• Strong SQL skills and Python or similar language
• Experience handling PHI or regulated data (HIPAA/HITRUST)
• Familiarity with HL7, FHIR, or X12 isedi standards
• AI-first approach: review outputs from AI agents for correctness, performance, and security
• Able to translate business needs into technical data requirements

Responsibilities

• Own end-to-end data architecture and data flows across relational, document, and cloud warehouses
• Define standards for data modeling, naming, quality, and documentation followed by engineering teams
• Lead sprint-by-sprint work with AI coding agents (e.g., Claude Code) and review produced SQL/pipelines
• Architect secure handling of PHI per HIPAA and SOC 2 requirements
• Design integrations with health plan and payer data feeds (eligibility, claims, clinical)
• Build data foundation for AI and analytics ensuring data accuracy and governance
• Converge data platforms while balancing performance, cost, and scalability
• Lead data governance practices including lineage and access controls
• Translate business and clinical needs into technical data requirements

Skills

Data modeling

SQL

Python

AI coordination

Communication

PHI/compliance

Architectural leadership

Tools

SQL Server

PostgreSQL

BigQuery

Airflow

dbt

Job description

We’re looking for a Data Architect who is equally at home across relational databases, open-source databases and cloud data warehouses. The company runs several data platforms side by side. You’ll keep them reliable, set the standards across them, and lead their convergence into one architecture, built on data extract and load methods that do not lock us into a single vendor. This is a hands‑on, AI‑first role: you will design and build inside our data engineering teams, handing much of the keyboard work to AI coding agents. You alone own the architecture and are accountable for every change to it, so nothing merges without your review.

This role reports to the VP of Data and partners closely with Engineering, Product, Clinical, and Security.

What You’ll Do:

• Design and own the end-to-end data architecture, including data models, storage, integration patterns, and data flows across our relational, document and cloud warehouse systems
• Define standards for data modeling, naming, quality, and documentation that engineering teams follow
• Work sprint by sprint inside our data engineering teams, directing AI coding agents such as Claude Code to write, test and document production SQL and pipelines, reviewing what they produce, and taking a share of production support
• Architect secure handling of protected health information (PHI) in line with HIPAA, HITRUST and SOC 2 requirements
• Design integrations with health plan and payer partners, including eligibility, claims, and clinical data feeds
• Build the data foundation for AI and analytics use cases, making sure data is accurate, accessible, and well governed
• Design data extract and load methods that avoid vendor lock-in, and lead the convergence of our data platforms, balancing performance, cost, and long‑term scalability
• Lead data governance practices, including lineage, access controls, and retention policies
• Translate business and clinical needs into technical data requirements with stakeholders across the company

What You Bring:

• 7+ years of experience in data engineering, data architecture, or a related field, with at least three years in an architect‑level role
• Deep expertise in data modeling (relational, dimensional, and NoSQL), modern data warehouse design, and migrating workloads between platforms
• Deep, hands‑on production experience with SQL Server (T‑SQL, SSIS, performance tuning), PostgreSQL, and Google BigQuery, plus workflow orchestration and transformation tools such as Airflow and dbt
• Strong SQL skills and working knowledge of Python or another data‑focused language
• Experience designing systems that handle PHI or other regulated data, with a working understanding of HIPAA and HITRUST
• Familiarity with healthcare data standards such as HL7, FHIR, or X12 EDI (strongly preferred)
• You already work AI‑first: you hand much of your hands‑on‑keyboard work to AI coding agents such as Claude Code and review their output with impeccable rigor before anything merges: correctness, performance, security and fit with the architecture. Experience supporting AI or machine learning data needs is a plus
• Clear communicator who can explain architecture tradeoffs to technical and nontechnical audiences