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
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
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.
BenefitsHow to ApplyFor any questions (OR) to apply, please contact us at .
