Developer Data Warehousing and Infrastructure Jefferson Institutional Advancement

Number of Positions In Requisition

1

Job Details

This position designs builds and optimizes data warehousing solutions to support analytics and business intelligence. They develop and maintain ETL workflows ensuring data accuracy consistency and performance across systems. This role involves collaborating with stakeholders to translate requirements into scalable technical solutions that improve accessibility and reporting. Developers also evaluate and implement tools and technologies to strengthen infrastructure reliability and efficiency

Job Description

Summary
This position designs builds and optimizes data warehousing solutions to support analytics and business intelligence. They develop and maintain ETL workflows ensuring data accuracy consistency and performance across systems. This role involves collaborating with stakeholders to translate requirements into scalable technical solutions that improve accessibility and reporting. Developers also evaluate and implement tools and technologies to strengthen infrastructure reliability and efficiency

Essential Functions:

• Design develop and maintain ETL/ELT workflows.
• Build and optimize data models for reporting and analytics.
• Ensure data accuracy consistency and performance across systems.
• Collaborate with business analysts and data scientists to deliver data solutions.
• Participate in code reviews and enforce best practices.
• Monitor system health performance capacity and availability using cloud-native tools.
• Help implement scripts and automation for routine tasks.
• Assist with basic troubleshooting of cloud-hosted applications and services.
• Assist data engineers and analysts by ensuring stable environments and reliable data operations.
• Monitor data pipelines and scheduled jobs for failures or performance issues.

Additional functions:

• ETL Tools: Experience with platforms such as Microsoft SSIS Salesforce Sales Cloud (DB Amp or MuleSoft preferred) and Salesforce Data Cloud 360 (Preferred)
• Understanding of Microsoft Fabric
• Proficiency in programming languages and API development (Java C# Python JavaScript; REST/gRPC) with strong understanding of architectural patterns and system design to support Data Science initatives

Minimum Qualifications

• Bachelors Degree Business Computer Science Finance Information Systems or related field.
• 3 years experience in data engineering or warehousing.
• Strong SQL skills and experience with Extract Transform Load (ETL) tools.
• Understanding of star schemas snowflake schemas and dimensional modeling for analytics.
• Exposure to cloud platforms.
• Strong attention to detail and ability to follow structured processes. Strong troubleshooting and analytical skills.
• Understanding of data governance and security practices.

Physical Demands
Lift and carry 25 lbs. frequent sitting/standing frequent keyboard use *patient care providers may be required to perform activities specific to their role including kneeling bending squatting and performing CPR.

Job Description Disclaimer: This position description provides the major duties/responsibilities requirements and working conditions for the position. It is intended to be an accurate reflection of the current position however management reserves the right to revise or change as necessary to meet organizational needs. Other responsibilities may be assigned when circumstances require.

Work Shift

Workday Day (United States of America)

Worker Sub Type

Regular

Employee Entity

Thomas Jefferson University

Primary Location Address

1101 Market Philadelphia Pennsylvania United States of America

Nationally ranked Jefferson which is principally located in the greater Philadelphia region Lehigh Valley and Northeastern Pennsylvania and southern New Jersey is reimagining health care and higher education to create unparalleled value. Jefferson is more than 65000 people strong dedicated to providing the highest-quality compassionate clinical care for patients; making our communities healthier and stronger; preparing tomorrows professional leaders for 21st-century careers; and creating new knowledge through basic/programmatic clinical and applied research. Thomas Jefferson University home of Sidney Kimmel Medical College Jefferson College of Nursing and the Kanbar College of Design Engineering and Commerce dates back to 1824 and today comprises 10 colleges and three schools offering 200 undergraduate and graduate programs to more than 8300 students. Jefferson Health nationally ranked as one of the top 15 not-for-profit health care systems in the country and the largest provider in the Philadelphia and Lehigh Valley areas serves patients through millions of encounters each year at 32 hospitals campuses and more than 700 outpatient and urgent care locations throughout the region. Jefferson Health Plans is a not-for-profit managed health care organization providing a broad range of health coverage options in Pennsylvania and New Jersey for more than 35 years.

Jefferson is committed to providing equal educational and employment opportunities for all persons without regard to age race color religion creed sexual orientation gender gender identity marital status pregnancy national origin ancestry citizenship military status veteran status handicap or disability or any other protected group or status.

Benefits

Jefferson offers a comprehensive package of benefits for full-time and part-time colleagues including medical (including prescription) supplemental insurance dental vision life and AD&D insurance short- and long-term disability flexible spending accounts retirement plans tuition assistance as well as voluntary benefits which provide colleagues with access to group rates on insurance and discounts. Colleagues have access to tuition discounts at Thomas Jefferson University after one year of full time service or two years of part time service. All colleagues including those who work less than part-time(including per diem colleagues adjunct faculty and Jeff Temps ) have access to medical (including prescription) insurance.

For more benefits information please click here

Required Experience:

IC