### - We are looking for a senior systems analyst with 5 years of experience in complex data extraction, analysis, reporting, and dashboard development. - We require 5 years of hands-on SQL experience, including writing queries, stored procedures, and custom reporting solutions. - We need 5 years of experience creating reports and dashboards in Tableau, Power BI, or similar visualization platforms. - We prefer at least 2 years of experience converting business needs into data visualizations and reporting outputs. - We are looking for experience with reporting databases, data warehouses, data modeling, and ETL workflows. - We value strong analytical, troubleshooting, and problem-solving skills. - We expect excellent communication and stakeholder collaboration abilities. - We require the ability to juggle multiple priorities and deliver under tight deadlines. - Preferred experience includes 8 years of SQL and stored procedure development. - Preferred experience includes 4 years of PostgreSQL query and reporting development. - Preferred experience includes 4 years of Tableau dashboard and advanced reporting work. - Experience in healthcare, health insurance marketplace, Medicaid, or Health & Human Services environments is preferred. - A strong understanding of data flows, system integrations, and reporting architecture is preferred. - Experience with report automation and advanced data visualization techniques is preferred. - Knowledge of Python, Java, HTML, CSS, and JavaScript is preferred. - Experience with EDI transaction sets such as 834, 820, and 999 is preferred. - Familiarity with Medicaid eligibility, QHP eligibility, and healthcare enrollment transactions is preferred. - Knowledge of EDI 834 enrollment processes, including adds, terminations, cancellations, and life-event changes, is preferred. - We require flexibility to work overtime when needed, including evenings, weekends, holidays, and off-hours support.
Responsibilities:
- ----------------
- We design, develop, and maintain complex operational and federally mandated reports. - We build advanced SQL queries, data extracts, dashboards, and analytical reports using PostgreSQL and other database platforms. - We create reporting solutions in Tableau, Power BI, and related visualization tools. - We analyze business processes and convert requirements into effective reporting and dashboard solutions. - We perform data validation, reconciliation, and root cause analysis for healthcare and Medicaid transaction data. - We support EDI operations, testing, and development teams in identifying, troubleshooting, and resolving data and transaction issues. - We conduct Medicaid 8001 Flat File validation, MPI/MDM matching analysis, HBX system error analysis, and 1095-A/1095-B validation work. - We collaborate with cross-functional technical and business stakeholders in a fast-paced environment. - We ensure adherence to security, change management, and PMO policies and procedures.
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Company:
- -------
We are Apogee Global RMS, supporting high-impact healthcare and government technology initiatives where security and mission success matter. This senior systems analyst role offers the opportunity to work with decision makers, influence meaningful architecture, and contribute in an environment that values expertise, precision, and clarity.
- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------