Mass.gov
Federal Revenue Analyst
Mass.gov, Boston, Massachusetts, us, 02298
The Federal Revenue Analyst supports the EOHHS Federal Revenue Claiming Unit which claims approximately $11B annually in Title XIX and Title XXI federal revenue. Primary responsibilities of the Federal Revenue Analyst will include drawing revenue from the federal government and completing federal Medicaid reports in accordance with applicable regulations, policies, instructions, etc. The Federal Revenue Analyst gathers, assembles, and analyzes data in order to complete federal Medicaid reports which include the CMS 64 and CMS 21, in accordance with policies, procedures, and instructions. The Federal Revenue Analyst will evaluate program expenditures and make recommendations concerning revisions to programs, provide technical assistance and advice to EOHHS/Medicaid fiscal and program staff and other public agencies, and work as part of a team on revenue maximization initiatives.
Duties and Responsibilities :
(these duties are a general summary and not all inclusive) Draw federal funds as needed for both the Title XIX and Title XXI programs by using the database software application (CAMS) and following CMIA regulations to maximize cash availability to the Commonwealth. Includes calculating draw amounts from the Medicaid MMIS system and other sources, submitting appropriate forms to the State Treasurer’s Office, maintaining control logs, and reconciling monthly Cash Deposits (CD’s) to MMARS, the state accounting system. Calculate and reconcile monthly cash collections.
Prepare and manage Excel workbooks that support the completion of quarterly program and/or administrative section of the statement of Medicaid Expenditures (CMS 64 & 21) in accordance with federal statutes and regulation to ensure that all state expenditures are reimbursed at the appropriate levels of federal financial participation.
Prepare all related reconciliations and transfers in relation to the claim.
Complete the quarterly CMS 64 informational schedules for Money Follows the Person (MFP). Work with project office on coordination of reporting of expenditures and draw down and distribution of revenue.
Track payment vouchers (PVs) to ensure they are processed and completed in a timely manner. This includes assisting in the gathering of backup documentation if necessary.
Prepare and calculate quarter end close outs for Medicaid and CHIP.
Preferred Qualifications: Knowledge of accounting principles and practice. Ability to work accurately and precisely with numbers, to follow quality control procedures, and to maintain accurate records. Ability to understand, explain, and apply the laws, regulations, and rules as they apply to federal revenue programs. Ability to analyze raw data to form conclusions and make recommendations. Ability to write concisely to express thoughts clearly and to develop ideas in logical sequence. Ability to prepare written reports and correspondence. Ability to give oral and written instructions in a precise and understandable manner. Ability to deal tactfully with others. Ability to use personal computer software applications including Excel, Word, Access, and the Internet to perform job duties at an intermediate level. Ability to use various data sources and systems. Knowledge of Cognos, MMARS, and Commonwealth Information Warehouse would be a plus. About the Executive Office of Health and Human Services: The Executive Office of Health and Human Services (EOHHS) oversees expenditures of over $22 billion annually. As the largest secretariat, it has approximately 24,000 employees and services almost 2 million people, one in three residents of the Commonwealth. The mission of EOHHS is to provide effective leadership and management in the development and provision of health and human services that promote health and safety, independence, and quality of life for individuals and families, and communities throughout the Commonwealth of Massachusetts. To learn more about EOHHS, please visit:
https://www.mass.gov/orgs/executive-office-of-health-and-human-services
Pre-Offer Process: A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit
http://www.mass.gov/hhs/cori Education, licensure, and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines. Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the
#J-18808-Ljbffr
Duties and Responsibilities :
(these duties are a general summary and not all inclusive) Draw federal funds as needed for both the Title XIX and Title XXI programs by using the database software application (CAMS) and following CMIA regulations to maximize cash availability to the Commonwealth. Includes calculating draw amounts from the Medicaid MMIS system and other sources, submitting appropriate forms to the State Treasurer’s Office, maintaining control logs, and reconciling monthly Cash Deposits (CD’s) to MMARS, the state accounting system. Calculate and reconcile monthly cash collections.
Prepare and manage Excel workbooks that support the completion of quarterly program and/or administrative section of the statement of Medicaid Expenditures (CMS 64 & 21) in accordance with federal statutes and regulation to ensure that all state expenditures are reimbursed at the appropriate levels of federal financial participation.
Prepare all related reconciliations and transfers in relation to the claim.
Complete the quarterly CMS 64 informational schedules for Money Follows the Person (MFP). Work with project office on coordination of reporting of expenditures and draw down and distribution of revenue.
Track payment vouchers (PVs) to ensure they are processed and completed in a timely manner. This includes assisting in the gathering of backup documentation if necessary.
Prepare and calculate quarter end close outs for Medicaid and CHIP.
Preferred Qualifications: Knowledge of accounting principles and practice. Ability to work accurately and precisely with numbers, to follow quality control procedures, and to maintain accurate records. Ability to understand, explain, and apply the laws, regulations, and rules as they apply to federal revenue programs. Ability to analyze raw data to form conclusions and make recommendations. Ability to write concisely to express thoughts clearly and to develop ideas in logical sequence. Ability to prepare written reports and correspondence. Ability to give oral and written instructions in a precise and understandable manner. Ability to deal tactfully with others. Ability to use personal computer software applications including Excel, Word, Access, and the Internet to perform job duties at an intermediate level. Ability to use various data sources and systems. Knowledge of Cognos, MMARS, and Commonwealth Information Warehouse would be a plus. About the Executive Office of Health and Human Services: The Executive Office of Health and Human Services (EOHHS) oversees expenditures of over $22 billion annually. As the largest secretariat, it has approximately 24,000 employees and services almost 2 million people, one in three residents of the Commonwealth. The mission of EOHHS is to provide effective leadership and management in the development and provision of health and human services that promote health and safety, independence, and quality of life for individuals and families, and communities throughout the Commonwealth of Massachusetts. To learn more about EOHHS, please visit:
https://www.mass.gov/orgs/executive-office-of-health-and-human-services
Pre-Offer Process: A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit
http://www.mass.gov/hhs/cori Education, licensure, and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines. Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the
#J-18808-Ljbffr