Financial Data & Systems Analyst

CCOF

$92K — $100K *
US-AnywhereRemote in United States
Education, Government & Non-Profit
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in accounting, finance, business analytics, or a related field.
  • Minimum of 4 years in financial analysis, nonprofit finance, or data analytics.
  • Strong spreadsheet and data analysis skills, including financial modeling.
  • Experience with financial or ERP systems, databases, and reporting platforms.
  • Proficiency in analyzing large data sets and identifying trends.

Responsibilities

  • Prepare financial reports and dashboards for executive leadership and committees.
  • Analyze revenues, expenses, and financial trends to inform strategic decisions.
  • Support the annual budget process with data consolidation and reporting.
  • Develop and maintain data governance standards and documentation.
  • Partner with cross-functional teams to streamline workflows and improve data accuracy.

Benefits

  • Comprehensive health plans.
  • 401(k) savings program.
  • Generous sick/personal and vacation time.
  • Flexible remote working environment.
  • Opportunity to contribute to mission-driven work.
Full Job Description
Position Summary:

We are looking for a Financial Data & Systems Analyst to join our Finance and Accounting team and support our mission-driven work. This role is ideal for someone who combines strong financial and accounting knowledge with data analytics, systems thinking, and a drive to improve how information and processes work across an organization.

The Financial Data & Systems Analyst will work closely with the CFO and cross-functional teams to strengthen financial reporting, budgeting, forecasting, grant tracking, data analytics, and financial systems. Key responsibilities include preparing financial reports and dashboards, analyzing trends and variances, supporting the annual budget process, monitoring grant and restricted-fund activity, improving data quality and reporting, supporting system integrations and automation, and identifying opportunities to streamline workflows and reduce manual processes.

We are looking for someone who is analytical, highly organized, detail-oriented, and comfortable working across financial and operational systems. The ideal candidate can identify problems, ask the right questions, evaluate information, recommend practical solutions, and independently move projects forward. Experience with financial or ERP systems, reporting and data tools, nonprofit or grant accounting, systems integrations, and process improvement is highly valued.

This is a full-time, salaried exempt position reporting to the Chief Financial Officer. This is a United States-based remote position, operating on a Pacific Time Zone work schedule.

Essential Responsibilities:

Lead Financial Reporting, Budgeting, and Strategic Analysis
  • Prepare financial reports, dashboards, budget-to-actual reports, forecasts, models, and analyses for management, executive leadership, committees, and the Board.
  • Analyze revenue, expenses, reserves, cash flow, liquidity, operating results, financial trends, variances, and risks.
  • Support the annual budget process, including templates, data consolidation, assumptions, scenario modeling, cost allocations, and reporting.
  • Prepare schedules that support intercompany reporting, management reporting, grant reporting, and functional expense reporting.
  • Build and maintain dashboards using approved spreadsheet, ERP, CRM, reporting, business intelligence, or data visualization tools.
  • Create visual reports for revenue, expenses, budget-to-actuals, grant spending, cash flow, reserves, AR aging, AP obligations, indirect cost recovery, staffing trends, certification activity, and Foundation activity.
  • Automate recurring reports to reduce manual preparation time and improve consistency.
  • Maintain documentation for dashboards, including data sources, refresh schedules, definitions, and assumptions.
  • Support grant and restricted fund reporting, including budget-to-actual tracking, allowable cost analysis, reimbursement support, cost share/match tracking, indirect cost calculations, and funder reporting schedules.
  • Track grant spending by cost category, activity, funding source, reporting period, and responsible program.
  • Prepare schedules that support grant billing, reimbursement requests, match documentation, audit review, and funder compliance.
  • Support monitoring of grant balances, spending rates, reporting deadlines, and funding restrictions.

Manage Integrated Systems, APIs, and Data Automation
  • Support implementation, testing, reporting, data migration, cleanup, reconciliation, and optimization of financial and operational systems.
  • Help define reporting requirements for dashboards, system reports, workflows, approval processes, custom fields, reporting dimensions, and financial data structures.
  • Work with Finance, IT, consultants, vendors, and department leaders to support integrations between financial, CRM, payroll, certification, grant, reporting, and operational systems.
  • Develop and maintain field mapping documents, data flow documentation, validation rules, exception reports, and reconciliation procedures.
  • Help determine the source of truth for key data elements and support data governance standards across systems.
  • Test system integrations to confirm data transfers are complete, accurate, properly coded, and reconcilable.

Drive Cross Department Workflow Improvement and Operational Efficiency
  • Partner with teams across CCOF to understand workflows, reporting needs, system pain points, data handoffs, and opportunities to streamline, reduce redundancies, and improve data accuracy.
  • Identify manual processes, duplicate data entry, redundant reports, inconsistent coding, unnecessary handoffs, control gaps, and workflow inefficiencies.
  • Recommend and help implement process improvements that reduce manual work, improve accuracy, strengthen accountability, and support internal controls.
  • Create process maps, checklists, training materials, user guides, and documentation to support consistent workflows and system use.

Ensure Data Governance, Internal Controls, and Audit Support
  • Help establish and maintain data governance standards, naming conventions, required fields, coding standards, reporting definitions, and validation processes.
  • Review financial and operational data for completeness, accuracy, consistency, and reporting readiness.
  • Support internal controls related to data entry, approvals, system access, reconciliations, workflow design, and financial reporting.
  • Prepare schedules and documentation for the annual audit, single audit, Form 990, grant reviews, and other compliance needs.
  • Ensure reports are accurate, traceable to source systems, supported by documentation, and useful for decision-making.

Specific Duties:

The Financial Data & System Analyst may create, maintain, or support:
  • CFO dashboards and monthly financial reporting packages.
  • Finance Committee and Board reporting schedules.
  • Budget-to-actual reports by entity, department, program, grant, fund, or functional category.
  • Grant reimbursement reports and funder reporting schedules.
  • Cost share, match, direct costs, and indirect cost tracking schedules.
  • Payroll allocation and productive hours analysis.
  • Operating reserve, liquidity, and cash flow reports.
  • Certification revenue analysis.
  • Foundation giving and restricted fund reports.
  • Cost allocation and functional expense allocation schedules.
  • Financial system data mapping documents.
  • System integration testing checklists.
  • Data validation and exception reports.
  • Workflow maps and process improvement documentation.
  • Audit, single audit, and Form 990 support schedules.
  • Process documentation, training materials, and user guides.
  • Perform other duties and special projects as assigned.
  • Participate in meetings, trainings, system implementation activities, and cross-department projects related to the role.
  • Adapt to changing organizational needs, systems, reporting requirements, and compliance priorities.

Required Qualifications (Knowledge, Skills, and Abilities):
  • Bachelor's degree in accounting, finance, business analytics, data analytics, information systems, economics, public administration, or a related field.
  • Minimum of 4 years of experience in financial analysis, accounting, nonprofit finance, grant reporting, data analytics, ERP reporting, financial systems support, or a related area.
  • Strong spreadsheet and data analysis skills, including pivot tables, lookup formulas, data validation, financial modeling, and data transformation tools.
  • Experience with financial systems, ERP systems, accounting software, databases, reporting platforms, or business intelligence tools.
  • Strong understanding of financial reporting, budgeting, reconciliations, variance analysis, data integrity, and internal controls.
  • Ability to analyze large data sets and identify trends, variances, inconsistencies, exceptions, and process gaps.
  • Strong process improvement mindset with the ability to reduce manual work and improve reporting accuracy.
  • Ability to document processes, data definitions, field mappings, report logic, workflow requirements, and system requirements.
  • Experience supporting ERP implementation, data migration, user acceptance testing, or post-go-live reporting optimization.
  • Experience with field mapping documents, APIs, system integrations, automated data workflows, or middleware tools.
  • Experience building dashboards, custom reports, automated reports, or executive reporting tools.
  • Experience reviewing workflows, identifying redundancies, documenting process improvements, or supporting cross-departmental system changes.
  • Strong attention to detail, organizational skills, and commitment to accuracy.
  • Ability to communicate financial and technical information clearly to finance and non-finance users.
  • Ability to work independently, take initiative, follow through with limited supervision, and manage recurring deadlines.
  • Ability to work collaboratively across departments, functions, leadership levels, and external partners.

Desired Qualifications:
  • Experience in nonprofit accounting, grant accounting, fund accounting, or restricted fund reporting.
  • Familiarity with federal grant requirements, including 2 CFR 200.
  • Experience with NetSuite, Salesforce, QuickBooks Desktop, Power BI, Tableau, SQL, or similar systems.
  • Experience supporting audit schedules, Form 990 reporting, single audit documentation, or funder reporting.
  • Interest in organic agriculture, sustainability, food systems, or mission-driven nonprofit work.

Supervisory Responsibilities or Key Relationships:

This role does not have any supervisory responsibilities.

Physical and Travel Requirements:
  • Ability to work during Pacific Time business hours.
  • Prolonged periods of sitting or standing at a desk and working on a computer.
  • Occasional travel may be required for system implementation activities, trainings, conferences, organizational events, or other business needs (2-5 times per year).
  • Ability to lift or carry standard office materials, such as a laptop, files, or presentation materials, typically up to 20 pounds.

Other duties:

Please note that this job description is not designed to cover or contain a comprehensive list of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Compensation: CCOF takes pride in offering competitive pay and benefits such as superb health plans, 401(k) program, and generous sick/personal and vacation time. The Financial Data & Systems Analyst's starting salary range will be $92,000 - $100,000 and will depend on qualifications and experience.

Hiring Process: Applications will be accepted until the position is filled.Interested applicants, please submit the following documents:
  • Cover letter summarizing your interest in CCOF and the position, and qualifications
  • Current resume
  • List of three professional references

Incomplete applications will not be considered. No phone calls, please. Only short-listed candidates will be contacted. Thank you for your interest.

Similar Jobs

More Jobs at CCOF

More Education, Government & Non-Profit Jobs

  • Deputy Building Official
    $80K — $150K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)
  • Deputy Assessor
    $80K — $150K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)
  • Civil Engineer II
    $80K — $150K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)
  • Accounting Manager
    $80K — $100K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)
  • Manager, Clinical Business Development
    $115K — $120K *
    Columbia University Irving Medical Center
    New York, NY 10032 (New York County)

Find similar Financial Data & Systems Analyst jobs: