Technical Analyst – MMIS, Medicaid Pharmacy

Gainwell Technologies

Advisor Technical Analyst managing technical execution for MMIS and Medicaid Pharmacy systems. Collaborates with teams to provide solutions to healthcare challenges.

Posted 6/6/2026full-timeRemote • Pennsylvania, Tennessee • 🇺🇸 United StatesSeniorLead💰 $95,100 - $135,000 per yearWebsite

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLcomplex joinstransformationsstored proceduresdata analysistroubleshootingperformance tuningdata validationsmoke testingX12 EDI transactions

Soft Skills

analytical skillsdocumentation skillscommunication skills

Tools & Technologies

RedgateMMISMedicaid systemsMedicaid Pharmacy systems

Industry Keywords

healthcare dataMedicaidMemberProviderClaimsPharmacyFinanceCare ManagementSDLCAgile

Tech Stack

Tools & technologies

SDLCSQL

About the role

Key responsibilities & impact

Develop, maintain, and optimize complex SQL queries, views, and stored procedures to support analysis, configuration validation, reporting, and defect resolution
Perform in-depth data analysis and root-cause investigations to troubleshoot system and production issues
Use SQL to extract, analyze, reconcile, and validate data across environments to support solutioning, testing, and quality assurance
Support performance tuning activities by analyzing queries, batch jobs, execution plans, and system throughput
Perform smoke testing and post-release validation to confirm data integrity and system stability
Coordinate with data conversion teams to support migration planning, data loads, reconciliation, and validation
Validate converted and migrated data to ensure accuracy, completeness, and alignment with business and policy intent
Support and validate configuration syncs (e.g., Redgate) from baseline to upper environments (source-to-target)
Analyze, validate, and reconcile interface outputs, extract files, reports, and database feeds
Validate X12 EDI transactions (e.g., 834, 837, 835, 820, 999/277) for structure, content, and processing outcomes
Serve as a technical liaison between Business Analysts, Configuration Analysts, developers, QA, conversion teams, and operations

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Information Systems, Health Informatics, or a related field (or equivalent experience)
10+ years of experience as a Technical Analyst, Data Analyst, or Healthcare Systems Analyst
Advanced SQL skills, including complex joins, transformations, large dataset analysis, and stored procedures
Experience supporting MMIS, Medicaid, or Medicaid Pharmacy systems
Strong understanding of healthcare data and Medicaid domains (Member, Provider, Claims, Pharmacy, Finance, Care Management)
Experience with data analysis, troubleshooting, and validating technical outputs
Strong analytical, documentation, and communication skills
Experience working in SDLC and Agile delivery environments

Benefits

Comp & perks

generous, flexible vacation policy
educational assistance
comprehensive health benefits
401(k) employer match
leadership and technical development academies