Advisor Technical Analyst – MMIS, Medicaid Pharmacy
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Advisor Technical Analyst at Gainwell to support MMIS Medicaid Management Information Systems. Contribute technical expertise in SQL, data analysis, and solution design to healthcare systems.
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
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
Benefits:
- generous, flexible vacation policy
- educational assistance
- comprehensive health benefits
- 401(k) employer match
- leadership and technical development academies
Similar Jobs
Technical Support Representative
Technical Support Representative assisting customers with product troubleshooting and warranty claims. Ensuring high-quality customer experience through various support channels.
Senior Technical Support Engineer
Senior Technical Support Engineer focusing on customer escalation and support post-sales. Engaging in technical debugging and collaboration with engineering for enterprise customers.
Principal Technical Analyst – MMIS, Medicaid Pharmacy
Principal Technical Analyst supporting MMIS Medicaid Pharmacy systems to improve healthcare outcomes at Gainwell Technologies. Focused on technical analysis, SQL development, and system troubleshooting.
IT Support Engineer
IT Support Engineer joining IT team to support Microsoft 365, virtualization, and Windows infrastructure. Provide technical support and innovate with AI technologies for IT processes.
Technical Support Engineer – Automotive
Technical Support Engineer resolving complex automotive diagnostics issues. Engaging with dealerships and service networks to maintain operational efficiency and customer satisfaction.
Technical Support Engineer – Cloud, Linux
Technical Support Engineer providing L1/L2 support globally for cloud solutions by resolving customer issues and ensuring software reliability with focus on Linux systems.
Technical Support Engineer, Entry-Level, Cloud / Linux
Entry-Level Technical Support Engineer providing assistance in cloud infrastructure and Linux systems. Collaborating with experienced engineers and supporting customers in Japan and globally.
Support Analyst
Support Analyst responsible for resolving customer issues in IP software for Quartz IP. Engaging with SQL and collaborating with teams to ensure seamless service delivery.
Convention Center Support Technician Intern
Supporting on-site connectivity for convention events as a Convention Center Support Technician Intern. Involves technical support, troubleshooting, and maintaining equipment for a positive experience.
Support Engineer
Software Support Engineer triaging, diagnosing, and resolving technical issues for customers. Acting as a bridge between customers, the commercial team, and product engineering.
Technical Support Officer
Technical Support Officer providing expertise on gas industry inquiries and maintaining safety standards. Collaborating with various stakeholders to enhance gas safety awareness and compliance.
Senior Support Engineer – Enterprise
Client-facing Support Engineer providing technical support for Azure Virtual Desktop and related Microsoft cloud technologies. Collaborating with IT professionals to enhance their Nerdio platform experience.
Senior Manager, Technical Support
Senior Manager of Technical Support overseeing customer success at Hammerspace. Build and lead global support organization while collaborating with engineering and product teams.
Junior Technical Support Referent, Italian
Junior Technical Support Referent handling automotive support requests and ensuring effective solution delivery. Collaborating with a team and managing customer incidents in a remote setting.
WordPress Support Developer
WordPress Support Developer maintaining and improving live client websites for a Canada-based digital marketing agency. Focused on troubleshooting, bug fixes, and ensuring optimal website performance with multiple CMS platforms.
AI Technical Analyst
AI Technical Analyst leading process discovery and designing AI-driven workflows for a global talent solutions company. Engaging in stakeholder interviews and providing technical design consultation and improvements.
Support Engineer
Support Engineer supporting SaaS products for rehabilitation therapy businesses by bridging gaps between engineering and client experience teams. Diagnose issues, debug, and articulate solutions.
Application & Integration Support Engineer
Application and Integration Support Engineer responsible for supporting enterprise applications and system stability. Focused on troubleshooting across Windows and Linux environments for the American Cancer Society.
Business Unit Application Support Analyst – Salesforce Admin
Business Unit Application Support Analyst Lead providing support to corporate and business line applications at TD. Leading teams and developing customized reports while maintaining confidentiality and relationships with partners.
BSA/KYC Support Analyst
BSA/KYC Support Analyst responsible for KYC forms accuracy and compliance evaluations. Assisting with detailed research, tracking accounts linked to suspicious activity reports, and ensuring BSA standards are met.