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 Youll 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.
Benefits
Why Apogee:
Apogee supporting federal programs where security background directly impacts mission success. Youll work with decisionmakers 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.
Required Experience:
Senior IC
DescriptionApogee 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...
Description
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 Youll 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.
Benefits
Why Apogee:
Apogee supporting federal programs where security background directly impacts mission success. Youll work with decisionmakers 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.