Remote MMIS Application Architect & Data Analyst

Gainwell Technologies LLC; Columbus (OH); Remote; USD 95,000 - 135,000; Full time

Benefits offered by this job

Generous, flexible vacation policy

401(k) employer match

Comprehensive health benefits

Educational assistance

Leadership and technical development &

Job summary

Gainwell Technologies LLC seeks a Technical Analyst/Advisor Application Architect to support MMIS Medicaid environments. You will perform hands-on SQL development, data validation, and system troubleshooting across multiple domains.

The role is remote within the United States, with a pay range of $95,000–$135,000 per year. It includes SDLC participation, collaboration with BAs, CAs, QA, and access to leadership and development academies.

Qualifications

• 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.

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 from baseline to upper environments.
• Analyze, validate, and reconcile interface outputs, extract files, reports, and database feeds.
• Validate X12 EDI transactions for structure, content, and processing outcomes.
• Support Business Analysts by translating functional requirements into technical specifications and solution models.
• Interpret Data Element Dictionaries to understand data structures 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 SIT, UAT, parallel testing, and performance testing by validating data and system behavior.
• Assist with test data setup, environment readiness, validation scripts, and reconciliation activities.
• Mentor junior technical analysts on SQL, data standards, troubleshooting techniques, and documentation best practices.

Skills

SQL

Data analysis

Healthcare systems knowledge

Documentation

Mentoring

Tools

Redgate

Job description

Gainwell Technologies LLC seeks a Technical Analyst/Advisor Application Architect to support MMIS Medicaid environments. You will perform hands-on SQL development, data validation, and system troubleshooting across multiple domains.

The role is remote within the United States, with a pay range of $95,000–$135,000 per year. It includes SDLC participation, collaboration with BAs, CAs, QA, and access to leadership and development academies.