Data Engineer - Pharmacy

On Demand is now Vubiquity - http://www.linkedin.com/company/vubiquity; BLOOMINGTON (MN); Hybrid; USD 166,000 - 187,000; Full time

Benefits offered by this job

Healthcare

Dental

Vision

Job summary

On Demand is now Vubiquity seeks a Data Engineer to design and maintain Azure Databricks–based data pipelines supporting pharmacy claims data and analytics. The role emphasizes data quality, reliability, and scalable engineering practices in a hybrid/remote environment, with preference for candidates in MN or nearby regions.

The ideal candidate will bring 2+ years of data engineering experience, strong Python and SQL skills, and hands-on Azure Databricks/ADF expertise to collaborate with

Qualifications

• Bachelor's degree or equivalent experience in CS, engineering, or data science.
• 2+ years hands-on data engineering experience.
• Strong Python and SQL experience.
• Experience with Azure Data Platform (Databricks/ADF).
• Experience building ETL/ELT pipelines and data validation.

Responsibilities

• Design, build, and maintain cloud-based data pipelines on Azure Databricks.
• Ingest, transform, and validate pharmacy and claims data.
• Implement data quality checks and monitoring.

Skills

Python

SQL

Data pipelines

ETL/ELT

Data quality

Education

Bachelor's degree in CS/Engineering/Data Science

Tools

Azure Databricks

Azure Data Factory

Cloud data pipelines

Job description

Job Description

Title:

Data Engineer (Azure / Databricks)

Location:

Hybrid / Remote (Preference: MN ? 5-state region ? national)

Pay Rate:

$80-$90

Conversion Salary Range:

$120K–$150K DOQ

Overview

Our client is seeking a high-performing Data Engineer to join their Pharmacy Data team within Data Operations / EIM. This role is critical to supporting pharmacy claims and related data pipelines as the organization continues its transition from on-prem systems to a modern Azure-based data platform.

This is a contract-to-hire opportunity focused on improving data quality, reliability, and engineering rigor. The ideal candidate will bring strong technical expertise, a proactive, detail-oriented mindset, and a high degree of ownership.

Team & Environment

The Pharmacy team supports data pipelines tied to pharmacy claims, rebates, and regulatory reporting. Data flows from external PBM/vendor systems into Azure and is processed for multiple downstream consumers (member services, web applications, actuarial teams, etc.).

The Environment Includes

• Azure (ADF, Databricks, cloud data pipelines)
• Hybrid architecture (cloud + legacy on-prem dependencies)
• Complex, high-volume healthcare data with evolving vendor formats

Role Focus

• Build, maintain, and enhance cloud-based data pipelines
• Ensure data quality, validation, and reliability across pharmacy datasets
• Support evolving ingestion patterns and vendor data changes
• Partner with business and product teams to deliver accurate, timely data

Key Responsibilities

• Design and develop scalable data pipelines using Azure and Databricks
• Ingest, transform, and validate pharmacy and claims-related data
• Perform deep root-cause analysis on data issues (not just symptom fixes)
• Implement data quality checks, validation frameworks, and monitoring
• Adapt pipelines to changing vendor file formats and ingestion cadences
• Collaborate with product owners and stakeholders to translate business requirements into technical solutions
• Troubleshoot production issues and ensure minimal downstream impact
• Contribute to best practices around testing, deployment, and data engineering standards

What This Person Will Be Doing Day-to-Day

• Working within Databricks and Python to process incoming pharmacy data
• Investigating data anomalies and identifying root causes
• Updating pipelines to handle new vendor data structures or formats
• Implementing validation logic and proactive data quality controls
• Collaborating with cross-functional teams on data-related issues
• Supporting production pipelines and resolving incidents when needed

Key Objectives

• Improve overall data quality and reliability across pharmacy systems
• Reduce rework and downstream issues caused by insufficient validation
• Build scalable, maintainable cloud-based data pipelines
• Establish stronger engineering discipline around testing and validation
• Support the organization’s broader cloud migration strategy

Required Qualifications

• Bachelor’s degree in Computer Science, Engineering, Data Science, or related field (or equivalent experience)
• 2+ years of hands-on data engineering experience
• Strong Python experience (core requirement)
• Strong SQL experience (e.g., PySpark SQL, relational databases)
• Experience with Azure Data Platform (Databricks, ADF, or similar)
• Experience building and maintaining ETL/ELT pipelines
• Strong troubleshooting and root-cause analysis skills
• Experience working with large, complex datasets

Preferred Qualifications

• Experience with healthcare, pharmacy, or PBM data
• Familiarity with claims data, rebates, or regulatory datasets
• Experience in hybrid environments (on-prem + cloud)
• Exposure to tools like Jira, ServiceNow, CI/CD pipelines, and Git
• Experience with data validation frameworks and data quality tooling

Key Traits for Success

• High ownership and accountability
• Strong attention to detail and thoroughness in execution
• Curious, analytical mindset with a focus on understanding data deeply
• Ability to think through downstream impacts before implementing changes
• Collaborative, but capable of working independently with minimal oversight
• Avoids "quick fixes" and prioritizes long-term, scalable solutions

Nice to Have

• Experience with Streamlit or similar tools for data exploration/visualization
• Familiarity with health plan terminology (in-network, out-of-network, co-pay, etc.)
• Experience with pharmacy-specific workflows or PBM integrations

Hours / Work Environment

• Monday–Friday, standard business hours
• Hybrid or remote depending on candidate location and eligibility.
• The projected hourly range for this position is $80-$90.
• On-Demand Group (ODG) provides employee benefits which includes healthcare, dental, and vision insurance. ODG is an equal opportunity employer that does not discriminate on the basis of race, color, religion, gender, sexual orientation, age, national origin, disability, or any other characteristic protected by law.