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 include designing and developing robust data pipelines using Databricks, Spark, SQL, or SSIS and managing efficient ETL/ELT processes.
Integrating data from various sources, ensuring quality and consistency, writing and optimizing complex SQL queries, and collaborating with stakeholders to understand data requirements.
Performance tuning and ensuring data accuracy and reliability through rigorous testing.

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

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!

Data Engineer

Key skills