Data Architect I (*Grant Funded)

10 HOSP Ann & Robert H. Lurie Children's Hospital of Chicago; Chicago (IL); On-site; USD 93,600 - 154,440; Full time

Benefits offered by this job

Medical, dental and vision insurance

Employer paid group term life and disability

403(b) with a 5% employer match

Tuition assistance

Employee Assistance Program

Job summary

The 10 HOSP Ann & Robert H. Lurie Children's Hospital of Chicago is seeking a Data Architect I. This role involves designing, creating, deploying, and managing ETL jobs or other custom data applications and solutions in a hybrid data environment.

Salary ranges from $93,600 to $154,440 annually, and the position offers benefits like medical insurance, paid time off, and a 403(b) retirement plan with employer match.

Qualifications

• 1-3 years of experience with database and data development.
• 1-3 years of coding experience in object-oriented language.
• Knowledge and experience in more than one data solution.

Responsibilities

• Design and implement ETL or other data integration solutions.
• Develop custom data and analytics solutions.
• Provide application implementation monitoring and support.

Skills

SQL Server Stack

Object-oriented programming

Data modeling design

Healthcare data analytics

Excellent communication skills

Education

Bachelor's Degree in Information Systems

Tools

PowerBI

SQL

SSIS

SSAS

SSRS

Job description

Ann & Robert H. Lurie Children’s 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.

Location

Simpson Querrey Biomedical Research Center

Job Description

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 Discovery and Development team under the Stanley Manne Children’s Research Institute.

Job Duties

• 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.
• Develop 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.
• Provide 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.
• Install, deploy and upgrade data analytics systems; maintain documentation, and perform 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 Discovery 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, and Abilities

• Bachelor's Degree in Information Systems, Computer Science or related field.
• 1-3 years of experience with database and data development.
• 1-3 years of coding experience in object‑oriented language.
• Knowledge and experience with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI).
• Ability to design, write and implement Office 365 or MS Teams applications.
• Software administration experience.
• Working knowledge of healthcare data and analytics (prefer Epic knowledge).
• Data modeling design experience.
• At least one of the following data models: relational, dimensional, or modern data models.
• Knowledge and experience in more than one data solution (ETL, ODS, data marts, cubes, and reporting).
• Understanding of data integration problems, including validating and cleaning data.
• Excellent communication skills.

Education

Bachelor's Degree in Information Systems, Computer Science or related field.

Pay Range

$93,600.00 – $154,440.00 per year.

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

EEO Statement

Lurie Children’s and its affiliates are 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.

Contact

Support email: [e-mail]