Job ID

68291

Location

Aurora, Colorado

Full/Part Time

Full-Time

Regular/Temporary

Regular

Why Work at Children's....

Here, it’s different. Come join us.

Children's Hospital Colorado has defined and delivered pediatric healthcare excellence for more than 100 years.

Here, the nation’s brightest nurses, physicians, scientists, researchers, therapists and care providers are creating the future of child health. With an optimist’s outlook, a trailblazing spirit and a celebrated history, we’re making new strides every day.

We’ve been Magnet-designated four times by the American Nurses Credentialing Center and are consistently recognized among the nation’s top 10 pediatric hospitals by U.S. News & World Report. 

As a national leader in pediatric care, we serve children and families from all over the nation. Our System of Care includes four pediatric hospitals, 12 specialty care centers, 400 outreach clinics and 7,000 healthcare professionals representing the full spectrum of pediatric care specialties.

We need your expertise.

A career at Children's Colorado will challenge you, inspire you, and motivate you to make a difference in the life of a child. Here, it’s different. Do you have what it takes?

Additional Information

Department: Analytics Resource Center

Hours per week: 40, eligible for benefits

Shift: Days

Job Overview

This position is responsible for full performance complex systems analysis, design and applications programming for single and multiple information systems, software applications, architectures, data warehouses, databases, and data extraction and reporting. Duties include designing, planning, testing, implementing, maintenance, problem solving, documenting, and developing software code, standards, principles and practices. This position may perform lead work over lower level staff.

In this pivotal position, successful candidate will be responsible for the design and development of a surgical quality data platform and assisting with program development. Duties include designing, planning, testing, implementing, maintenance, problem solving, documenting, and developing solutions, standards, principles, and practices. This position may perform lead work over lower level staff.

Specialty Areas: Full stack analytic development including solution design, data modeling, ETL development, dashboard development, virtual data warehouse development, Epic EHR, and clinical quality systems / process

Responsibilities

POPULATION SPECIFIC CARE

No direct patient care.

ESSENTIAL FUNCTIONS

An employee in this position may be called upon to do any or all of the following essential functions. These examples do not include all of the functions which the employee may be expected to perform.

Analyzes, designs, builds, modifies, implements, tests and debugs new or existing software applications, architectures, databases, and systems integration to automate business processes, as applicable.

Prepares time lines, project plans and flow charts for the development or enhancement of new and existing software application programs.

Provides enterprise level application design guidance and consultation. Collaborates with development team, business intelligence, manager, customers and project managers to develop requirements, applications, systems, data warehouse and database requirements to meet organizational and end user needs. Provides recommendations regarding configuration, design, usability and maintainability for services, applications, interfaces and other dependencies that integrate with platforms.

Gathers, analyzes and documents complex business and user requirements, functional requirements and data specifications.

Designs, writes and documents technical specifications to design or redesign complex applications.

Collaborates with applications staff and users of information systems to evaluate, plan, design, develop, test, implement, and maintain application development efforts and/or reports. Works with applications staff to translate and document user needs and system requirements into report specification and/or techinical documents. Integrates data between multiple systems for reporting as necessary.

Performs database tuning and configuring; developing backup and recovery processes, repeatable methods to refresh non-production environments from production, data life-cycle management, and system upgrades. Writes stored procedures, packages, and functions.

Designs and develops complex processes required to extract, transform, cleanse and load data into the enterprise data warehouse and data marts. Develops solutions to address data warehouse query performance and quality issues including data profiling, development, enhancement, and technical standards. Ensures reporting systems are maintained, and supported during system and database upgrades and modifications.

Recommends, develops and creates peripheral technologies and IT processes in support of application platforms.

Recommends, develops, documents and maintains software coding and development standards, principles and practices.

Troubleshoots complex performance and system availability problems ensuring quality of the enterprise application and/or data warehouse. Consults with end users and information technology staff to identify user problems.

Designs, develops, tests, debugs, implements, and prepares flow charts for both new and existing systems. May assist lower level developers in the development of complex applications and coding.

Serves as a technical resource for modeling, simulation and analysis efforts. Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.

Participates in Production Support on-call rotation as necessary

Other Information

SCOPE AND LEVEL

Guidelines: Possesses and applies a broad knowledge of concepts, practices and procedures within a particular field of specialization.

Complexity: Duties and tasks are broad and complex, usually requiring a greater degree of responsibility. Procedures, methods and techniques to carry out work may not be well defined, requiring advanced knowledge in specific specialties and of the organization.

Decision Making: Has latitude in making most decisions. Decisions and recommendations are made after contemplative analysis and with independent judgment and ingenuity. May escalate the most complex and important decisions to a higher level employee, supervisor and/or manager.

Communication: Communicates explanatory and/or interpretive information relative to the organization and/or advanced knowledge of own function with team members, peers, management, clients and in some cases, the public. Uses discretion and independent judgment is exchanged, defended, gathered and/or presented. Defers to higher level team members and/or management only when necessary.

Supervision Received: Works under limited supervision and with a high degree of independence, conferring with supervisor and/or manager on unusual matters. May be assisted by lower level employees.

Qualifications

EDUCATION – Bachelor's degree is required.

EXPERIENCE – Minimum of five (5) years of related experience is required.

Strong SQL skills preferred 

Knowledge of Epic and/or clinical quality systems and processes preferred 

EQUIVALENCY – Combination of post-high school education, job related certification, and/or related experience equivalent to nine (9) years may be considered in lieu of minimum requirements.

Physical Requirements

Ability to Perform Essential Functions of the Job

Vision - Near: clear vision at 20 inches or less

Weight Lifted/Force Exerted: up to 10 pounds/4.5 kilos, up to 1/3 of time

Hearing: able to clearly hear details

Sit: 2/3 or more of time

Talk: able to communicate verbally

Mental/Emotional: able to work in close proximity to others and/or in a distracting environment

Mental/Emotional: able to cope with stress effectively

Mental/Emotional: able to prioritize effectively

Work Environment

Mental/Emotional: able to tolerate ambiguity

Mental/Emotional: able to prioritize effectively

Mental/Emotional: may be subject to many interruptions

Office Work Environment: Regular/frequent exposure

Bloodborne Pathogen Category 2: Occasional exposure to blood/body fluid

Equal Employment Opportunity

It is our intention that all qualified applicants be given equal opportunity and that selection decisions be based on job-related factors. We do not discriminate on the basis of race, color, religion, national origin, sex, age, disability, or any other status protected by law or regulation. Be aware that none of the questions are intended to imply illegal preferences or discrimination based on non-job-related information.

Salary Information

Annual Salary Range (Based on 40 hours worked per week): $101,810.74 to $152,716.11

Hourly Salary Range: $48.95 to $73.42

Benefits Information

As a Children’s Hospital Colorado team member, you will receive a competitive pay and benefits package designed to take care of your needs that includes base pay, incentives, paid time off, medical/dental/vision insurance, company provided life and disability insurance, 403b employer match (retirement savings), and a robust wellness program.