Advisor Technical Analyst – MMIS, Medicaid Pharmacy

📋 Description

• Design, sustain, and enhance intricate SQL queries, views, and stored procedures to facilitate analysis, configuration validation, reporting, and defect resolution.

• Conduct thorough data analysis and root-cause investigations to resolve system and production issues.

• Utilize SQL for data extraction, analysis, reconciliation, and validation across various environments to aid in solution development, testing, and quality assurance.

• Assist in performance tuning efforts by evaluating queries, batch jobs, execution plans, and overall system throughput.

• Execute smoke testing and post-release validation to ensure data integrity and system stability.

• Collaborate with data conversion teams to aid in migration planning, data loading, reconciliation, and validation.

• Verify converted and migrated data for accuracy, completeness, and alignment with business objectives and policy intent.

• Assist and validate configuration synchronizations (e.g., Redgate) from baseline to upper environments (source-to-target).

• Examine, validate, and reconcile interface outputs, extract files, reports, and database feeds.

• Confirm X12 EDI transactions (e.g., 834, 837, 835, 820, 999/277) for structure, content, and processing results.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Information Systems, Health Informatics, or a related field (or equivalent experience).

• Over 10 years of experience as a Technical Analyst, Data Analyst, or Healthcare Systems Analyst.

• Proficient SQL skills, including complex joins, transformations, large dataset analysis, and stored procedures.

• Experience supporting MMIS, Medicaid, or Medicaid Pharmacy systems.

• Strong grasp of healthcare data and Medicaid domains (Member, Provider, Claims, Pharmacy, Finance, Care Management).

• Proven experience in data analysis, troubleshooting, and validating technical outputs.

• Exceptional analytical, documentation, and communication capabilities.

• Familiarity with SDLC and Agile delivery methodologies.

🏝️ Benefits

• Generous, flexible vacation policy.

• Educational assistance.

• Comprehensive health benefits.

• 401(k) employer match.

• Leadership and technical development academies.