Job Title: SQL Analyst
Duration: 6+ Months
Location: Remote
Job Summary:
We are seeking an experienced SQL Analyst with strong PBM (Pharmacy Benefit Management) Eligibility domain expertise. This role requires hands-on SQL development, manual eligibility file validation, and detailed data issue analysis. The analyst will work closely with the Customer EDI Team and other cross-functional teams to ensure accuracy, completeness, and compliance of eligibility data prior to ingestion into downstream systems.
Key Responsibilities
Develop, optimize, and execute complex SQL queries to validate PBM eligibility data
Perform manual validation of eligibility files prior to loading into downstream systems
Analyze data discrepancies, eligibility errors, and file-level issues
Document findings clearly and report issues to the Customer EDI Team in a timely manner
Support root cause analysis for eligibility failures, mismatches, and data quality issues
Ensure eligibility data accuracy, completeness, and compliance with PBM requirements
Collaborate with EDI, operations, and technical teams to resolve data-related issues
Assist with ongoing data validation and reconciliation efforts
Required Skills & Qualifications
Strong hands-on experience with SQL (complex joins, subqueries, aggregations, validations)
Proven experience in PBM Eligibility processing and validation
Solid understanding of PBM eligibility file formats and data flows
Experience with manual data validation and reconciliation
Strong analytical and problem-solving skills
Ability to clearly communicate data issues to both technical and business stakeholders