Federal Revenue Analyst

Commonwealth of Massachusetts•Boston, MA

20h

About The Position

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.

Requirements

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.
Applicants must have at least (A) five years of full-time, or equivalent part-time, professional experience in accounting or auditing, of with at least (B) three years must have been in a supervisory, administrative or managerial capacity or (C) any equivalent combination of the required experience and substitutions below.

Nice To Haves

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.

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.

Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.
Explore our Employee Benefits and Rewards!

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume