Senior Systems Analyst

About the role

Apogee Global RMS is seeking an experienced Senior Systems Analyst to support a high-impact healthcare and government technology initiative.

Responsibilities

• Design, develop, and maintain complex operational and federally mandated reports
• Build advanced SQL queries, data extracts, dashboards, and analytical reports using PostgreSQL and other database platforms
• Develop reporting solutions utilizing Tableau, Power BI, and related visualization tools
• Analyze business processes and translate requirements into meaningful reporting and dashboard solutions
• Perform data validation, reconciliation, and root cause analysis for healthcare and Medicaid-related transactions
• Support EDI operations, testing, and development teams in analyzing, troubleshooting, and resolving data and transaction issues
• Conduct Medicaid 8001 Flat File validation, MPI/MDM matching analysis, HBX system error analysis, and 1095-A/1095-B validation activities
• Collaborate with cross-functional technical and business stakeholders in a fast-paced environment
• Ensure compliance with security, change management, and PMO policies and procedures

Requirements

• 5+ years of experience performing complex data extraction, analysis, report generation, and dashboard development
• 5+ years of experience developing SQL queries, stored procedures, and custom reporting solutions
• 5+ years of experience building reports and dashboards using Tableau, Power BI, or equivalent tools
• 2+ years of experience translating business requirements into data visualizations and reporting solutions
• Strong analytical, troubleshooting, and problem-solving abilities
• Excellent communication and stakeholder collaboration skills
• Able to manage multiple priorities and meet tight deadlines

Preferred Qualifications

• 8+ years of hands-on SQL and Stored Procedure development experience
• 4+ years of PostgreSQL reporting and query development experience
• 4+ years of Tableau dashboard and advanced reporting experience
• Experience within Healthcare, Health Insurance Marketplace, Medicaid, or Health & Human Services environments
• Strong understanding of data flows, system integrations, and analytical reporting architecture
• Experience with report automation and advanced data visualization techniques
• Knowledge of Python, Java, HTML, CSS, and JavaScript
• Experience with EDI transaction sets including 834, 820, and 999
• Familiarity with Medicaid eligibility, QHP eligibility, and healthcare enrollment transactions
• Knowledge of EDI 834 enrollment processes including adds, terminations, cancellations, and life-event changes

Additional Requirements

• Candidates must be flexible to work overtime when required, including evenings, weekends, holidays, and off-hours support