Application Solutions Engineer

Pantherx Specialty LLC; Robinson (PA); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision

401K with employer matching

Paid time off

Employee Assistance Program

Paid holidays

Job summary

PANTHERx Rare Pharmacy is seeking an Application Solutions Engineer in Pittsburgh, PA. The role combines data engineering, SQL development, and application support to optimize pharmacy applications and data platforms. Hybrid work options are available.

Strong analytical skills and experience with modern data platforms are essential for delivering high-quality patient outcomes. Responsibilities include developing reports, tuning data pipelines, and providing technical support for specialty

Qualifications

• Bachelor’s degree in IT, CS, or equivalent experience.
• 4+ years of experience in relational databases and application development/support.
• Advanced SQL (T-SQL, PL/SQL), PowerShell, Python (or similar).
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent verbal and written communication; ability to manage multiple projects.

Responsibilities

• Develops and maintains reports and solutions using SQL.
• Writes and optimizes complex SQL queries for performance and scalability.
• Implements performance tuning for data pipelines and application components.
• Provides technical support for specialty pharmacy applications and related systems.
• Troubleshoots software and connectivity issues; escalate when appropriate.
• Communicates complex technical issues clearly to non-technical end users.
• Documents issues, resolutions, and workflows in a ticketing system.
• Monitors trends and opportunities for improvement.
• Collaborates with end-users and support teams to resolve system issues.
• Maintains documentation for data processes and query optimizations.

Skills

Advanced SQL

PowerShell

Python

Education

Bachelor’s degree in IT/CS

Tools

WellSky

Azure DevOps

ETL tools

Job description

Current job opportunities are posted here as they become available.

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: Full-time

Status: Exempt

Reports to: Manager, Systems Support

Purpose

The Application Solutions Engineer analyzes and troubleshoots pharmacy applications, combining expertise in data engineering, SQL development, and application support. This role requires strong analytical skills, experience with modern data platforms, and the ability to optimize both data and application systems.

Responsibilities

Application Solutions & Support

• Develops and maintains reports and solutions using SQL.
• Writes and optimizes complex SQL queries for performance and scalability.
• Implements performance tuning for data pipelines and application components.
• Provides technical support for specialty pharmacy applications and related systems.
• Troubleshoots software and connectivity issues; elevate when appropriate.
• Communicates complex technical issues clearly to non-technical end users.
• Documents issues, resolutions, and workflows in a ticketing system.
• Monitors and reports trends, recurring issues, and opportunities for improvement.
• Collaborates with end-users and support teams to resolve system issues.
• Works closely with stakeholders to gather requirements, solve issues, and deliver solutions.
• Maintains comprehensive documentation for data processes, application components, and query optimizations.
• Communicates status updates and technical details effectively across teams.
• Stays current with emerging technologies, programming languages, and industry trends.
• Identifies opportunities for automation and process improvement.
• Observes and report trends, recurring issues, and areas for enhancement.

Required Qualifications

• Bachelor’s degree in IT, Computer Science, or equivalent experience.
• Minimum of four (4) years of experience in relational databases and application development/support.
• Proficiency in:
  • Advanced SQL (T-SQL, PL/SQL)
  • PowerShell
  • Python or similar programming languages
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent verbal and written communication skills.
• Ability to manage multiple projects simultaneously.

Preferred Qualifications

• Experience in healthcare or specialty pharmacy.
• Familiarity with WellSky applications.
• Knowledge of HIPAA and healthcare data standards.
• Understanding Agile methodologies and CI/CD tools (Azure DevOps).
• Proficiency in ETL tools.

This position operates in a home or professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

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 for extended periods of time. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job.

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!

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.