Data Engineer

Join PANTHERx

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: Data Engineering Manager

Purpose

The Data Engineer creates, operates, and extends data pipelines and/or orchestration solutions built in SQL Server or Azure Databricks environments. This role develops solutions to support the business and operational needs of internal and external partners, commonly applying SQL and ETL tools to optimize outcomes.

Responsibilities

• Design and Develop Data Pipelines: Creates and maintains robust data pipelines using Databricks, Spark, SQL, or SSIS.
• ETL/ELT Processes: Develops and manages efficient ETL/ELT processes for data extraction, transformation, and loading.
• Data Integration: Integrates data from various sources, ensuring data quality and consistency.
• Query Writing and Optimization: Writes, optimizes, and maintains complex SQL queries to enhance performance.
• Collaborate with Stakeholders: Works closely with analysts and stakeholders to understand data requirements and deliver solutions.
• Performance Tuning: Optimizes data pipelines, SQL queries, and Delta Tables to ensure high performance and scalability.
• Data Quality Assurance: Ensures the accuracy and reliability of data through rigorous testing and validation.
• Documentation: Maintains comprehensive documentation of data pipelines, processes, and query optimizations.
• Continuous Improvement: Identifies and implements opportunities for process improvements and automation.

Required Qualifications

• Bachelor's degree in computer science, Mathematics, Statistics, or a related field.
• Minimum 4 years of experience in data engineering, including:
• Advanced SQL
• Azure Data Factory or other ETL tools
• Python or other programming languages
• Azure Databricks or Spark
• Azure DevOps or other CI/CD tools
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Strong attention to detail and ability to maintain data accuracy and integrity.

Preferred Qualifications

• Experience in healthcare, particularly specialty pharmacy.
• Familiarity with healthcare data standards such as HIPAA and HITECH.
• Proficiency working with Azure Log Analytics.
• Knowledge of dimensional data modeling.
• Data Warehousing Experience

Work Environment

PANTHERx Rare Pharmacy offers flexibility only to eligible employees to work hybrid or remotely without compromising work performance, productivity, or team collaboration. This role routinely uses standard office equipment such as computers and phones.

Physical Demands

While performing the duties of this job, the employee is regularly required to talk, hear, and see. The employee frequently is required to sit, stand, and walk; use hands and fingers, handle or feel; reach with hands and arms and view a computer screen for extended periods of time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function 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.