Data Engineer Professional

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, 11 specialty care centers, 1,300+ outreach clinics and more than 10,000 healthcare professionals representing the full spectrum of pediatric care specialties.

Here, we know it takes all of us, every role, to deliver the best possible care to each child and family we treat.

That’s why we build our teams toward a foundation of equity in access, advancement, and opportunity. We know teams of individuals with different identities and backgrounds can nurture creativity and innovation. We know we can see, treat, and heal children better when our team reflects the diversity of our patient population. We strive to attract and retain diverse talent because we know a truly inclusive and equitable workforce will help us one day realize our most basic calling: to heal every child who comes through our doors.

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.

Department: RI-Research informatics
Hours per week: 40, eligible for benefits
Shift: Full time, benefits eligible

This position is responsible for standard level work in data transformation and support of data systems for research. This position develops, tests, promotes, supports and maintains infrastructure and systems for data generation, storage and movement, 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, queries, standards, principles and practices. Specialty Areas include Research Data Warehousing, Data Virtualization, Epic, ETL and Data Networks

Specifically, the Software Developer/ETL Programmer will provide the technical database expertise required to build and maintain research data warehouses and databases, including design and development of system architecture, and development of databases and ETL. This position will design, administer and program in an Agile development environment that makes heavy use of open source tools, R, Python and SQL programming. Development and maintenance of APIs for various projects is also required. In addition, this position will ensure data is high-quality, including developing and maintaining data quality methods. This position is expected to have a high level of autonomy, in addition to collaborating with internal staff and customers (technical and clinical) and external collaborators (technical and clinical). This position interfaces frequently with analysts and staff to develop database scripts against disparate data sources, and to execute on technical components of projects. There will be opportunities to publish work in collaboration with colleagues. This position is a critical resource in developing and applying informatics and data warehousing techniques to obtain, validate, standardize, and manage scientific and clinical concepts. Experience with both Windows and Linux environments is preferred.

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.
• Gathers, analyzes and documents 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 technical documents. Integrates data between multiple systems for reporting as necessary.
• Collaborates with 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.
• 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 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.
• Participates in Production Support on-call rotation as necessary.

SCOPE AND LEVEL

• Guidelines: Possesses knowledge of and applies the fundamental concepts, practices and procedures within a particular field of specialization.
• Complexity: Duties and tasks are varied and somewhat complex, but usually involve limited responsibility. Procedures, methods and techniques to carry out work may not be well defined, requiring greater analysis.
• Decision Making: Has some discretion in making some 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 own function with team members, peers, management, clients and in limited cases, the public. Uses some discretion and independent judgment when information is exchanged, gathered and/or presented. Defers to higher level team members and/or management in many situations.
• Supervision Received: Works under some supervision, conferring with higher level employees, supervisor and/or manager as needed.

• EDUCATION – Bachelor's degree is required.
• EXPERIENCE – Minimum of three (3) years of related experience is required.
• EQUIVALENCY – Combination of post-high school education, job related certification and/or related experience equivalent to seven (7) years may be considered in lieu of minimum 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

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

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.