Federal Reporting Analyst:

Other Jobs To Apply

No other job posts for this day.

<strong>Job Description</strong><br><br><b>Federal Reporting Analyst:</b><br><br><b>Overview</b><br><br>We are seeking a highly skilled Federal Reporting Analyst with 8+ years of hands-on experience in SQL development, data validation, and reporting within complex enterprise environments. Candidates with Medicaid Management Information System (MMIS) or healthcare reporting experience, especially CMS 64, CMS 372, CMS 416, EFADS, and related 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.<br><br><b>Key Responsibilities:</b><br><br><b>SQL Development & Data Validation</b><br><ul> <li>Develop, optimize, and execute SQL queries to <b>extract, validate, and reconcile data</b> from large-scale database environments.</li> <li>Generate recurring and ad hoc datasets used for <b>CMS64, CMS372, CMS416, and EFADS</b> reporting.</li> <li>Perform <b>data quality checks</b>, root-cause analysis, and error remediation for reporting discrepancies.</li></ul><br><b>Reporting & Issue Resolution</b><br><ul> <li>Analyze issues encountered during report execution and coordinate fixes across configuration, data, and logic layers.</li> <li>Support <b>configuration changes</b> needed to implement new reporting logic.</li> <li>Participate in troubleshooting sessions to resolve defects found during test cycles or encountered in production reporting runs.</li></ul><br><b>Requirements Gathering & Documentation</b><br><ul> <li>Engage with business and technical stakeholders to gather <b>business requirements</b>, <b>functional requirements</b>, and perform <b>gap analysis</b>.</li> <li>Draft comprehensive documentation including <b>mapping documents</b>, data flow diagrams, and process notes for federal reporting.</li> <li>Translate regulatory guidance into actionable reporting logic and data transformation steps.</li></ul><br><b>Testing & QA</b><br><ul> <li>Independently plan and execute <b>unit testing, system testing, and regression testing</b> for reporting deliverables.</li> <li>Currently engaged in testing <b>CMS64 September QE changes</b> and <b>EFADS reports</b>-similar experience is preferred.</li> <li>Validate new and updated reporting logic through SQL-driven test conditions and scenario-based validation.</li></ul><br><b>Collaboration</b><br><ul> <li>Work closely with business analysts, QA teams, developers, and data architects to ensure accuracy and compliance with CMS reporting requirements.</li> <li>Support cross-functional teams during audits, federal submissions, and data calls.</li></ul><br><b>Required Qualifications:</b><br><ul> <li><b>Bachelor's degree</b> in computer science, Information Systems, Engineering, or a related discipline.</li> <li><b>8+ years of experience</b> in SQL development, data analysis, and reporting.</li> <li>Strong SQL proficiency (DDL, DML, performance tuning, stored procedures, analytical functions).</li> <li>Experience validating large datasets and generating enterprise-class reports.</li> <li>Proven ability to diagnose and resolve issues related to configuration, data logic, and report execution.</li> <li>Strong documentation skills to produce BRDs, FRDs, mapping documents, and gap analyses.</li></ul><br><b>Preferred Qualifications:</b><br><ul> <li><b>MMIS experience</b> or strong background in healthcare/Medicaid data.</li> <li>Experience working with <b>CMS federal reporting</b> (CMS 64, CMS 372, CMS 416, EFADS).</li> <li>Familiarity with QE cycles, federal submission processes, and data compliance standards.</li> <li>Experience supporting large-scale reporting transformations or modernization initiatives.</li></ul><br>Pay Transparency Laws in some locations require disclosure of compensation and/or benefits-related 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 base pay, this position, based on business need, may be eligible for a bonus or incentive. In addition, Conduent 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<br><br><strong>About Us</strong><br><br>Through our dedicated associates, Conduent 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 thrive, make a difference and be part of a culture where individuality is noticed and valued every day.<br><br><strong>About the Team</strong><br><br>Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, 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.<br><br>For US applicants: People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent 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@conduent.com. You may also click here to access Conduent's ADAAA Accommodation Policy.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...