Senior Database and Reporting Specialist

Who we are: CCOF advances organic agriculture for a healthy world. We advocate on behalf of our members for organic policies, support the growth of organic through education and grants, and provide organic certification that is personal and accessible.

CCOF is a nonprofit organization governed by the people who grow and make our food. Founded in California 53 years ago, our roots now span the breadth of North America, and our presence is internationally recognized. We are supported by an organic family of farmers, ranchers, processors, retailers, consumers, and policymakers. Together, we work to realize a future where organic is the norm.

Position Summary: 

CCOF is expanding its Information Technology team! We are looking for a Senior Database and Reporting Specialist who will serve as the first point of contact for our IT SQL reporting needs. In this role, you’ll help ensure Crystal Reports and Intact-derived reports function optimally across the organization, while also supporting the continued development of the Salesforce platform.

Working closely with the DevOps Manager, this role helps maintain reliable data workflows, ensures accurate technical documentation, and contributes to ongoing improvements across reporting and database processes.

If you have experience with SQL and Crystal Reports, exposure to Salesforce platform administration, and a passion for providing excellent service to a mission-driven team, we encourage you to apply and be part of our impactful work at CCOF.

This is a full-time, salary non-exempt position that reports to the DevOps Manager. This is a United States-based remote position, operating on a Pacific Time Zone work schedule.

Essential Responsibilities:

• Serve as the first responder on Crystal Reports tickets within the IT ticketing system
• Develop and document Crystal Reports
• Co-develop and document SQL stored procedures
• Support co-development and documentation of Salesforce features

Specific duties

• Triage Crystal Reports tickets within the IT Helpdesk System, including clarifying scope, validating issue details, determining priority, and communicating with end users to gather additional information as needed.
• Take full ownership of assigned tickets and ensure issues are tracked, escalated when appropriate, and resolved successfully within expected service timelines.
• Contribute to the development and maintenance of Crystal Reports including formatting documents, creating new reports based on the organization requirements, updating existing reports as needed, and proofreading and annotating inherited formulas.
• Ensure all Crystal Reports work is documented clearly to support version control, knowledge transfer, and long-term usability.
• Collaborate with the DevOps Manager to draft and update SQL stored procedures, supporting data workflows and reporting needs. Assist in refining logic, troubleshooting errors, and optimizing performance.
• Implement annotation of SQL stored procedures referenced by Crystal Reports and Intact and as needed for database reporting.
• Support Salesforce development in partnership with the DevOps Manager, contributing to feature development, testing, and documentation. Assist with foundational Salesforce administration tasks such as field updates, formula creation, report adjustments, and data validation.
• Ensure that all new or updated Salesforce features include clear functional and technical documentation.

Required Qualifications:

• 4+ years of related experience

Knowledge & Technical Skills

• Foundational SQL knowledge and demonstrated experience. Working understanding of SQL concepts, including querying, joins, data filtering, and basic troubleshooting. Ability to read, interpret, and collaboratively develop SQL stored procedures. Familiarity with optimizing queries and documenting logic to support maintainability and efficient data workflows.
• Experience with Coding and Formatting in Crystal Reports. Proficiency in creating and modifying Crystal Reports, including writing and editing report formulas, applying data formatting, structuring report layouts, and integrating data sources. Ability to troubleshoot report errors, validate report accuracy, and maintain clear documentation of report logic, parameters, and version history.
• Exposure to Sa