Data Architect I

Duly Health and Care; Chicago (IL); On-site; USD 65,000 - 85,000; Full time

Benefits offered by this job

Medical, dental & vision benefits

Mental health support

Life & disability insurance

Tuition reimbursement

Immediate 401(k) match

Volunteer time off

Parental leave

Community impact & social engagement

Job summary

Duly Health and Care is hiring a Data Architect I to design and maintain data structures powering analytics, reporting, and AI across the enterprise. You will work with senior architects to shape the cloud data platform, model data, and document lineage in a healthcare setting. Training will be provided; prior Epic experience is not required.

The role emphasizes data governance, quality, and collaboration with engineers, analysts, and data scientists to meet business needs.

Qualifications

• Bachelor's degree in computer science, information systems, data science, or related field, or 2 years of related experience.
• 0-2 years with relational databases, data modeling, or data engineering counts.
• Experience writing SQL for data analysis or transformation.
• Experience with Databricks, Spark, Delta Lake, or other cloud data platforms (Azure preferred) beneficial.
• Healthcare or Epic Clarity experience not required; training provided.

Responsibilities

• Data modeling, design, and documentation (50%).
• Support ingestion patterns and layered data structures within the enterprise lakehouse.
• Document schemas, data dictionaries, and data lineage for discoverability.
• Collaborate with data engineers, analysts, and scientists to translate needs into designs.

Skills

Strong SQL

Data modeling

Analytical mindset

Documentation

Team collaboration

Education

Bachelor's in CS/IS/Data Science

Tools

Databricks

Spark

Delta Lake

Python

Job description

At Duly Health and Care, you are supported to do your best work and make a meaningful impact every day. You will be part of a collaborative, physician-led team that works as one and puts patients at the center of everything we do. With a connected network of providers, care teams, and services across primary and specialty care, surgery centers, imaging, lab, and therapy, you are part of a system designed to deliver high-quality, coordinated care. Together, we create an environment where you can grow, contribute, and help improve the experience and outcomes for every patient we serve.

Benefits

• Comprehensive medical, dental, and vision benefits that include healthcare navigation assistance.
• Access to a mental health benefit at no cost.
• Employer provided life and disability insurance.
• $5,250 Tuition Reimbursement per year.
• Immediate 401(k) match.
• 40 hours paid volunteer time off.
• A culture committed to community engagement and social impact.
• Up to 12 weeks parental leave at 100% pay and a financial benefit for adoption and surrogacy for non-physician team members once eligibility requirements are met.

Primary Purpose

The Data Architect I is an early-career role within the Data & Analytics team, responsible for helping design, document, and maintain the data structures that power analytics, reporting, and AI across the enterprise. Working alongside senior architects and engineers, this position contributes to the organization’s cloud data platform, including data modeling, pipeline design, metadata and lineage documentation, and data governance practices. This role is a strong fit for someone with a foundation in databases and data modeling who wants to grow into enterprise-level architecture in a healthcare setting. No prior healthcare or Epic experience is required; we will train you.

Major Responsibilities

• Data modeling, design, and documentation (50%)
• Design and maintain logical and physical data models, including entity-relationship diagrams, for analytical and operational data sets
• Support the design of ingestion patterns and layered (e.g., bronze/silver/gold) data structures within the enterprise lakehouse
• Document schemas, table inventories, data dictionaries, and data lineage so that data is discoverable and understandable
• Assist with naming standards, modeling conventions, and design guidelines for the data platform
• Review and help optimize SQL and table structures for performance, reusability, and clarity
• Data governance, quality, and platform support (30%)
• Help identify, classify, and inventory sensitive data (e.g., PHI/PII) and support access control and security practices
• Support data quality rules, validation checks, and monitoring of data pipelines
• Assist in evaluating the impact of source system changes on downstream data models and reports
• Contribute to release notes, design documents, and test plans as required by our project delivery methodology
• Collaboration and continuous improvement (20%)
• Partner with data engineers, analysts, and data scientists to translate business and analytic needs into sound data designs
• Work with business stakeholders to understand data definitions and requirements
• Learn from senior architects and participate in design reviews
• Identify opportunities to improve data platform standards, processes, and documentation
• All other duties as assigned

Minimum Education and Experience

• Bachelor's degree in computer science, information systems, data science, engineering, or a related field; or 2 years of related experience; or an equivalent combination of education and experience
• 0-2 years of experience working with relational databases, data modeling, or data engineering (internships, co-ops, and academic projects count)
• Experience writing SQL for data analysis or transformation
• Experience with Databricks, Spark, Delta Lake, or other cloud data platforms (Azure preferred) beneficial
• Experience with Python beneficial
• Experience with ERD or data modeling tools beneficial
• Healthcare or Epic Clarity experience not required; training provided

Minimum Knowledge, Skills, and Abilities (KSA)

• Understanding of relational database concepts, normalization, and dimensional modeling
• Strong SQL skills
• Strong analytical, organizational, and problem-solving skills
• Strong written and verbal communication skills, including the ability to explain technical designs to non-technical audiences
• Attention to detail and a commitment to documentation
• Ability to work both independently and in a team-oriented environment
• Curiosity and a desire to learn modern data architecture practices
• Familiarity with data governance, data security, or privacy concepts helpful

Competitive Compensation

The compensation for this role includes a base pay range of $65,000 - $85,000, with the actual pay determined by factors such as skills, experience, education, certifications, geographic location, and internal equity. Additional compensation may be available through shift differentials, bonuses, and other incentives. Base pay is only a portion of the total rewards package.

Artificial Intelligence Disclosure

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person.

Let’s start with what matters. People. Purpose. Care. At Duly Health and Care, we believe healthcare works best when it’s personal, connected, and led by people who truly care. We are a physician-led medical group built on trusted relationships, teamwork, and a shared commitment to putting patients first in every decision we make. Our team members are caregivers, collaborators, problem-solvers, and leaders. Together, we show up with compassion, act with purpose, and take ownership of the care we deliver and the experience we create. Whether you’re caring directly for patients or supporting the teams who do, your role matters here, and your voice is valued. We listen with intention, work as one, and challenge ourselves to keep improving, not for recognition, but because our patients, families, and communities count on us. Innovation at Duly isn’t about chasing what’s next for its own sake. It’s about finding better ways to deliver high-quality, affordable, and accessible care, today and into the future.

If you’re looking for meaningful work, supportive teammates, and the opportunity to help shape the future of care while staying grounded in compassion and community, you’ll find your place at Duly.