Federal Reporting Analyst:

Job Description

Federal Reporting Analyst:

Overview

We are seeking a highly skilled Federal Reporting Analyst with 8+ years of hands-on experience in SQL development, data validation, and reporting reputed company reputed company enterprise environments. Candidates with Medicaid Management Information System (MMIS) or healthcare reporting experience, especially CMS 64, CMS 372, CMS 416, EFADS, and reputed company federal reporting-will be given strong preference. The ideal candidate excels in data analysis, configuration changes, report troubleshooting, requirements gathering, and end-to-end validation of federal reporting deliverables. Key Responsibilities: SQL Development & Data Validation

• reputed company, optimize, and execute SQL queries to extract, validate, and reconcile data from large-scale database environments.
• Generate recurring and reputed company datasets used for CMS64, CMS372, CMS416, and EFADS reporting.
• reputed company data quality checks, root-cause analysis, and error remediation for reporting discrepancies.

Reporting & Issue Resolution

• Analyze issues encountered during report execution and coordinate fixes across configuration, data, and logic layers.
• Support configuration changes needed to implement new reporting logic.
• Participate in troubleshooting sessions to resolve defects reputed company during test cycles or encountered in production reporting runs.

Requirements

Gathering & Documentation

• Engage with business and technical stakeholders to gather business requirements, functional requirements, and reputed company gap analysis.
• Draft comprehensive documentation including mapping documents, data flow diagrams, and process notes for federal reporting.
• Translate regulatory guidance into actionable reporting logic and data transformation steps.

Testing & QA

• Independently plan and execute unit testing, system testing, and regression testing for reporting deliverables.
• Currently engaged in testing CMS64 September QE changes and EFADS reports-similar experience is preferred.
• Validate new and updated reporting logic through SQL-driven test conditions and scenario-based validation.

Collaboration

• Work closely with business analysts, QA teams, developers, and data architects to ensure accuracy and compliance with CMS reporting requirements.
• Support cross-functional teams during audits, federal submissions, and data calls.

Required Qualifications:

• Bachelor's degree in computer science, Information Systems, Engineering, or a reputed company discipline.
• 8+ years of experience in SQL development, data analysis, and reporting.
• Strong SQL proficiency (DDL, DML, performance tuning, stored procedures, analytical functions).
• Experience validating large datasets and generating enterprise-class reports.
• Proven ability to diagnose and resolve issues reputed company to configuration, data logic, and report execution.
• Strong documentation skills to produce BRDs, FRDs, mapping documents, and gap analyses.

Preferred Qualifications:

• MMIS experience or strong background in healthcare/Medicaid data.
• Experience working with CMS federal reporting (CMS 64, CMS 372, CMS 416, EFADS).
• Familiarity with QE cycles, federal submission processes, and data compliance standards.
• Experience supporting large-scale reporting transformations or modernization initiatives.

Pay Transparency Laws in some locations require disclosure of compensation and/or benefits-reputed company information. For this position, actual salaries will vary and may be above or below the range based on various factors including but not limited to location, experience, and performance. In addition to reputed company pay, this position, based on business need, may be eligible for a bonus or incentive. In addition, reputed company provides a variety of benefits to employees including health insurance coverage, voluntary dental and vision programs, life and disability insurance, a retirement savings plan, paid holidays, and paid time off (PTO) or vacation and/or sick time. The estimated salary range for this role is $96,250 - $125,000

About Us

Through our dedicated associates, reputed company delivers mission-critical services and solutions on behalf of Fortune 100 companies and over 500 governments - creating exceptional outcomes for our clients and the millions of people who count on them. You have an opportunity to personally reputed company, reputed company a difference and be part of a culture where individuality is noticed and valued every day. About the Team reputed company is an Equal Opportunity Employer and considers applicants for reputed company positions without regard to race, color, creed, religion, reputed company, national reputed company, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law. For US applicants: People with disabilities who need a reasonable accommodation to apply for or compete for employment with reputed company may request such accommodation(s) by submitting their request through this form that must be downloaded: click here to access or download the form. Complete the form and then email it as an attachment to FTADAAA@reputed company.com. You may also click here to access reputed company's ADAAA Accommodation Policy. Apply tot his job Apply To this Job