CCOF · 21 hours ago
Senior Database and Reporting Specialist
United States
Full-time
Remote
Mid, Senior Level
$80K/yr - $90K/yr
4+ years expCCOF is a nonprofit organization that advances organic agriculture for a healthy world. They are seeking a Senior Database and Reporting Specialist to ensure optimal functionality of Crystal Reports and Intact-derived reports, while also supporting the development of the Salesforce platform.
AgricultureConsultingEducationMarketingNon Profit
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
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
Qualification
Required
4+ years of related experience
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
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
Preferred
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
Benefits
Superb health plans
401(k) program
Generous sick/personal and vacation time
Company
CCOF
CCOF advances organic agriculture for a healthy world.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Kelly Damewood
CEO
Carol Pike Long, Accredited Legal Professional
Handling & Processing Certification Specialist at CCOF
Recent News
Company data provided by crunchbase