Note: The job is a remote job and is open to candidates in USA. Gainwell Technologies supports healthcare technology solutions that improve health and well-being for vulnerable communities. The Technical Analyst/Advisor Application Architect provides technical analysis, SQL development, data validation, integration support, solution design, testing, performance tuning, and system troubleshooting for MMIS Medicaid and Medicaid Pharmacy environments. The role collaborates with business, configuration, development, QA, conversion, and operations teams throughout the SDLC.
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
- 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
- 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
- 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
Skills
- 5+ 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, Medicaid Pharmacy systems or similar systems utilized in public health or human services
- Strong understanding of healthcare data and Medicaid domains (Member, Provider, Claims, Pharmacy, Finance, Care Management)
- Experience with data analysis, troubleshooting, and validating technical outputs
- Remote Opportunity within the United States
Benefits
- Work flexibility
- Learning and career development opportunities
- Technical credentials and certifications
- Generous, flexible vacation policy
- Educational assistance
- Comprehensive leadership and technical development academies
- Remote opportunity within the United States
- For all salaried, full-time candidates: generous, flexible vacation policy
- For all salaried, full-time candidates: 401(k) employer match
- For all salaried, full-time candidates: comprehensive health benefits
- For all salaried, full-time candidates: educational assistance
Company Overview
Company H1B Sponsorship