Federal Revenue Analyst

Requirements

• Understanding state and federal regulations as they apply to TANF, SNAP, IV-E & SSBG.
• Knowledge and experience in Federal Claiming and Reimbursement systems, including Medicaid, TANF, SNAP, IVE & SSBG.
• High proficiency using software applications including Word, Excel, Access, M, and Data Warehouse to produce written reports.
• Ability to multi-task, meet tight deadlines, and work with minimal or no supervision.
• About the Executive Office of Health and Human Services (EOHHS):

Additional Information

Job Description The Office of Federal Finance and Revenue (OFFR), under the Executive Office of Health and Human Services (EOHHS), is searching for a Federal Revenue Analyst who is analytically driven, collaborative, patient, and diligent. The selected candidate will be supporting the Federal Revenue Claiming Unit for TANF/SNAP, IV-E, and SSBG which claims approximately $850M annually from the following sources of federal funding: Transitional Assistance to Needy Families (TANF), Supplemental Nutrition Assistance to Needy Families Program (SNAP), Foster Care and Adoption Assistance (Title IV-E) and the Social Services Block Grant (SSBG). The Federal Revenue Analyst will be responsible for completing bi-weekly, monthly, and quarterly federal drawdowns and federal claiming reports in accordance with applicable regulations, policies, and procedures. The Federal Revenue Analyst will evaluate program spending and make recommendations concerning revisions to estimates, provide technical assistance and advice to EOHHS fiscal and program staff and other public agencies, and work as part of a team on revenue maximization initiatives. Duties and Responsibilities: Draw federal funds as needed from Federal programs by using various calculations while following federal regulations to maximize cash available to the Commonwealth. This includes calculating draw amounts through MOSAIC (state's accounting system) and other sources, submitting appropriate forms to the State Treasurer's Office, maintaining control logs, and reconciling Cash Deposits (CD's) to MOSAIC. Gather, assemble, and analyze monthly and quarterly data to complete federal reports in accordance with policies, procedures, instructions, and federal laws. Coordinate quarterly federal reports meetings with EOHHS agency staff. Create/update/maintain access queries and Excel reports for quarterly reporting and to provide improved monitoring and analytic review capabilities. Monitor actual program spending to the quarterly budgeted amounts and recommend revising projections and grant awards. Generate, analyze, and monitor the monthly Random Moment Time Study (RMTS) by working closely with the agency staff, HR liaison, and field supervisors. Confer with agencies to resolve data discrepancies and obtain documentation. Work with Single State Auditors and responds to their information needs and requests. Assist in reviewing federal and state laws, regulations, and procedures and determine how to best claim federal revenue and work on assigned projects within EOHHS and with other public providers to help identify and maximize new sources of federal revenue. Respond to inquiries from agency staff, federal staff, auditors, and others regarding federal revenue claiming reports, quarterly grant award estimates, and other requests. Prepare written correspondence, including reports, manuals, charts, and graphs pertaining to federal revenue claiming and grant award estimates for internal and external informational purposes. Required Qualifications: Knowledge of accounting principles and practices, including accounting terminology. Ability to work accurately and precisely with numbers, follow quality control and standard operating procedures and maintain accurate records. Ability to communicate clearly and effectively with a broad range of audiences, both orally and in writing. Capacity to analyze raw data to form conclusions and make recommendations. Ability to understand, explain, and apply the laws, regulations, and rules as they apply to federal revenue programs. Ability to give oral and written instructions in a precise and understandable manner. Experience working collaboratively with teams and dealing tactfully with others. Demonstrated proficiency in personal computer software applications, including Excel, Word, Access, and the Internet, to perform job duties. Knowledge of MOSAIC queries, and Commonwealth Information Warehouse would be very helpful.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at The Commonwealth of Massachusetts? Share your experience