Data Architect I — Hybrid Cloud ETL & Analytics

Lurie Children's Hospital; Chicago (IL); On-site; USD 94,000 - 154,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

PTO and holidays

403(b) with 5% employer match

Parental leave

Life & disability insurance

Job summary

Ann & Robert H. Lurie Children’s Hospital of Chicago seeks an Data Architect I to design, deploy, and manage ETL jobs within a hybrid on-premises and cloud data environment.

You will integrate data across EPIC, departmental repositories, and research data, supporting the Data Discovery and Development team. The role requires 1–3 years in data development, SQL Server expertise, and knowledge of healthcare data analytics; a Bachelor's degree is required.

Qualifications

• Bachelor's Degree in Information Systems, Computer Science or related field.
• 1-3 years of experience with database and data development.
• 1-3 coding experience in object oriented language.
• Knowledge/Experience with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI).
• Ability to design, write and implement Office 365 or MS Teams applications.
• Working knowledge of Healthcare data and analytics (Epic knowledge preferred).
• Data modeling design experience: relational, dimensional, or modern data models.

Responsibilities

• Design and implement ETL or other data integration solutions among EPIC Clarity, EPIC Clinical Data Warehouse, departmental repositories, research data, legacy and external repositories in the hospital’s hybrid and unified data platform.
• Develops custom data and analytics solutions to collect, manage, and distribute data including database design and programming, interface design and programming, and application development and implementation.
• Provides application implementation monitoring and support for existing and/or new applications, technical guidance, and serve as primary resolution point for all issues regarding assigned applications.
• Installs, deploys and upgrades data analytics systems; maintains documentation, and performs routine systems administration maintenance activities.
• Scope client requirements and create design documents.
• Create project plans and project manage solutions.
• Develop and test ETL or other data integration processes; provide code review for other team members.
• Consult with Information Management staff regarding the interaction between computer software, hardware, and peripherals.
• Respond to all requests with high standards for customer service.
• Adhere to HIPAA and JCAHO compliance standards.
• Perform job functions adhering to service principles with customer service focus of innovation, service excellence and teamwork to provide the highest quality care and service to our patients, families, co-workers and others.
• Work with the Manager for Clinical Informatics to prioritize projects
• Support the Data Discovery and Development team

Skills

ETL design

SQL Server

Power BI

Data modeling

Healthcare data

Communication

Education

Bachelor’s Degree

Tools

EPIC Clarity

EPIC CDW

Office 365

MS Teams

Job description

Ann & Robert H. Lurie Children’s Hospital of Chicago seeks an Data Architect I to design, deploy, and manage ETL jobs within a hybrid on-premises and cloud data environment.

You will integrate data across EPIC, departmental repositories, and research data, supporting the Data Discovery and Development team. The role requires 1–3 years in data development, SQL Server expertise, and knowledge of healthcare data analytics; a Bachelor's degree is required.