Data Architect II

Ann & Robert H. Lurie Childrens Hospital of Chicago provides superior pediatric care in a setting that offers the latest benefits and innovations in medical technology research and family-friendly design. As the largest pediatric provider in the region with a 140-year legacy of excellence kids and their families are at the center of all we do. Ann & Robert H. Lurie Childrens Hospital of Chicago is ranked in all 10 specialties by the U.S. News & World Report.

The Data Architect II will be responsible for designing creating deploying and managing ETL jobs or other custom data applicationssolutions. The projects will involve integrating data among EPIC departmental repositories research data legacy and external repositories in the hospitals 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.

Essential Functions

• 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 hospitals 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

Knowledge Skills & Abilities

• 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

Education

Pay Range

At Lurie Childrens we are committed to competitive and fair compensation aligned with market rates and internal equity reflecting individual contributions experience and expertise. The pay range for this job indicates minimum and maximum targets for the position. Ranges are regularly reviewed to stay aligned with market conditions.In addition to base salary Lurie Childrens offer a comprehensive rewards package that may include differentials for some hourly employees leadership incentivesfor select roles health and retirement benefits and wellbeing programs. For more details on other compensation consult your recruiter or click the followinglink to learn more about our benefits.

Benefit Statement

For full time and part time employees who work 20 or more hours per week we offer a generous benefits package that includes:

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

Various voluntary benefits:

• 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 Childrens facilities

• Discount purchasing program

Theres a Place for You with Us

At Lurie Childrens we embrace and celebrate building a team with a variety of backgrounds skills and viewpoints recognizing that different life experiences strengthen our workplace and the care we provide to the Chicago community and beyond. We treat everyone fairly appreciate differences and make meaningful connections that foster belonging. This is a place where you can be your best so we can give our best to the patients and families who trust us with their care.

Lurie Childrens and its affiliatesare equal employment opportunity employers. All qualified applicants will receive consideration for employment without regard to race color sex sexual orientation gender identity or expression religion national origin ancestry age disability marital status pregnancy protected veteran status order of protection status protected genetic information or any other characteristic protected by law.

Support email: