Developer Data Warehousing and Infrastructure - Jefferson Institutional Advancement

Jefferson Health Plans; Philadelphia (Philadelphia County); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Medical insurance

Dental and Vision

Retirement plans

Tuition assistance

Job summary

Jefferson Health Plans is seeking a data engineer to design, build, and optimize data warehousing solutions that support analytics and business intelligence. You will develop and maintain ETL/ELT workflows, ensure data accuracy, consistency, and performance across systems.

Collaborate with analysts and data scientists to translate requirements into scalable data solutions. You will evaluate tools, implement best practices, monitor pipelines and system health, and help automate routine tasks in a

Qualifications

• 3 years experience in data engineering or warehousing.
• Strong SQL skills and experience with ETL tools.
• Understanding of star and snowflake schemas for analytics.
• Exposure to cloud platforms and data governance practices.

Responsibilities

• 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.
• Monitor data pipelines and scheduled jobs for failures or performance issues.

Skills

ETL/ELT Development

Data warehousing

SQL

Cloud platforms

Code reviews

Education

Bachelor's Degree in Computer Science or related field

Tools

SSIS

Salesforce Data Cloud 360

MuleSoft

API development

Java/C#/Python

Job description

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

• Bachelor’s 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 65,000 people strong, dedicated to providing the highest-quality, compassionate clinical care for patients; making our communities healthier and stronger; preparing tomorrow’s 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 8,300 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 diemcolleagues, adjunct faculty, and Jeff Temps), have access to medical (including prescription) insurance.

For more benefits information, please click here