"Alerted.org

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 reportsin accordance withapplicable regulations, policies, instructions, etc.  The Federal Revenue Analyst gather,assemble, and analyze datain order tocomplete federal Medicaid reports which includethe CMS64 and CMS 21,in accordance withpolicies, procedures, and instructions.  The Federal Revenue Analyst will evaluate program expenditures and make recommendations concerning revisions to programs, provide technicalassistanceand 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,submittingappropriate formsto the State Treasurer’s Office,maintainingcontrol 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 ofquarterlyprogram and/or administrativesection of the statement of Medicaid Expenditures (CMS 64 & 21)in accordance withfederal statutes andregulationto ensure that all state expenditures arereimbursed at theappropriate levelsof federal financial participation. * Prepare all related reconciliations and transfers inrelationsto the claim.  * Complete the quarterly CMS 64 informational schedules for Money Follows the Person (MFP).  Work withprojectoffice on coordination of reporting of expenditures and draw down and distribution of revenue. * Track payment vouchers (PVs)to ensurethey are processed and completedin a timely manner.  This includes assisting in the gathering ofback updocumentation if necessary. * Prepare and calculate quarter end close outs for Medicaid and CHIP. * Prepare Cash Transfers to make payments to public providers andallocaterevenue to different funds and revenue sources. * Act as a liaison and work with various auditors, gathering documentation and responding to their information needs. * Prepare written correspondence including reports, manuals,chartsand graphspertaining toMedicaid revenue claiming and grant award estimates for internal and external informational purposes. * Querying databases and using pivot tables for dataanalysis  tosupport Medicaid claiming and developing reports. * Work on assigned projects withinExecutiveOffice of Health & Human Services as well as with other public providers to help inidentifyingand maximizing new sources of federal revenue. Assistin reviewing federal and state laws, regulations and procedures anddeterminehow to claim maximized revenue. * Prepare andsubmitpreliminary and final GAPP and statutory receivable year end reports for MassHealth which accurately reflect receivables for the year. * Monitor and track federal grant activities. * Other duties as assigned. /REQUIRED QUALIFICATIONS/ * Knowledge of accounting principles and practice.   * Ability to work accurately and precisely with numbers, to follow quality control procedures, and tomaintainaccuraterecords. * 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 towrite conciselyto express thoughts clearly and to develop ideas in logical sequence.   * Ability to prepare written reports and correspondence * Ability to give oral and written instructions inpreciseand understandable manner. * Ability to deal tactfully with others. * Ability to multi-task in a fast-paced environment. * Ability towork independently and self-reliant. * Ability to useCommonwealthprovider laptopcomputer software applications including Excel, Word, Access, and the Internet to perform job dutiesat an intermediate level.  * Ability to useand accessvarious Data sources and systems. * Ability to give oral and written instructions inpreciseand understandable manner. /*PREFERRED QUALIFICATIONS*/ * Knowledge ofCognos,MMARS and Commonwealth Information Warehouse *_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, 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 Commonwealth’s website. If you require assistance with the application/interview process and would like to request an ADA accommodation, please click on the link and complete the Reasonable Accommodation Online Request Form *First consideration will be given to those applicants that apply within the first 14 days.* ** MINIMUM ENTRANCE REQUIREMENTS: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. Substitutions: I. An Associate's degree with a major in accounting, business administration or business management may be substituted for a maximum of one year of the required (A) experience.* II. A Bachelor's degree with a major in accounting, business administration or business management may be substituted for a maximum of two years of the required (A) experience.* III. A Graduate degree with a major in accounting, business administration or business management may be substituted for a maximum of two years of the required (A) experience and one year of the required (B) experience. *Education toward such a degree will be prorated on the basis of the proportion of the requirements actually completed. NOTE: Educational substitutions will only be permitted for a maximum of one year of the required (B) experience. Salary placement is determined by a combination of factors, including the candidate’s years of directly related experience and education, and alignment with our internal compensation structure as set forth by the Human Resources Division’s Hiring Guidelines. For all bargaining unit positions (non-management), compensation is subject to the salary provisions outlined in the applicable collective bargaining agreement and will apply to placement within the appropriate salary range. _*Comprehensive 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. Want the specifics? Explore our Employee Benefits and Rewards! *An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.* The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role. **Job:** **Accounting and Finance* **Organization:** **Exec Office Of Health and Human Services* **Title:** *Federal Revenue Analyst * **Location:** *Massachusetts-Boston-1 Ashburton Place* **Requisition ID:** *250003IU*