Join Our Team

Our mission is to help our people be better at what they do and be happy while they do it

ETL Manager

About PharmaForce

PharmaForce is a leading provider of innovative pharmacy solutions, specializing in 340B Third Party Administration (TPA) and Pharmacy Benefit Management (PBM) services. We leverage cutting-edge technology and industry expertise to help healthcare providers, payers, and patients navigate the complex landscape of pharmacy management. Our mission is to enhance patient care and access to medications by optimizing pharmacy programs across the spectrum. At PharmaForce, we foster a culture of innovation and collaboration, continuously striving to develop solutions that make healthcare more accessible and affordable for all.

Position Overview

PharmaForce is seeking an experienced ETL Manager to lead a team responsible for end-to-end monitoring, troubleshooting, and optimization of inbound and outbound data pipelines across all PharmaForce platforms. This leader will oversee data ingestion processes for EDI, flat files, switch data, HL7, direct feeds, FTP/SFTP, vendor exchanges, and proprietary data transmission tools.

The ideal candidate brings strong ETL leadership experience, thrives in a fast-paced data environment, and is skilled in root-cause analysis, proactive monitoring, workflow optimization, and cross-functional issue resolution. This role is critical in ensuring the accuracy, reliability, and timeliness of data flowing into PharmaForce systems, supporting our customers’ 340B, Contract Pharmacy, and Split Billing operations.

Key Responsibilities

Leadership & Team Management

  • Lead, mentor, and develop a high-performing ETL & Data Operations team focused on real-time monitoring and resolution of data ingestion issues.
  • Establish team KPIs, SLAs, and performance standards for accuracy, timeliness, and issue resolution.
  • Develop staffing plans, on-call rotations, and escalation procedures to support 24/7 data monitoring coverage.

Data Ingestion & Monitoring Oversight

  • Own the health of all inbound/outbound data feed pipelines across platforms.
  • Monitor customer and PharmaForce FTP locations for pending, delayed, or failed files.
  • Oversee loading and validation of files across stage tables, FGS, and downstream processing layers.
  • Ensure proactive detection of early warning signs, including missing files, reduced volume, naming conventions, data anomalies, or schema changes.

Issue Management & Resolution

  • Lead triage, root-cause investigation, and resolution of data ingestion failures and anomalies.
  • Establish structured daily monitoring routines and automated alerting for load failures, volume variation, and data discrepancies.
  • Publish issue status and trends to leadership and cross-functional partners via Teams Channels (dedicated data ingestion health channel).
  • Partner with internal Product, Engineering, Support, and Client teams to resolve recurring defects and design long-term remediation plans.

Vendor & Partner Collaboration

  • Serve as primary liaison with data vendors, switch partners, wholesalers, and pharmacy chains to resolve integration and feed issues.
  • Govern change control for new file types, naming structures, frequency changes, FHIR/HL7 upgrades, and data exchange enhancements.
  • Ensure vendor SLAs are met for file delivery, quality, and timeliness.

Process, Automation & Continuous Improvement

  • Implement automation, monitoring tools, dashboards, and alerts to reduce manual monitoring effort and increase ingestion accuracy.
  • Maintain documentation for workflows, error codes, SOPs, runbooks, and known issues.
  • Drive continuous improvement initiatives to streamline ETL performance, reduce defects, and enhance early detection capabilities.

Requirements

  • 7+ years of experience managing ETL, Data Operations, or Data Engineering within healthcare, SaaS, PBM, TPA, or pharmacy systems.
  • 3+ years managing technical teams responsible for data ingestion pipelines or ETL operations.
  • Strong hands-on knowledge of healthcare data formats (EDI, HL7, NCPDP, XML/CSV, JSON).
  • Demonstrated experience with SFTP/FTP, ETL tools, and file transmission workflows.
  • Proven ability to manage escalations, lead root-cause investigations, and implement preventative solutions.
  • Excellent communication and stakeholder management skills (technical + non-technical).
  • Proficiency in SQL, Excel; experience with monitoring and visualization tools preferred.

Preferred Qualifications

  • Experience in 340B, pharmacy systems, or claims data environments.
  • Prior ownership of data ingestion health dashboards and automated alerting design.
  • Familiarity with Salesforce Case Management for incident tracking.

What We Offer

At PharmaForce, we value our employees and offer a comprehensive package to support your career growth and well-being:

  • Competitive salary commensurate with experience
  • Comprehensive health, dental, and vision insurance
  • 401(k) plan with company match
  • Collaborative and innovative work environment
  • Remote-friendly work environment

Work Environment

  • Location: Remote
  • Travel: No
  • Schedule: Full-Time

How to Apply

Interested candidates should submit your resume to careers@thepharmaforce.com with the subject line "ETL Manager - [Your Name]"

Equal Opportunity Employer

PharmaForce is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, gender, sexual orientation, national origin, age, disability, or any other protected characteristic.