Overnight Production Support Engineer - Data Feeds & SQL

PANTHERx Rare Pharmacy; Pittsburgh (Allegheny County); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Dental coverage

Vision coverage

401K

Job summary

PANTHERx Rare Pharmacy in Pittsburgh, PA is seeking an overnight Production Support Engineer to monitor, troubleshoot, and remediate automated partner data solutions, ensuring SLA delivery.

The role requires strong SQL skills, independent problem solving, and the ability to follow runbooks, escalating only when necessary, with clear shift handoffs to the daytime team.

Work environment includes hybrid schedules, collaboration with data services, and a focus on reliability for healthcare data feeds.

Qualifications

• 3+ years of experience in production support, data operations, data analysis, or a closely related hands-on technical role.
• Strong SQL skills sufficient to independently investigate and diagnose data feed failures in a production environment.
• Demonstrated ability to troubleshoot technical failures methodically and remediate them under time pressure and deadline constraints.
• Experience with file-based data processing and an understanding of how data is extracted, transformed, and delivered as structured output files.
• Demonstrated ability to work independently with minimal real-time supervision, exercising sound judgment about when to remediate and when to escalate.
• Willingness and ability to work an overnight schedule on a Monday through Friday (24x5) coverage model, including rotation.
• Clear written communication skills; able to document incidents and shift handoffs precisely.

Responsibilities

• Feed Monitoring & Failure Detection: Monitors automated partner feed generation and SFTP delivery throughout the overnight window, responding to alerts that indicate a delivery failure or feed error.
• Triages incoming alerts and failures, classifying severity and identifying which partner feeds and SLAs are affected.
• Maintains situational awareness of the overnight feed delivery schedule and the SLA deadlines associated with each partner data solution.

Skills

SQL

Production support

Data operations

Troubleshooting

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field

Tools

Databricks

SQL on medallion architecture

Snowflake

Azure

AWS

Job description

PANTHERx Rare Pharmacy in Pittsburgh, PA is seeking an overnight Production Support Engineer to monitor, troubleshoot, and remediate automated partner data solutions, ensuring SLA delivery.

The role requires strong SQL skills, independent problem solving, and the ability to follow runbooks, escalating only when necessary, with clear shift handoffs to the daytime team.

Work environment includes hybrid schedules, collaboration with data services, and a focus on reliability for healthcare data feeds.