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 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.

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.
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.
Web development skills (HTML, CSS, JavaScript, C# ASP.NET).

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!

Application Solutions Engineer

Key skills