Hybrid Production Support Analyst presso PANTHERx Rare Pharmacy

7,000 Diseases - 500 Treatments - 1 Rare Pharmacy 
 

PANTHERx is the nation’s largest rare disease pharmacy, and we put the patient experience at the top of everything that we do.  

If you are looking for a career in the healthcare field that embraces authentic dedication to patient care, you don’t need to look beyond PANTHERx. In every line of service, in every position and area of expertise, PANTHERx associates are driven to provide the highest quality outcomes for our patients.   

We are seeking team members who:  

Are inspired and compassionate problem solvers; 

Produce high quality work;  

Thrive in the excitement of the ever-challenging environment of modern medicine; and  

Are committed to achieving superior health outcomes for people living with rare and devastating diseases.  

At PANTHERx, we know our employees are the driving force in what we do. We cultivate talent and encourage growth within PANTHERx so that our associates can continue to explore their interests and expand their careers. Guided by our mission to provide uncompromising quality every day, we continue our strategic growth to further reach those affected by rare diseases.   

Join the PANTHERx team, and define your own RxARE future in healthcare! 

Location: Pittsburgh, PA (Hybrid)

Classification: Exempt

Status: Full-Time

Reports to: Manager, Technical Reporting and Analytics

Purpose:

The Production Support Analyst will have experience in SQL, Git, and Azure DevOps or other similar tools. They will be responsible for managing the publishing of SQL queries and reports to production environments, resolving day-to-day operation issues, and executing routine data updates and cleanup tasks. The ideal candidate has a strong background in SQL, data workflows, and production system support, with the ability to troubleshoot and resolve issues in a timely and efficient manner.

Responsibilities:

• Publishes and maintains SQL-based reports and dashboards to production environments.
• Coordinates with development and business teams to ensure timely and accurate report delivery.
• Validates report output and performance post-deployment.
• Manages Git repository for deployed code.
• Monitors production jobs and reports for failures or anomalies.
• Investigates and resolves data-related issues or system errors reported by users.
• Maintains documentation of recurring issues and resolutions to support knowledge sharing.
• Maintains comprehensive documentation of data pipelines, processes, and query optimizations.
• Performs data corrections in accordance with requests proactive monitoring.
• Executes data cleanup processes to maintain data quality and integrity in production systems.
• Supports the data pipeline and ETL troubleshooting as needed.
• Works closely with developers, analysts, and business stakeholders to identify root causes and propose long-term fixes.
• Assists in optimizing production workflows and documentation to improve system reliability and support efficiency.

Required Qualifications:

• Bachelor’s degree or equivalent experience in one of the following fields: Computer Science, Information Systems, Data Analytics, Software Engineering, Mathematics or Statistics (if supplemented with technical experience)
• Minimum three (3) years of experience in production support, data operations, or SQL based role.
• Strong analytical and problem-solving skills.
• Proficiency in SQL and working with relational databases.
• Ability to work independently and as part of a team.
• Experience with ticketing systems (e.g., Azure DevOps, Jira.)
• Experience with Git code repositories.

Preferred Qualifications:

• Experience in healthcare, particularly specialty pharmacy.
• Familiarity with healthcare data standards such as HIPAA and HITECH.
• Familiarity with data warehousing concepts and ETL tools.
• Experience with BI/reporting tools (e.g., Power BI, Tableau, SSRS).

Work Environment

This job functions in a home office and professional office environment. When in-office this role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines, and communications via MS Teams.

Physical Demands

While performing the duties of this job, the employee is regularly required to sit, see, talk or hear. The employee frequently is required to stand; walk; use hands and fingers to handle or feel; and reach with hands and arms.  Visual acuity is necessary for tasks such as reading and working with various forms of data on a screen. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job.

Benefits:  

Hybrid, remote and flexible on-site work schedules are available, based on the position.  PANTHERx Rare Pharmacy also affords an excellent benefit package, including but not limited to medical, dental, vision, health savings and flexible spending accounts, 401K with employer matching, employer-paid life insurance and short/long term disability coverage, and an Employee Assistance Program!   Generous paid time off is also available to all full-time employees, as well as limited paid time off for part-time employees.  Of course we offer paid holidays too! 

Equal Opportunity: 

PANTHERx Rare Pharmacy is an equal opportunity employer, and does not discriminate in recruiting, hiring, promotions or any term or condition of employment based on race, age, religion, gender, ethnicity, sexual orientation, gender identity, disability, protected veteran's status, or any other characteristic protected by federal, state or local laws.