Overview

The ETL Support Analyst will be required to support a daily ETL process that loads an Enterprise Data Warehouse. The candidate should have knowledge of ETL processing and troubleshooting ETL code to support job failures. The individual will also be responsible for ETL code migrations from a non-production environment to a production environment. This role will also troubleshoot any ETL production incidents that are submitted

Why Nationwide Children's Hospital?

The moment you walk through our doors, you feel it. When you meet our patient families, you believe it. And when you talk with anyone who works here, you want to be part of it. Welcome to Nationwide Children’s Hospital, Where Passion Meets Purpose.

Here, Diversity, Equity and Inclusion are integrated into our core values and practices. We are passionate about building, sustaining and evolving an inclusive and equitable environment. We are seeking individuals who live these values and want to share their experiences and efforts in support of our collective mission.

We’re 14,000 strong. And it takes every one of us to improve the lives of the kids we care for, and the kids around the world we’ll never meet. Kids who live healthier, fuller lives because of the knowledge we share. We know it takes a Collaborative Culture to deliver on our promise to provide the very best, innovative care and to foster new discoveries, made possible by the most groundbreaking research. Anywhere.

Ask anyone with a Nationwide Children’s badge what they do for a living. They’ll tell you it’s More Than a Job. It’s a calling. It’s a chance to use and grow your talent to make an impact that truly matters. Because here, we exist simply to help children everywhere.

Nationwide Children’s Hospital. A Place to Be Proud.

Responsibilities

• Provide monitoring and application support for the ETL application environments (Business Objects Data Services and SSIS).
• Create and maintain support documentation for the team
• Analyze and resolve ETL job failures.
• Be the first responders, regularly communicate the status of the daily ETL jobs or any issues through appropriate communication channels.
• Resolve all incidents and code migrations within SLA targets.
•  Diagnose and escalate issues where applicable.
•  During crisis conditions, willing to act in the role of problem facilitator to drive cross functional efforts of various teams toward issue resolution.
•  Ensure proper handoffs of issues or support as necessary.

Note: Regular, reliable, and consistent attendance is an essential job function. Employees are expected to perform work as scheduled. Please see the physical requirements for this position listed below.

Qualifications

KNOWLEDGE, SKILLS AND ABILITIES REQUIRED

• Bachelor’s degree in computer science, information systems or related field
• 2 years of experience in SQL
• 1-2 years of experience in data warehousing and ETL concepts
• Experience working with healthcare data, specifically EPIC Clarity is preferred
• Strong interpersonal and communication skills
• Experience in Agile methodology
• 1-2 years of experience in the following:
  • Business Objects Data Services
  • SSIS
  • Unix or Linux
  • Shell scripting
  • Optimization of large data loads

MINIMUM PHYSICAL REQUIREMENTS

• Sitting Frequently 
• Talking on phone/in person
• Typing on a keyboard 
• Standing/walking 

The above list of duties is intended to describe the general nature and level of work performed by individuals assigned to this classification. It is not to be construed as an exhaustive list of duties performed by the individual so classified, nor is it intended to limit or modify the right of any supervisor to assign, direct, and control the work of employees under his/her supervision.

EOE/M/F/Disability/Vet