Principal Technical Analyst – MMIS, Medicaid Pharmacy
Posted 8hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Principal Technical Analyst supporting MMIS Medicaid Pharmacy systems to improve healthcare outcomes at Gainwell Technologies. Focused on technical analysis, SQL development, and system troubleshooting.
Responsibilities:
- 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 System Integration Testing (SIT), User Acceptance Testing (UAT), parallel testing, and performance testing by validating data and system behavior.
Requirements:
- Bachelor’s degree in Computer Science, Information Systems, Health Informatics, or a related field (or equivalent experience)
- 12+ 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:
- generous, flexible vacation policy
- educational assistance
- comprehensive health benefits
- 401(k) employer match
- leadership and technical development academies



















