Data Architect I

Ann & Robert H. Lurie Children's Hospital of Chicago

Confirmed live 2 days ago High trust

Quick summary

Work type
On-site
Location
Chicago, IL
Salary
$93,600–$154,440 / yr
Posted
46 days ago
Freshness
Confirmed live 2 days ago

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $202k
This role $124k
$75k most similar roles pay here $269k

This role pays less than 94% of similar roles. Most pay $161,250–$241,884 — the shaded band above. At the midpoint, this role pays about $124k versus about $202k for comparable roles.

Based on 240 similar postings.

Employer

About Ann & Robert H. Lurie Children's Hospital of Chicago

Ann & Robert H. Lurie Children''s Hospital of Chicago is a nationally ranked pediatric hospital providing comprehensive care across more than 70 specialties, affiliated with Northwestern University Feinberg School of Medicine. Industry: Pediatric Healthcare

Ann & Robert H. Lurie Children's Hospital of Chicago currently has 5 open roles on FindRole.

Most-posted roles

View all roles at Ann & Robert H. Lurie Children's Hospital of Chicago

At a glance

TL;DR · Data Architect I

The Data Architect I joins the Data Discovery and Development team to design, create, deploy, and manage ETL jobs and custom data applications within a hybrid on-premises and cloud environment. This role involves integrating complex data from EPIC Clarity, EPIC Clinical Data Warehouse, departmental repositories, research data, and legacy systems into a unified platform. The successful candidate will develop custom analytics solutions, perform database design, provide technical guidance for application implementation, and manage routine system administration tasks. Key requirements include a Bachelor’s degree in Information Systems or Computer Science, experience with the SQL Server Stack including SQL, SSIS, SSAS, SSRS, and PowerBI, and proficiency in object-oriented languages. The role addresses critical healthcare data integration challenges, requiring expertise in relational or dimensional modeling while ensuring strict adherence to HIPAA and JCAHO compliance standards for medical data.

What you'll do

  • Design and implement ETL jobs and data integration solutions across hybrid on-premises and cloud environments.
  • Integrate data from EPIC systems, departmental repositories, research databases, and external sources into a unified platform.
  • Develop custom data and analytics solutions including database design, programming, and application development.
  • Perform administration for data analytics systems, including installation, deployment, upgrades, and routine maintenance.
  • Scope client requirements to create technical design documents and project plans.
  • Conduct code reviews for team members and provide technical guidance on assigned applications.
  • Validate and clean data to resolve integration issues while ensuring HIPAA and JCAHO compliance.

What we're looking for

  • Bachelor's Degree in Information Systems, Computer Science, or a related field.
  • 1-3 years of experience with database and data development.
  • 1-3 years of coding experience in an object-oriented language.
  • Knowledge or experience with the SQL Server Stack including SQL, SSIS, SSAS, SSRS, and PowerBI.
  • Experience in software administration and designing Office 365 or MS Teams applications.
  • Working knowledge of healthcare data and analytics, preferably with Epic systems.
  • Experience in data modeling design using relational, dimensional, or modern models.
  • Knowledge or experience in more than one data solution such as ETL, ODS, Data Marts, Cubes, and Reporting.

More like this

Similar roles

Data Solution Architect

Boeing

Remote (Everett, WA) 8 days ago $125,800$170,200
SQL Python ETL Data Modeling AWS GitLab CI/CD Data Lakes Artificial Intelligence Automation Data Architecture
5+ yrs exp Remote

Business Intelligence Engineer III

Sutter Health

Sacramento, CA 53 days ago $117,436$176,155
SQL Power BI DAX SSIS ETL Full-Stack Engineering Tableau Epic Cogito Data Visualization Semantic Models Tabular Models Data Engineering Reporting Analytics
3+ yrs exp Hybrid

Business Intelligence Developer IV

Sutter Health

Remote 7 days ago
SQL Power BI Tableau ETL SQL Server Excel Smartsheet Dimensional Modeling Visio Web Analytics Data Modeling Project Management Access Reporting Business Intelligence
8+ yrs exp Remote

Data Architect

The Federal Reserve

St. Louis, MO +11 11 days ago $140,000$170,000
Data Architecture PostgreSQL AWS SQL Data Modeling Data Governance DataOps Time-Series Data Big Data Machine Learning AI Data Warehousing Data Engineering Metadata Management Distributed Query Engines
7+ yrs exp

Data Architect

Booz Allen Hamilton

Warner Robins, GA 53 days ago $86,800$198,000
Data Architecture SQL NoSQL Vector DBs Object Storage Apache NiFi Airflow Collibra Apache Atlas AWS Azure Cross-Domain Solutions Data Cataloging TOGAF
5+ yrs exp

Data Architect

Booz Allen Hamilton

Columbia, MD 64 days ago $86,900$198,000
Data Architecture Database Design Data Governance Data Visualization Software Engineering Management Data Standards Performance Metrics Cyber Operations
4+ yrs exp