SQL Developer - Enterprise Data & Analytics

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:

Purpose

The SQL Developer plays a key role within the Enterprise Data & Analytics team by designing, developing, and optimizing SQL-based solutions that support data extraction, reporting, and analytical needs across the organization. This role builds efficient data processes, ensuring data quality, and enabling reliable insights for business stakeholders. The SQL Developer works closely with data engineers, analysts, and business units to deliver scalable, well‑structured, and high‑performing data assets.

Responsibilities

SQL Development & Data Processing

• Develops, tests, and maintains complex SQL queries, stored procedures, views, and functions to support data extracts, transformations, and reporting workloads.
• Builds automated data pipelines and repeatable processes for delivering analytic datasets and operational reporting.
• Performs query tuning and optimization to ensure high performance across large and complex datasets.
• Creates and maintains source‑to‑target mapping, data lineage documentation, and ensures data consistency across systems.
• Conducts data profiling, validation, and quality checks to ensure accuracy and completeness within the EDW and downstream datasets.
• Collaborates with data engineers to integrate SQL processes into broader ETL/ELT and data platform pipelines.

Reporting & Analytics Support

• Develops and supports reports, datasets, and semantic layers used by BI tools (Power BI, Tableau, etc.).
• Works with business stakeholders to gather reporting and analytic requirements to translate into technical specifications.
• Ensures all reports and analytic outputs align with business definitions, KPIs, and governance standards.
• Troubleshoots reporting datasets, SQL logic, data issues, and performance bottlenecks.
• Conducts data profiling and quality checks across source systems and EDW layers.

Collaboration & Documentation

• Partners with data scientists, data engineers, analysts, BI developers, and business stakeholders to deliver integrated solutions and AI-enhanced insights.
• Participates in the planning and execution of data initiatives, ensuring alignment with business objectives.
• Provides technical guidance and mentorship to junior team members regarding SQL best practices and data modeling.
• Maintains comprehensive documentation for SQL code, data structures, business rules, and process flows.

Continuous Improvement

• Stays current with SQL best practices, database technologies, and performance‑tuning techniques.
• Recommends improvements to existing SQL code, data models, processes, and reporting frameworks.
• Participates in evaluating new tools and technologies that may enhance data processing or reporting efficiency.

Required Qualifications

• Bachelor’s degree in computer science, Business Administration, or related field.
• Minimum of two (2) years of EDW development, SQL programming, and data integration.
• Strong proficiency in SQL.

Preferred Qualifications

• Healthcare business process and technology experience.
• Familiarity with iterative development methodologies (Agile).
• Experience with BI/reporting tools (Power BI, Tableau, SSRS).
• Experience with cloud data platforms (Databricks, Snowflake, Azure Synapse/Data Factory/SQL Databases, AWS Redshift).
• Experience with AI/ML frameworks (e.g., Azure Machine Learning, Spark MLlib).
• Knowledge of data governance and compliance best practices.
• Python development experience.

Work Environment

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.

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.