This company is committed to hiring Veterans

Data Engineer 9/19/2017

The Children's Hospital of Philadelphia Philadelphia, PA

Philadelphia, PA
AJE Ref #
Job Classification
Full Time
Job Type
Company Ref #
Mid-Career (2 - 15 years)
Bachelors Degree


Req ID: 13421

Shift: Days

Employment Status: AF - Active - Regular - Full Time


Join a world renowned pediatric healthcare organization recently recognized in Computerworld as one of America's Best Places to Work in IT. The Children's Hospital of Philadelphia Enterprise Analytics team is responsible for the build and support of enterprise data warehousing as well as analytics in the form of creating standard reports, dash boards, and advanced data visualization. Our team is focused on delivering and supporting the data needs of the enterprise, including financial reporting and analytics, improving patient quality, advancing clinical reporting, analytics and research.

This position is responsible for the development of complex data integration processes, data transformation, and building on the data warehouse model within CHOP. The successful candidate will be required to ensure that the extracted, transformed, and displayed information meets all clinical and business requirements of the organization and end-users. This will entail creating new as well as maintaining and modifying existing ETL processes. This individual will be required to provide technical counsel and guidance to other team members, consultants, IS Staff, and end-users. Creating and maintaining accurate project and process documentation is also necessary.

This role will be focused on the day to day development of the CHOP logical data warehouse and taking part in high impact, high visibility projects in our data driven organization. The Agile Scrum methodology is utilized to drive the completion of tasks and goals. The opportunity to work hand in hand with key decision makers, as well as with small teams in your own department will be available.

We are looking for a teammate with an eager personality willing to expand our boundaries, provide new insights into future opportunities, build outside the box solutions, and have a willingness to find and deliver new and unique solutions. Ideally, you will have a strong desire to be on the forefront of advanced medicine and play a part in progressing the personalized approach to medicine. Interest in advanced data warehousing and reporting tools/techniques is welcomed, such as IBM Pure Data for Analytics (Netezza), IBM BigInsights (Hadoop), Apache Spark, Streaming Analytics, Cloud Data Integration and QlikView.

We offer a strong potential for growth and career advancement, and to make a major impact in the way we use data to provide a higher standard of care to our patients. If you have experience with data integration, ETL, APIs and cloud data integration, then apply today for an opportunity to join our seasoned and rapidly growing team.


Job Responsibilities:

1. Exhibits advanced knowledge of SQL; relational and multidimensional models, Data Warehousing methodologies (STAR and Snowflake Schemas), ETL concepts; and source and target structures.
2. Demonstrates advanced knowledge of and expertise in the technical facets of ETL (Extract, Transform and Load), Data Warehousing and BI (Business Intelligence) concepts and tools.
3. Exhibits ability to perform advanced aspects technology to install, test, maintain, develop, provide technical support of, understand and modify existing code and develop new code.
4. Understands cloud data integration concepts
5. Ability to work with APIs and object oriented programming languages for example Python and Java
6. Has the ability to navigate within a linux environment and build shell scripts.
7. Understands advanced uses of data in statistical environments and advanced analytic algorithms.
8. Understands institutional data model standards and can employ them in the environment.
9. Demonstrates basic knowledge of project management and related tools.
10. Demonstrates the ability to create detailed work-related documentation, operations documents and change management plans.
11. Exhibits the ability to communicate effectively with clients and colleagues.
12. Works with analysts to identify and understand source data systems.
13. Exhibits the ability to work with minimal supervision in support of team initiatives.
14. Demonstrates the ability to serve as a resource for other team members and to instruct other staff on various technical matters. Codes complex programs in required languages as defined in specifications prepared by IS personnel or vendors.


* Two (2) Certifications or proficiency in appropriate Business intelligence/Data Warehousing technology or subject domain.

* Bachelor s degree in computer related field required.

* 3-5 years of Business Intelligence/Data Warehousing experience, preferably in a healthcare environment.


Information Security Requirements

* Understands and complies with all enterprise and IS departmental information security policies, procedures and standards.

* Supports the integration of information security in the development, design, and implementation of Hospital Technology Resources that process, transmiton or store CHOP information.

* Supports all compliance activities related to state, federal regulatory requirements, healthcare accreditation standards, and all other applicable regulations that govern the use and disclosure of patient, financial, or other confidential information.

All CHOP employees who work in a patient building or who provide patient care are required to receive an annual influenza vaccine unless they are granted a medical or religious exemption.

Children\'s Hospital of Philadelphia is committed to providing a safe and healthy environment for its patients, family members, visitors and employees. In an effort to achieve this goal, employment at Children\'s Hospital of Philadelphia, other than for positions with regularly scheduled hours in New Jersey, is contingent upon an attestation that the job applicant does not use tobacco products or nicotine in any form and a negative nicotine screen (the latter occurs after a job offer).

Children\'s Hospital of Philadelphia is an equal opportunity employer. We do not discriminate on the basis of race, color, gender, gender identity, sexual orientation, age, religion, national or ethnic origin, disability or protected veteran status.

VEVRAA Federal Contractor/Seeking priority referrals for protected veterans. Please contact our hiring official with any referrals or questions.

CHOP Careers Contact

Talent Acquisition

2716 South Street, 6th Floor

Philadelphia, PA 19146

Phone: 866-820-9288