Senior Systems Analyst

Apogee Global RMS • Baltimore, MD

10h

About The Position

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.

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

Nice To Haves

• 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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed