Budget Analyst

Campbell Union High School District; San Jose (CA); On-site; USD 75,000 - 105,000; Full time

Benefits offered by this job

Health benefits

Job summary

Campbell Union High School District in San Jose, CA seeks a Budget Analyst to manage budgets, perform accounting and auditing work for categorical programs, and prepare complex financial reports for state and federal funding.

The role requires strong knowledge of CALPADS/CBEDS reporting, SQL data handling, and proficiency with MS Excel. The analyst will oversee grants, maintain accounting procedures, and ensure compliance with applicable regulations.

Qualifications

• Knowledge of state/federal data reporting requirements (CALPADS, CBEDS, etc.)
• Proficiency in SQL and data warehousing
• Experience with Microsoft SQL 2012 and Windows Server databases
• Familiarity with cloud-based applications and MS Excel

Responsibilities

• Perform professional accounting, budgeting, and auditing work for categorical programs.
• Draft budget forms and schedules for review and approval.
• Prepare financial statements and monitor budgets for grants and categorical funds.
• Monitor payroll and expenditures for grants; apply internal budget controls.
• Coordinate with auditors to verify financial data and reports.
• Input budgets and track expenditures for LCAP reporting.

Skills

CALPADS reporting

SQL

MS Excel

Data warehousing

Cloud-based apps

Project management

Education

AA degree in accounting/data processing

5+ years financial record keeping experience

Tools

SQL Server

Windows Server

Job description

Calendar And Compensation

• CSEA Salary Schedule Range 7.2, ($74,755.47 - $105,139.46 annually)
• 260 day work calendar, 8 hours per day, 12 months
• Generous health benefit options, including several that require no employee contribution for full family coverage

General Description

This position is pending modest changes to qualifications. Under general direction of the Fiscal Director or Supervisor, the Budget Analyst is responsible for effectively managing budgets. The Analyst will perform professional level accounting work and is responsible for establishing, analyzing, maintaining and auditing financial and statistical records, preparing complex accounting, budgetary and statistical reports and claims, and establishing/revising accounting procedures.

Primary Responsibilities

This position will perform technical, professional accounting duties and requires application of professionally acceptable methods and procedure in addition to strict compliance with State, Federal and local requirements. Responsibilities include, but are not limited to the following:

• Performs a wide range of professional level accounting, financial analysis and auditing work to oversee all categorical programs.
• Prepares complex, recurring and special reports from various source documents.
• Conducts accounting audits, including preparation of written audit reports detailing findings and recommendations for categorical programs.
• Drafts budget preparation forms and schedules for review and approval.
• Performs budget research and prepares projections and estimates as assigned.
• Compiles, analyzes and audits budget data and completes budget allocations.
• Checks and reconciles accounting records to control figures.
• Prepares financial statements and assigns new accounts to chart of accounts.
• Monitors and tracks budgets of special projects, grants and categorical programs, including direct and indirect matching funds.
• Prepares trial balances.
• Sets up grant accounts in collaboration with personnel overseeing the grant.
• Develops detailed midyear and end-of-year accounting reports.
• Monitors payroll and expenditures on all grants and categorical funding.
• Applies internal budgetary controls.
• Analyzes accounting and reporting requirements of state and federally funded projects and grants and established appropriate accounts and accounting procedures.
• Analyzes charges to programs for conformance with categorical budgets and guidelines.
• Completes reports and claims with funding agencies.
• Maintains income and cash flow records relative to categorical funds.
• Advises program managers as to record keeping requirements and budget modifications for categorical programs.
• Compiles information and conducts assigned studies and makes recommendations.
• Meets with auditors to verify and substantiate financial data and reports.
• During auditing or monitoring periods, works as the coordinator responsible for reviewing the completeness and accuracy of each schedule or report.
• Inputs budgets and monitors and tracks expenditures for reporting needs of the Local Control Accountability Plan (LCAP).
• Prepares the Schedule for Categorical Programs, Form CAT in the Standardized Account Code Structure (SACS) software.
• Completes the Consolidated Application required reports in the Consolidated Application and Reporting System (CARS).
• Reviews monthly financial statement and makes adjustments if necessary.
• Beginning each fiscal year prepares opening journal entry by District for Santa Clara County Office of Education (SCCOE).
• Performs other duties/skills related to job description as assigned.

Who We Are

Campbell Union High School District, located in the heart of the Silicon Valley, is a small, close knit district committed to ensuring every student is ready for the future. We strive to be data-informed and focused on results, while promoting humanity, kindness, and personal responsibility. We are proud to provide a supportive environment of collaboration among our staff. We know that high quality teachers, administrators and staff are key to our students' success and are working to retain and recruit passionate and effective talent.

Qualifications

Knowledge of:

• State/federal data reporting requirements for CALPADS, CBEDS, and other reporting systems related to accountability.
• Database management and data warehousing, including demonstrated proficiency in SQL.
• Microsoft Enterprise SQL 2012, Windows Server 2008-2012 database maintenance plans and backup optimization, and SQL user security. Applicant must demonstrate an ability and a willingness to learn these systems if not currently proficient.
• Cloud-based applications.
• Microsoft Office Suite, including demonstrated proficiency in MS Excel.
• Project management principles

Education And Experience

• Associate in Arts degree in accounting and data processing, or the equivalent supplemented by coursework or training in computer operations and data processing practices, Business or Vocational school training in accounting, data processing, or closely related course.
• At least five years of increasingly responsible experience involving financial record keeping, and operation of electronic data processing systems, or technical level accounting experience in which the incumbent has acquired the knowledge and abilities listed above.

Working Conditions

Environment

Office environment

Physical Demands

• Must be able to remain in a stationary position 87.5% of time.
• Constantly operate a computer keyboard, calculator and other office machines.
• Ability to communicate and accurately exchange/provide information.
• Bending at the waist, kneeling or crouching to file materials.

Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position.

The preceding job description has been designed to indicate the general nature and level of work performed by the employee within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and, qualifications required for this position.

It is the policy of Campbell Union High School District (CUHSD) to provide equal opportunity for all individuals in education and employment. District programs and activities shall be free from discrimination, harassment, intimidation and bullying based on actual or perceived characteristics of race or ethnicity, color, ancestry, nationality, national origin, ethnic group identification, age, religion, marital or parental status, physical or mental disability, sex, sexual orientation, gender, gender identity, gender expression, or genetic information, or any other characteristic identified in Education Code 200 or 220, Penal Code 422.55, or Government Code 11135, or based on association with a person or group with one or more of these actual or perceived characteristics (Board Policy 5145.3 and 4030 through 4032).