Senior Systems Analyst

Apogee Global RMS is seeking an experienced Senior Systems Analyst to support a high-impact healthcare and government technology initiative. This role is ideal for a data-driven professional with strong expertise in SQL, Tableau, data analysis, reporting, and healthcare data environments.

What You'll Be Doing

• 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

• 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
• Experience with reporting databases, data warehouses, data modeling, and ETL processes
• Strong analytical, troubleshooting, and problem-solving abilities
• Excellent communication and stakeholder collaboration skills
• Ability 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.

Why Apogee:

Apogee supporting federal programs where security background directly impacts mission success. You’ll work with decision‑makers, shape architectures that matter, and operate in an environment that values expertise, precision, and clarity.

How to Apply

For any questions (OR) to apply, please contact us at [email protected].