Data Architect I

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

11d•$93,600 - $154,440•Onsite

About The Position

The Data Architect I will be responsible for designing, creating, deploying and managing ETL jobs or other custom data applications/solutions. The projects will involve integrating data among EPIC, departmental repositories, research data, legacy and external repositories in the hospital’s hybrid (on-premises and cloud) data environment. This position will also be responsible for the administration of data analytics systems under the ownership of the Data Analytics & Reporting team.

Requirements

Bachelors Degree in Information Systems, Computer Science or related field
3+ years of experience with database and data development
3+ years of Object Oriented Programming
Advanced knowledge of SQL – stored procedures, functions, dynamic SQL, triggers, etc.
Experience with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI)
Ability to design, write and implement Office 365 or MS Teams applications.
Microsoft Azure Experience
Advanced Data modeling design experience.
Experience in overall data solutions (ETL, ODS, Data Marts, Cubes, and Reporting)
Experience with Solution architecture
Ability to work independently on complex project
Working knowledge of Healthcare data and analytics (prefer Epic knowledge)
Understanding of data integration problems, including validating and cleaning data
Ability to work independently on complex project
Ability to collaborate in iterative design process with users
Excellent communication skills

Nice To Haves

prefer Epic knowledge

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
Support the reporting and data analytics team
Work with the Director of Data Development to prioritize projects
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

Benefits

Medical, dental and vision insurance
Employer paid group term life and disability
Employer contribution toward Health Savings Account
Flexible Spending Accounts
Paid Time Off (PTO), Paid Holidays and Paid Parental Leave
403(b) with a 5% employer match
Supplemental Life, AD&D and Disability
Critical Illness, Accident and Hospital Indemnity coverage
Tuition assistance
Student loan servicing and support
Adoption benefits
Backup Childcare and Eldercare
Employee Assistance Program, and other specialized behavioral health services and resources for employees and family members
Discount on services at Lurie Children’s facilities
Discount purchasing program