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 Salesforce administration. Basic experience working within Salesforce, including updating fields, building or editing formulas, assisting with report and dashboard adjustments, and testing new features. Understanding of Salesforce data structures, workflow concepts, and the importance of accurate documentation to support system integrity and cross-team collaboration.

Interpersonal & Professional Skills

• Commitment to anti-discrimination and employee well-being.  Ability to collaborate effectively with individuals from different backgrounds, demographics, and communication styles to foster a respectful, inclusive, and professional work environment.
• Highly organized, motivated, and detail oriented. Understands how to prioritize competing needs and tasks without compromising quality. Reliably completes assignments within established deadlines. Proactive, self-directed and driven to achieve goals. Attention to detail: Notices and fixes errors that others might overlook. Acknowledges mistakes and turns them into learning opportunities. Has a track record of leaving things better than they found them.
• Communication skills. Professional written and verbal communication. Writes clearly and adapts communication to suit various audiences, providing relevant context and asking thoughtful questions to understand others’ perspectives and foster engaging, effective interactions. Organizes and shares information effectively. Receives and applies constructive feedback effectively. 
• Team Collaboration. Actively contributes to team success by completing tasks, meeting goals, and supporting project outcomes. Demonstrates respectful collaboration by actively listening to colleagues, valuing different ideas, and seeking opportunities to improve processes. Understands that their team’s success is their own success, and they share responsibility when their team experiences difficulties along the way.
• Multi-scope project management. Leads multiple moderately complex campaigns and projects that require coordination with internal and external stakeholders. Experience planning, coordinating, executing and finishing complex projects. Ability to delegate and prioritize tasks, manage resources, analyze problems, report progress, and evaluate project performance to ensure successful outcomes.
• Critical Thinking and Problem-Solving skills. Proactively leads process improvements. Independently navigates unfamiliar situations, leveraging available resources to overcome challenges, and identify effective solutions. Demonstrates self-awareness by recognizing when support is needed and appropriately seeking guidance or resources.
• Proficiency in computer skills including Microsoft Outlook, Teams, Word, Excel, and database programs. Effectively manages emails, creates professional documents, spreadsheets, and maintains accurate database records.

Desired Qualifications:

• Knowledge and commitment to the principles of anti-discrimination. A willingness to engage in discussions about race, ethnicity, sexual orientation, class, ability, or gender and the ways our identities shape our workplace experiences.
• Completion of a recognized SQL certification (e.g., Microsoft SQL, Oracle SQL, or IBM SQL certification) is preferred but not required.
• Experience working remotely with in-office and remote teams.
• Proficiency with code versioning practices to ensure best change-management practices.

Supervisory Responsibilities or Key Relationships:

• This role does not have any supervisory responsibilities.

Physical and Travel Requirements:

• Regular 8‑hour workday scheduled within the Pacific Time Zone.
• Prolonged periods sitting or standing at a desk and working on a computer

Other duties:

Please note 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 Senior Database and Reporting Specialist’s starting salary range will be $80,000 – $90,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.

CCOF is an equal opportunity employer. We prioritize community, well-being, and belonging, ensuring that everyone has a chance to contribute, develop and succeed. We encourage people with various talents and experience to apply.

Community-building is a core value at CCOF. We are passionate about cultivating and sustaining a work environment where all employees can thrive. We believe every member of our team enriches our culture by exposing us to a broad range of ways to understand and engage with the world.

 

 

 

.