Fiscal Planning & Budget Analyst
Children's Council of San Francisco
Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.
Benefits offered by this job
Job summary
Qualifications
- Bachelor’s degree or 3-5 years of related work experience.
- Advanced experience with statistics and statistical software required.
- Experience with databases is essential.
Responsibilities
- Coordinate reporting with various departments for local and state funders.
- Assist with financial planning and agency budget design.
- Conduct quality assurance tests and maintain data integrity.
Skills
Education
Tools
Job description
Join to apply for the Fiscal Planning & Budget Analyst role at Children's Council of San Francisco
Continue with Google Continue with Google
18 hours ago Be among the first 25 applicants
Join to apply for the Fiscal Planning & Budget Analyst role at Children's Council of San Francisco
Get AI-powered advice on this job and more exclusive features.
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
This range is provided by Children's Council of San Francisco. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
$91,791.00/yr - $97,381.00/yr
Job Title: Fiscal Planning and Budget Analyst
Department/Unit: Finance
Reports To: Associate Director of Fiscal Planning & Analysis
Compensation: $91,791 - $97,381
ABOUT CHILDREN’S COUNCIL: For more than 50 years, Children’s 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 city’s 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.
- 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 government’s 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:
- Bachelor’s 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 preferred.
- 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.
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.
Equal Opportunity & Equity Statement:
Children’s Council is an equal opportunity employer that values diversity 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, diversity, and inclusion. We foster a work environment where our current and future staff feel welcomed without regard to race, color, religion, gender identity, national origin, sex, age, disability, or sexual orientation.
- Seniority levelNot Applicable
- Employment typeFull-time
- Job functionFinance, Analyst, and Accounting/Auditing
- IndustriesNon-profit Organizations
Referrals increase your chances of interviewing at Children's Council of San Francisco by 2x
Continue with Google Continue with Google
Continue with Google Continue with Google
Sunnyvale, CA $125,000 - $183,000 2 weeks ago
San Francisco Bay Area $80,000 - $125,000 3 weeks ago
San Francisco, CA $119,000 - $139,000 15 hours ago
San Francisco, CA $133,000 - $151,000 4 days ago
Mountain View, CA $110,000 - $130,000 2 days ago
San Mateo, CA
$100,000.00
-
$150,000.00
2 weeks ago
Sunnyvale, CA
$60,200.00
-
$128,800.00
4 days ago
Sonoma, CA
$85,000.00
-
$100,000.00
3 weeks ago
San Francisco Bay Area
$92,433.00
-
$144,031.00
4 weeks ago
Petaluma, CA
$84,000.00
-
$102,000.00
1 month ago
Oakland, CA
$98,000.00
-
$146,000.00
2 hours ago
Greenbrae, CA
$110,000.00
-
$140,000.00
3 weeks ago
San Francisco, CA
$84,800.00
-
$127,200.00
2 weeks ago
Menlo Park, CA $95,000 - $105,000 4 weeks ago
San Rafael, CA $60,000 - $90,000 2 weeks ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
