Gainwell Technologies · 1 month ago
Advisor Technical Analyst - MMIS / Medicaid Pharmacy
United States
Full-time
Remote
Senior Level, Lead/Staff
$95K/yr - $135K/yr
10+ years expGainwell Technologies is a company focused on improving the health and well-being of vulnerable communities through innovative technology solutions. The Advisor Technical Analyst - MMIS / Medicaid Pharmacy plays a critical role in supporting technical execution for Medicaid Management Information Systems and provides hands-on technical analysis, SQL development, and system troubleshooting across various functional domains.
HealthcareInformation TechnologyHealth Care
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 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
Coordinate and manage reference data files and national standard code sets, investigating data variances as needed
Support Business Analysts by translating functional requirements into technical specifications and solution models
Interpret and leverage Data Element Dictionaries (DEDs) to understand data structures, relationships, and cross-module dependencies
Analyze and document data flows, integration logic, and technical dependencies across internal systems and external interfaces
Perform feasibility analysis on requested features, identifying technical constraints, data impacts, and integration considerations
Participate in design and requirements workshops, providing technical insight to ensure business and technical alignment
Present and explain technical impacts or solution gaps to governance forums such as Architecture Review Boards (ARB) or Change Control Boards (CCB) as needed
Support System Integration Testing (SIT), User Acceptance Testing (UAT), parallel testing, and performance testing by validating data and system behavior
Assist with test data setup, environment readiness, validation scripts, and reconciliation activities
Analyze defects related to data, interfaces, configuration syncs, and performance; implement and validate fixes
Support deployment, cutover activities, hypercare, and post-production issue resolution
Serve as a technical liaison between Business Analysts, Configuration Analysts, developers, QA, conversion teams, and operations
Clearly document and communicate technical findings, risks, root causes, and resolution approaches to stakeholders
Collaborate with configuration teams on data mappings and configuration validation
Mentor junior technical analysts on SQL, data standards, troubleshooting techniques, and documentation best practices
May lead sub-tracks within technical workstreams to ensure timely and high-quality delivery
Qualification
Required
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
Preferred
Hands-on experience with QNXT or similar healthcare claims/encounter management platforms
Familiarity with Data Element Dictionaries (DEDs), interface specifications, and integration design
Experience validating X12 EDI transactions and healthcare interfaces
Experience supporting data conversion, reconciliation, and parallel testing
Exposure to cloud platforms (AWS, Azure, or Google Cloud)
Benefits
Generous, flexible vacation policy
Educational assistance
Comprehensive leadership and technical development academies to help build your skills and capabilities
401(k) employer match
Comprehensive health benefits
Variety of leadership and technical development academies to help build your skills and capabilities
Company
Gainwell Technologies
Gainwell Technologies is a provider of Information Technology & Services. It is a sub-organization of Veritas Capital.
10001+ employees
H1B Sponsorship
Gainwell Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
76%
Represents job field similar to this job
Engineering and Development
Management and Executive
Product Management
Creatives and Design
Customer Service and Support
Accounting and Finance
Sales
Legal and Compliance
Trends of Total Sponsorships
*2026 (26)
2025 (90)
2024 (78)
2023 (56)
2022 (96)
2021 (33)
Funding
Current Stage
Late StageTotal Funding
$1M2023-06-06Grant· $1M
Leadership Team
Paul N. Saleh
Chief Executive Officer and President
Gary Call
Chief Medical Officer
Recent News
2026-04-30
2026-03-31
Company data provided by crunchbase