Public Consulting Group

Federal Revenue Analyst

Job Locations US-MA-Boston | US-Home or Remote Position
Posted Date 2 months ago(7/21/2021 3:44 PM)
Job ID
# of Openings
Operation Support
Regular Full-Time
Practice Area
Human Services


About Public Consulting Group

Public Consulting Group, Inc. (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986 and headquartered in Boston, Massachusetts, PCG has over 2,500 professionals in more than 60 offices worldwide. PCG’s Human Services practice helps state, county, and municipal human services agencies to achieve their performance goals in order to better serve populations in need. PCG’s seasoned professionals offer proven solutions to help agencies design programs, services, and systems; increase program revenue; cut costs; and improve regulatory compliance with state and federal regulations. To learn more, visit


Overall Responsibilities

Public Consulting Group LLC is currently seeking a Federal Revenue Analyst in our Child Welfare business line to work on projects focused on federal funding and associated claiming. The Federal Revenue Analyst will be responsible for data analysis, cost allocation methodology and quality assurance related to federal funding available to child welfare agencies, particularly the Title IV-E and Medicaid programs.


The Federal Revenue Analyst will work in a deadline-oriented, fast-paced environment, and will need to be able to work effectively both in teams and independently. The Federal Revenue Analyst will be required to pay close attention to detail in his/her daily work while maintaining adherence to internal and external deadlines. An ideal candidate will be a team player with excellent quantitative abilities, attention to detail, and organizational skills who is interested in supporting the work of state government and/or human service organizations.


Specific Responsibilities:

  • Conduct financial and data analysis of large data sets using Microsoft Excel and Access, including reviews of revenue and statistical reports and eligibility data.
  • Develop and review cost allocation methodologies for child welfare agency administrative claiming
  • Develop cost impact analysis based on federal and state policy changes
  • Support and process quarterly federal claim reports related to the Title IV-E and Medicaid programs
  • Lead additional federal revenue claiming activities, including responding to ad hoc data requests and helping with state and federal audit
  • Assure data integrity, including data extraction, storage, manipulation, processing, and analysis
  • Build and maintain familiarity with federal and state laws, regulations, related to federal revenue for child welfare
  • Apply federal and state laws to ensure compliance
  • Communicate and present trends, findings, and recommendations to clients
  • Maintain positive working relationship with the client, colleagues, and federal partners
  • Foster an attitude of information sharing and open discussion among colleagues


Required Skills:

  • Self-starter who can take initiative with enthusiasm
  • Organized, accurate and detail-oriented with self-initiated problem-solving skills
  • Ability to prioritize responsibilities.
  • Strong proficiency with use of Microsoft Office applications, including Excel- particularly using v-lookups, pivot tables and queries, Word, and Outlook. Strong proficiency with Microsoft Access, SQL, and/or Visual Basic language preferred
  • Detail orientation
  • Critical thinking for problem solving and data analysis
  • Ability to understand and interpret federal and state laws and regulations
  • Excellent communication and client-facing skills, including presentations and facilitating meetings
  • Ability to work independently and within a team, including delegation of tasks to others

Required Experience:

Bachelor’s degree, preferably in quantitative field

2-4 years of relevant work experience



Boston or Remote

Travel may be required based on needs of the project




EEO Statement

Public Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PCG, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Public Consulting Group!

Not ready to apply? Connect with Public Consulting Group for general consideration.