The Data Architect I role within the Data Analytics & Reporting team at a leading healthcare institution involves designing and implementing ETL solutions 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 custom data analytics applications, providing technical support for existing systems, and managing project plans while adhering to HIPAA and JCAHO standards. Key skills required are 1-3 years of database development experience, proficiency with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI), and knowledge of healthcare data analytics, particularly EPIC systems. The role demands strong communication abilities and the capacity to design robust data models and integrate diverse data sources effectively in a high-compliance setting.
Skills
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
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 to deliver data integration processes efficiently.
Provide technical support and resolve issues related to assigned applications for the reporting team.
What we're looking for
Bachelor's degree in Information Systems, Computer Science or related field.
1-3 years of experience with database and data development.
Proficient in SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI).
Experience designing and implementing ETL processes for hybrid data environments.
Knowledge of healthcare data analytics, preferably with Epic system expertise.
Ability to design and implement custom data solutions including database programming.
Market check
Salary context
This
$93,600–$154,440
range sits above
17%
of similar postings on FindRole.
Peer median band
$123,700–$199,400
Median floor and ceiling across peers.
Typical midpoint (25–75%)
$126,800–$207,500
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.
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