Data Architect I

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

Benefits offered by this job

Medical benefits

Mental health support

Life insurance

Tuition reimbursement

401(k) match

Volunteer time off

Parental leave

Adoption assistance

Job summary

Duly Health and Care, a physician-led network, seeks a Data Architect I to join the Data & Analytics team in Downers Grove, IL. You will help design and document enterprise data structures powering analytics, reporting, and AI across the organization.

With training provided and exposure to modern cloud data platforms, you will grow from foundational modeling to enterprise-scale architecture while collaborating with engineers, analysts, and stakeholders to deliver high-quality data solutions that

Qualifications

• 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.
• 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.
• Healthcare or Epic Clarity experience not required; training provided.

Responsibilities

• Data modeling, design, and documentation for analytical and operational data sets.
• Design ingestion patterns and layered data structures within the enterprise lakehouse.
• Document schemas, inventories, data dictionaries, and data lineage.
• Assist naming standards, modeling conventions, and design guidelines.
• Review and optimize SQL and table structures for performance and clarity.
• Collaborate with data engineers, analysts, and data scientists to translate needs.

Skills

Data modeling

SQL

Analytical thinking

Communication

Education

Bachelor's degree in CS / IS / data science / engineering or related field

2 years of related experience

Tools

Databricks

Spark

Delta Lake

Job description

Data Architect I# Careers## Data Architect IApply: Downers Grove, Illinois: Full time: Posted Yesterday: JR119989Information and TransformIf you are a current Duly/SBC/QMG employee, please apply through the Internal Career Site.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 If you are committed to putting our patients first and helping shape the future of care, you belong at Duly. 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.