ETL Developer II- Finance (PFK)

ETL Developer II - Finance

Full-Time, 40 hours per week, Salary, Exempt

Monday - Friday, 8am - 5pm

The ETL Developer will clean, manipulate, and model data from the EMR and external data sources to create the maximum value for the organization. The individual will collect metadata and business process information from a variety of sources and analyze the information to provide insight and recommendations into the standardization of data definitions and processes.

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 16,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.

Lead and manage the requirements collection, design, and delivery of the data solutions and ETL processes.
• Code and documents scripts and stored procedures. Design and implement data strategy methods.
• Perform data sourcing analysis and data dictionary administration, to include developing new data dictionaries.
• Define and implement best practices for ETL design, develop and implement data modeling standards including element naming conventions.
• Transform business requirements into logical data models.
• Design, develop, test and deploy dashboards, reports and alerts/notifications for the presentation of business metrics according to business user requirements consistent with integrated BI applications and warehouse structure.

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.

EDUCATION:

• Bachelor's degree or equivalent combination of education and experience required.
• Preferred fields of study include Computer Science, Engineering, or Information Services.

EXPERIENCE:

• 3 years of progressive data warehousing/database experience (e.g. Consultant, Systems Analyst, Software Engineer).
• Experience working with healthcare data in general and specifically healthcare claims data is preferred.
• Experience creating dashboards in a Business Intelligence tool. Power BI or Qlik preferred.
• Familiarity with hospital coding systems (including ICD, CPT, MSDRG, APRDRG) as well as experience using medical terminology.
• Experience working in an Agile environment

SKILLS:

• Demonstrated analytical and problem-solving skills to test and validate data, as well as evaluate and understand large and complex information sets.
• Strong SQL skills required. Oracle or SQL Server preferred.
• Excellent communication and organizational skills with the ability to interact with a diverse group, executives, managers, and subject matter experts.
• Ability to manage multiple projects and complete each thoroughly, accurately and on-time.
• Attention to detail and ability to function independently with minimal oversight.