Grant Budget Analyst - CSS

Overview The Grant Budget Analyst is responsible for budgeting, forecasting, and variance analysis of all assigned federal, state, county, city, and foundation awards, as well as fee for service programs, and related administrative departments within the Community Support Services (CSS) region. This position will meet with program leadership on a monthly basis to review budget/forecast trends versus actual, investigate variances, recommend correcting Journal Entries, and update the forecast with budget software, Adaptive Insights. If spending is forecasted to diverge meaningful from the approved budget, the CSS Grant Budget Analyst will work with that contract's program director to create and submit an Administrative Adjustment Request (AAR) or Budget Modification. Finally, the CSS Grant Budget Analyst will annual build and submit budgets for existing contracts and will support the Grant Accounting Director in the submission of new budgets for Requests for Proposals. Learn more about YMCA Community Support Services programs CLICK HERE For more on Employee Perks, click on this link:Employee Benefits | YMCA of San Diego County (ymcasd.org) WORK DESIGNATION Remote (must work within San Diego County Region) Bi-weekly meetings at our North Park location, and frequent in person trainings Please note that the work designation may change based on business needs Responsibilities Develop the annual budgets and update forecasts on a monthly basis for each grant/contract/department assigned Provide meaningful analysis of revenue and expenses including comparisons to prior year, budget and forecast on routine and ad-hoc basis Conduct Ad-hoc analysis and reports to assist all program departments Create, maintain, and improve upon Adaptive and NetSuite financial reports and tracking sheets Disseminate standard Adaptive and NetSuite financial reports to branch leadership Lead quarterly budget meetings with program and branch leadership team Produce and submit monthly contract billing Produce and submit budget modifications to funders when necessary Gather important organization data from multiple sources and compile it into meaningful reports or dashboard for various stakeholders Conduct trainings for program stakeholders to clearly identify; the allocations assumed for staff within the program, the budgeted amounts for each expense category (and what category consists of) and which costs are unallowable Apply compliance standards unique to various Federal, State, and local contracts using OMB Uniform guidance 2 CFR Part 200 Work with Area Director of Finance to estimate accruals for monthly close Perform other administrative tasks as assigned and assist with maintaining proper document storage and auditing Participate in and attend all required staff meetings, trainings, YMCA staff development events and appropriate agency-wide committees TRAVEL REQUIREMENTS Must have access to reliable transportation to travel regularly throughout San Diego County Qualifications Bachelor's degree in Accounting, Finance, Economics, Business or related field or equivalent work experience required, MBA/MPA/CPA a plus Minimum two years accounting, finance, economics, business or related field work experience required Minimum three years grants/contract budgeting and analysis experience preferred Accounting/GAAP knowledge, with Non-Profit experience a plus Knowledge of 2 CFR 200-Uniform Administrative Requirements and Cost Principles a plus Experience with cost allocation principles related to direct/shared costs a plus Advanced knowledge of Microsoft Office Suite (emphasis on Excel, Word and PowerPoint) Working knowledge of NetSuite and Adaptive is strongly preferred JOB COMPETENCIES Must be able to communicate effectively, both internally with staff, peers and management, as well as externally with clients, regulators, and community partners Detail-driven and excellent organizational skills Must have strong analytical skills, specifically in organizational processes, to assess efficiencies and compliance with policies and procedures and be able to recommend and implement changes when necessary Excellent interpersonal, presentation, written and oral communication skills High skill level in organization, planning, communications, and implementation of administrative procedures Strong attention to detail, excellent critical thinking and troubleshooting skills Ability to work in a very diverse setting with people of all backgrounds, culture and orientation Must be able to work independently and as part of a team Ability to establish and maintain working relationships with staff and community partners Demonstrate initiative, resourcefulness and problem solving skills Ability to work with confidential information Must be self-aware, flexible, adaptable and teachable Ability to prioritize work to meet established deadlines Ability to read and analyze contract terms and conditions and apply this knowledge to determine fiscal compliance and operationalize compliance systems Ability to work effectively with others in alignment with the YMCA 4 Core Values Models the 4 Core Values in all aspects of position responsibilities PRE-HIRE CONTINGENCIES: Licensing, state law and our funders require that applicants of critical positions within Community Support Services be fingerprinted, prior to reporting to work, and include subsequent arrest notifications. YMCA will consider qualified applicants with a criminal history pursuant to the San Diego County Fair Chance Ordinance and the California Fair Chance Act. You do not need to disclose your criminal history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if the YMCA is concerned about conviction that is directly related to the job, you will be given the opportunity to explain the circumstances surrounding the conviction, provide mitigating evidence, or challenge the accuracy of the background report. Find out more about the Fair Chance Ordinance by visiting the San Diego County Office of Labor Standards and Enforcement. Pay Range USD $71,621.81 - USD $85,946.17 /Yr. J-18808-Ljbffr