Fiscal Planning and Budget Analyst

Job DescriptionJob DescriptionSalary: $91,791 - $97,381

Job Title: Fiscal Planning and Budget Analyst

Department/Unit: Finance

Reports To: Associate Director of Fiscal Planning & Analysis

FLSA Status/ Hours Non-Exempt/Union- 37.5 hours per week

Level: Level 11

Compensation: $91,791 - $97,381

ABOUT CHILDRENS COUNCIL: For more than 50 years, Childrens Council has been the heart of child care and early education in San Francisco, advancing the belief that high-quality child care can transform lives and communities. Our more than 150 team members help families navigate their child care and preschool options and secure financial assistance to pay for it. We provide home-based child care businesses with the training and resources to succeed. Through a wide range of free programs and workshops, we support parents and caregivers as they build child development skills. As the citys second largest nonprofit contractor, with an annual budget of over $240 million, we are a major stakeholder in the child care system. We educate the public and advocate for increased investment in early education at the local and state level. If you are a child care champion, we want you on our team.

POSITION SUMMARY:

The Fiscal Planning and Budget Analyst reports directly to the Associate Director of Fiscal Planning & Analysis. This position is responsible for supporting the Associate Director of Fiscal Planning & Analysis in utilizing agency databases to maintain data integrity, responding to queries, and producing reports for analysis, management reporting, and funder requirements. S/he/they will also be responsible for ensuring data integrity and maintenance functions. This position is also responsible for assisting with the production of data and projection reports about Child Care Subsidies, the Child Care Resource & Referral functions, and other agency programs. The Fiscal Planning and Budget Analyst will assist the Associate Director of Fiscal Planning & Analysis in financial planning, budgeting, forecasting, policy and procedure implementation, strategic and financial analysis, modeling, and reporting efforts, to ensure efficient financial operations, policies/procedures that support the functional infrastructure, and tracking program expenses and reporting on organizational finances.

RESPONSIBILITIES:

Data Integrity and Reporting

• Coordinate with the Compliance and Program Support (CAPS) Department, the Research, Data and Evaluation (RDE) Department, and the Information Technology (IT) Department to produce monthly, quarterly, and annual usage, attendance, billing, and expenditure reports for local and state funders.
• Produce ad hoc statistical and programmatic reports using SQL Server at the request of agency department managers, funders, and government agencies.
• Establish and maintain data integrity for multiple agency-customized and commercial database computer applications.
• Prepare and maintain spreadsheets and databases to generate data tables and charts for reports. Input data as needed and/or retrieve data from existing databases or remote websites.
• Develop and conduct quality assurance tests using software such as CC4, MIP, ZenDesk, and other finance related software to ensure data integrity within CCSF databases. Work constructively with staff at all levels to identify and correct data errors, thereby improving data integrity.
• Prepare and submit monthly caseload reports for California Department of Social Services (CDSS) requirements.
• Participate in periodic monthly meetings relating to data reporting and database updates as assigned.

Budgeting and Projections

• Assist the Associate Director of Fiscal Planning and Analysis in creating child care projections that utilize fiscal and program data for enrollment planning and budgeting.
• Collaborate with program managers to develop strategies that streamline enrollment processes and assist them in identifying and analyzing programmatic data to evaluate program efficacy, needs, and trends.
• Monitor, record, analyze, and report payment activities and authorizations for provider programs, ensuring monthly reconciliations of program payments and adjustments are maintained.
• Assist the Associate Director of Fiscal Planning and Analysis in planning, evaluating, and designing agency budgets, grant budgets, and contract budgets, utilizing various financial and budget models and systems to communicate financial performance and ensure regulatory compliance.
• Perform ongoing budget-to-actual analytics leading up to and during the monthly close process, maintaining detailed knowledge at the transaction level of operating expenses and other operating revenue accounts.
• Process grants and contract activities, including, but not limited to, expense review and tagging, voucher submission review and reconciliation, invoice creation and payment posting, and communicating directly with grant and contract managers.
• Support, coordinate, and collaborate with various City and State programs and departments to submit pre-approval requests to funders.
• Conduct financial reporting, and use existing tools to assist in creating dashboards, and engage in related projects and initiatives.
• Summarize and consolidate data into easily understood end-user formatted reports.
• Attend meetings as needed to provide ad hoc analyses and address issues, offering support as necessary.

Financial Support

• Supports coordination with subsidy and fiscal intermediary staff to establish payment timelines and process checks, ensuring that payments to child care providers are both accurate and timely.
• Perform accurate reconciliations, provide supporting documentation, and conduct timely analyses of provider stipends, incentives, subsidies, and payments.
• Provide ad hoc support to the Associate Director of Fiscal Planning and Analysis, during the month-end accounting close and annual audit process.
• Maintain up-to-date knowledge of funder regulations, policies, and guidelines, including compliance with the federal governments Title 2, Part 200 of the Code of Federal Regulations, Child Care Fiscal Reporting and Reimbursement Procedures for Child Care and Development Contracts, and the City and County of San Francisco's Office of the Controller Guidelines for Cost Categorization for Nonprofit Grants.
• Other duties as assigned by the Associate Director of Fiscal Planning and Analysis
  in collaboration with the Senior Director of Finance & Accounting depending on capacity and capability.

Software Support

• Provide ongoing user support for accounting, accounts payable, database management, and child care subsidy software programs.
• Test financial/budgeting software upgrades and assist with planning and implementation.
• Learn the customized internal software programs and assist with the agency's database applications and data entry methods. Make suggestions for improvements in data entry procedures, as well as for identifying and correcting data errors, and recommend strategies to prevent these issues in the future.

QUALIFICATIONS:

• Bachelors Degree in Statistical Analysis, Accounting, or Business Administration, or three to five years of related work experience.
• Advanced experience with statistics, statistical analysis and quantitative methods, and statistical software (Excel statistical analysis functions) required.
• Experience with databases is required, including strong knowledge of the MS Office Suite, Power BI, MIP Fund Accounting or similar fund accounting software, SQL Server Enterprise Manager or similar Oracle products. Some familiarity with F9 financial reporting, are Control 4 (CC4) Payment application, and Salesforce is .
• Technologically savvy, with experience working with IT staff to develop and implement new processes and systems that increase efficiency and effectiveness.
• Ability to perform in-depth, multi-faceted analyses.
• Excellent written and verbal communication skills and related writing experience.

PHYSICAL REQUIREMENTS:

• Mental acuity to perform the essential functions of this position in an accurate and timely fashion.
• Dexterity to use office equipment; the ability to sit and work at a desk for extended periods of time.
• Ability to speak, hear, and understand speech at normal room levels.
• Physical agility to bend, stoop, walk, climb four flights of stairs if required.

Hybrid Work

We have adopted a hybrid working model and currently require employees to be present in the officeat least3 days per week, with the option to work 2 days per week remotely. Applicants should be comfortable with both the remote and in office scenarios.

COVID Policies

All staff are required to be fully vaccinated against COVID-19 (barring application for medical or exemptions). Wearing masks in the office is optional for our staff.

Benefits, and Employee Perks

We offer a family-friendly workplace, plus competitive pay, and industry leading benefits package that includes:
Generous Medical coverage for staff, including paid medical plan deductibles, copays and out-of-pocket maximums.
Dental, Vision, Chiropractic & Acupuncture, Life, LTD and AD&D coverage.
Voluntary benefits that include Supplement Life, Accident, Critical Illness, and Pet Insurance.
401(k) retirement plan with a generous employer match.
Pre-tax Flexible Spending Accounts, Health Savings Account and Commuter Benefit programs.
Generous paid time off package, including 14 paid holidays + a floating holiday for your Birthday.
Ongoing training and professional development for all staff.
Tuition Reimbursement.

Equal Opportunity & Equity Statement:

Childrens Council is an equal opportunity employer that values as central to our work serving the San Francisco community. We comply with all applicable state and local laws governing nondiscrimination in employment. Our practices are in alignment with our commitment to workplace equity, , and . We foster a work environment where our current and future staff feel welcomed without regard to , , , , origin, , , , or .