Data Architect I (Grant Funded)

Luriechildrens; Chicago (IL); On-site; USD 94,000 - 154,000; Full time

Benefits offered by this job

Health Insurance

PTO & Holidays

403(b) match

Job summary

Lurie Children’s Hospital of Chicago is seeking a Data Architect I to design, deploy and manage ETL jobs across EPIC Clarity, the Clinical Data Warehouse and external repositories within our hybrid on-premises and cloud data environment.

You will collaborate with the Data Discovery and Development team, create design documents, develop analytics solutions, and ensure HIPAA compliance while delivering scalable data systems.

Qualifications

• Bachelor's degree in IS, CS or related field.
• 1-3 years of database and data development experience.
• 1-3 coding experience in an object oriented language.
• Experience with SQL Server stack (SQL, SSIS, SSAS, SSRS, Power BI).
• Ability to design and implement Office 365 or MS Teams apps.
• Healthcare data and analytics familiarity (Epic knowledge preferred).
• Data modeling design experience (relational, dimensional, or modern models).
• Knowledge of multiple data solutions (ETL, ODS, Data Marts, Cubes, Reporting).

Responsibilities

• Design and implement ETL/data integration across EPIC Clarity, CDW, repositories in hybrid platform.
• Develop custom data/analytics solutions incl. database/app development.
• Provide monitoring/support and act as primary resolution point for issues.
• Install, deploy and upgrade data analytics systems; maintain docs.
• Scope requirements and create design documents.
• Create project plans and manage solutions.
• Develop/test ETL processes and perform code reviews.
• Consult with Information Management on software/hardware interactions.
• Maintain high customer-service standards.
• Adhere to HIPAA and JCAHO compliance.
• Prioritize projects with the Manager for Clinical Informatics.
• Support the Data Discovery and Development team.

Skills

SQL Server Stack

Power BI

ETL Design

Data Modeling

Communication Skills

Epic Knowledge

Office 365 Apps

Healthcare Analytics

Education

Bachelor's Degree

Tools

SSIS

SSAS

SSRS

EPIC

Power BI

Job description

Location

Simpson Querrey Biomedical Research Center

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. Ann & Robert H. Lurie Children’s Hospital of Chicago is ranked in all 10 specialties by the U.S. News & World Report.

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

Knowledge, Skill, and Abilities

• Bachelors 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 orient language.
• Knowledge/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 1 of the following : relational, dimensional, or modern data models.
• Knowledge/Experience in more than 1 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

Pay Range

$93,600.00-$154,440.00 Salary

At Lurie Children’s, 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 Children’s 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 following 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 Children’s facilities
• Discount purchasing program

There’s a Place for You with Us

At Ann & Robert H. Lurie Children’s Hospital of Chicago and its affiliates (collectively “Lurie Children’s”), we embrace and celebrate diversity and equity in a serious way. We are committed to building a team with a variety of backgrounds, skills, and viewpoints — recognizing that diverse identities strengthen our workplace and the care we can provide to the Chicago community and beyond. We treat everyone fairly, appreciate differences, and make meaningful connections that foster belonging and allyship.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.

Equal Employment Opportunity

Lurie Children’s and its affiliates are equal employment opportunity employers. We value diversity and are committed to creating an inclusive environment for all employees. 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.

For questions about how to request an accommodation please contact: [e-mail]

AI Notice

Lurie Children’s utilizes certain AI-enabled features within our recruiting platform to support candidate engagement and assist recruiters in identifying and prioritizing applicants whose experience aligns with job requirements. All employment decisions are made by individuals.

It is a civil rights violation with respect to recruitment, hiring, promotion, or employment for an employer to use artificial intelligence that has the effect of subjecting employees to discrimination on the basis of protected classes under the Illinois Human Rights Act or to use zip codes as a proxy for protected classes.

For questions about the use of artificial intelligence in this process or any additional support, please contact: [e-mail]