Penn State Health BI Data Integration Developer - Sr - PSH IT Enterp Info Mgmt in Hershey, Pennsylvania

Penn State Health Shared Services

Location: US:PA:Hershey

Work Type: Full Time

FTE: 1.0

Shift: Day

Hours: 8am - 5pm


Under minimal direction from the BI Data Integration Architect Team Lead, this developer role is responsible for data integration scripting, optimization of the data integration environment, and recommend improvements to data integration techniques. Responsible in building the functions necessary to extract, transform, and load (ETL) data and metadata to transactional systems and data warehousing environments. Provide troubleshooting and incident support for existing scripts and execute problem management to maintain high availability of integration services.


Bachelor's Degree plus 4 years of related experience an equivalent combination of education and experience required.

Experience designing, developing, and maintaining databases and data warehouses in a complex business environment required.

Experience with SAP BusinessObjects, McKesson HPM/HBI, IBM DataStage or similar enterprise business intelligence applications required.


Knowledge of the semantic layer, multi-dimensional analysis, dashboards and scorecards required.

Understanding of business requirements gathering and systems analysis required.

Adheres to and exhibits our organizational core values as outlined by Penn State Health.

This job description is a general outline of duties performed and is not to be misconstrued as encompassing all duties performed within the position. All individuals (including current employees) selected for a position will undergo a background check appropriate for the position's responsibilities.

Penn State Health is an equal opportunity, affirmative action employer, and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity or expression, national origin, disability or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please call 717-531-8440 between the hours of 8:30 AM and 4:30 PM, Eastern Standard Time, Monday – Friday, email or download our Accommodation Instructions for Job Applicants PDF for more detailed steps for assistance.