Data Architect I

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

Actively hiring Posted this week
Chicago, IL Posted 5 days ago $93,600–$154,440 / year
View original post Log in to save

At a glance

AI generated

TL;DR

The Data Architect I role at Simpson Querrey Biomedical Research Center involves designing and implementing ETL jobs and custom data solutions to integrate data across EPIC, departmental repositories, research databases, legacy systems, and external sources in a hybrid on-premises and cloud environment. This position requires developing database designs, interface programming, application development, and providing technical support for existing applications while adhering to HIPAA compliance standards. Key responsibilities include installing and maintaining data analytics systems, creating project plans, conducting code reviews, and collaborating with the Director of Data Development to prioritize projects. The ideal candidate has a Bachelor's degree in Information Systems or Computer Science, 3+ years of database development experience, advanced SQL knowledge, and proficiency with Microsoft Azure and the SQL Server stack including SSIS, SSAS, SSRS, and PowerBI. Experience in healthcare data analytics, particularly with EPIC systems, is preferred.

Skills

SQL SSIS SSAS SSRS PowerBI Azure ETL Data Modeling Object Oriented Programming SQL Server Python PostgreSQL CI/CD Git Kubernetes Docker JIRA Confluence Epic Clarity Epic Clinical Data Warehouse Office 365 MS Teams

What you'll do

  • Design and implement ETL solutions for integrating data across 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 routine maintenance.
  • Create project plans, manage projects, and provide technical guidance to resolve issues with assigned applications.
  • Support the reporting and data analytics team by developing and testing ETL processes.

What we're looking for

  • 3+ years of experience with database and data development.
  • Advanced knowledge of SQL including stored procedures, functions, dynamic SQL, triggers.
  • Experience with Microsoft Azure and the SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI).
  • Ability to design, write, and implement Office 365 or MS Teams applications.
  • Expertise in data modeling design and overall data solutions including ETL processes.
  • Bachelor's Degree in Information Systems, Computer Science, or related field.
  • Experience with healthcare data and analytics, preferably involving Epic systems.

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