Data Architect II

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

Chicago, IL Posted 43 days ago $99,840–$164,736 / year

At a glance

AI generated

TL;DR

The Data Architect II role within the Data Analytics & Reporting team at a leading healthcare institution involves designing and implementing ETL jobs and custom data applications to integrate data across EPIC, departmental repositories, research databases, legacy systems, and external sources in a hybrid on-premises and cloud environment. Day-to-day responsibilities include developing database designs, programming interfaces, managing data analytics systems, and providing technical support for existing and new applications while adhering to HIPAA compliance standards. The ideal candidate has 3+ years of experience with SQL Server Stack, Microsoft Azure, and advanced data modeling design, along with a Bachelor's degree in Information Systems or Computer Science. This position requires expertise in object-oriented programming, SQL, and healthcare data analytics, particularly within the EPIC system, to address complex integration challenges and ensure seamless data flow for hospital operations.

Skills

SQL SSIS SSAS SSRS PowerBI Azure ETL Data Modeling Object Oriented Programming SQL Server Python PostgreSQL CI/CD Kubernetes Docker Git JIRA Terraform AWS

What you'll do

Design and implement ETL solutions for data integration among various hospital repositories.
Develop custom data analytics solutions including database design, interface programming, and application development.
Install, deploy, and upgrade data analytics systems while maintaining documentation and performing maintenance activities.
Create project plans and manage projects related to data analytics solutions.
Provide technical support and serve as the primary resolution point for issues regarding assigned applications.

What we're looking for

3+ years of database and data development experience
Advanced SQL knowledge including stored procedures, functions, dynamic SQL, triggers
Experience with Microsoft Azure and SQL Server Stack (SSIS, SSAS, SSRS, PowerBI)
Ability to design and implement ETL processes and custom data solutions
Bachelor's Degree in Information Systems or Computer Science required
Expertise in healthcare data analytics, preferably with Epic knowledge

Market check

Salary context

This $99,840–$164,736 range sits above 32% of similar postings on FindRole.

Peer median band

$124,500–$199,400

Median floor and ceiling across peers.

Typical midpoint (25–75%)

$126,800–$205,337

Middle half of comparable postings.

Based on 240 comparable postings.

* 240 is the maximum number of comparable postings sampled.

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 6 open roles on FindRole.

Listed pay typically runs $99,840–$164,736 across 6 roles with salary data.

Most-posted roles

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

Similar roles

Data Architect I

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

Chicago, Il, US 57 days ago $93,600–$154,440

SQL SSIS SSAS SSRS PowerBI T-SQL ETL Data Modeling Dimensional Modeling Relational Modeling Modern Data Models Office 365 MS Teams Healthcare Data Analytics Epic Clarity Epic Clinical Data Warehouse Database Design Application Development System Administration Maintenance Activities Project Management Code Review Customer Service HIPAA Compliance JCAHO Standards

Data Architect

Lam Research

Fremont, Ca,Us, US 73 days ago $137,000–$287,000

Azure AWS Databricks SQL Python Spark Workday Adaptive Anaplan SAP BPC Azure Synapse Redshift ETL/ELT REST SOAP MS Fabric Power BI Data Lake Data Warehousing Dimensional Data Modeling

Sr Staff Data Architect

Gap Inc

Remote (Dallas-Coppell/Vari, US) 30 days ago

SQL ERwin PowerDesigner ER/Studio Hadoop Spark NoSQL dimensional_modeling star_schema snowflake_schema machine_learning agile_methodologies data_governance data_security data_privacy compliance_standards

Remote

Senior Data Solution Architect

Boeing

Remote (Usa - Seattle, Wa, US) 11 days ago $184,450–$217,000

AWS Azure DevOps Git Pivotal Cloud Foundry Tanzu Python JavaScript SQL DevOps CI/CD FastAPI ETL Data Warehousing Data Lakes API Configuration Cloud Platforms Data Modeling Data Ingestion Data Transformation Automation

Remote

Data Architect

The Federal Reserve

St. Louis, Mo, US 11 days ago

AWS SQL DataOps Kubernetes Terraform Docker CI/CD Prometheus Grafana PostgreSQL Apache Hadoop Apache Spark AI/ML Data Governance Time-Series Databases Metadata Management Platforms Elasticsearch Kafka

Data Architect

Booz Allen Hamilton

Locations Albuquerque, New Mexico, US 53 days ago $61,900–$141,000

AWS SQL Python ETL ELT data modeling relational databases data governance data pipelines Airflow dbt Redshift S3 Glue Athena