FederalRevenueAnalyst

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 amou