Technical Analyst – MMIS, Medicaid Pharmacy

• 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

• 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