29 applicants

Company

Kesem · 16 hours ago

Operations Data Coordinator

United States

Full-time

Remote

Entry Level

$55K/yr - $61K/yr

Maximize your interview chances

ChildrenEducation

Insider Connection @Kesem

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Support ongoing staff systems requests via the Systems Needs Queue Request (SNQR) form

Maintain Kesem volunteer application workflows, as well as their connectors to our various systems and processes

Serve as key contributor for Kesem’s program applications and related systems:

Maintain Partner Community (Salesforce) for chapter-level activities, application and registration management, and performance management reporting for Kesem chapters

Lead annual build of volunteer application in Form Assembly; audit process functionality regularly

Lead annual build of Hotline Operator community in Salesforce, including form and case creation process

Review, build, implement, and maintain chapter performance management tools (Chapter Workbooks, Camp Prep Milestones, etc) to fulfill organizational and chapter needs on an annual basis

Create, optimize, and maintain Google Apps Scripts to automate processes, manage data duplication, and facilitate mass updates across platforms

Review, build, implement, and maintain centralized Google Suite tracking tools for Ops Leadership team on an annual basis

Serve as an Operations Team point person for Salesforce database administration needs, including field creation, object manipulation, deduping, merging, creating/maintaining Operations campaigns and designations, and maintaining records

Audit all data entry points for Operations Team constituents annually to ensure data quality standards are met and data entry tools or processes are functioning as expected internally and externally.

Analyze annual program and attendance data, including DEI metrics, to provide a comprehensive readout to the Leadership Team by the end of the fiscal year. Analysis may include insights by chapter, program type, participant demographics, etc.

Perform weekly (at minimum) CampSite child and family data batch uploads into Salesforce via Apsona; reconcile any data discrepancies on a weekly basis

Perform batch upload data entry tasks as needed

Maintain “camper” Engagement Cards, ensuring that current and retroactive FY experiences are captured on engagement cards. Audit Engagement Cards quarterly (minimum) to create any missing Engagement Cards

Prepare quarterly operations data analysis readout, elevating interesting trends and potential data collection opportunities for the upcoming quarter(s).

Refresh key Operations Team Salesforce dashboards and reports at the start of the fiscal year. Audit key Operations Team Salesforce reports and dashboards quarterly to ensure proper functionality and optimize usefulness

Fulfill all chapter-level metrics, reporting, and dashboard requests. Maintain records of chapter historical performance and information in both Salesforce and Google Sheets

Develop cadence and process for reporting out on both unique individuals served and overall experiences by program-type for all Kesem programs

Develop and maintain tracking, reporting, and YOY metrics for Kesem Year Round Service (YRS) support

Develop process and manage interns or other volunteer who support camp attendance collection, document collection, and attendance pace tracking

Serve as general systems liaison for the Operations Team

Develop efficient and timely tracking systems to better support chapter management, and train staff/students how to use performance management tools

Create and maintain Classy fundraising pages and event page templates for Kesem chapters

Update staff and chapter systems-related resource guides to ensure updated and thorough documentation of internal and external processes.

Develop, maintain, and improve tracking systems for chapter management (background checks, training tracking, etc.), exploring automation for improved efficiency

Oversee Operations team forms in Form Assembly (FA). Responsible for on-time deliverables, supporting transitions and developing clear/efficient workflows, including performing follow-up checks to ensure that partial applications are completed by constituents.

Provide Salesforce and data onboarding for Ops team members and collaborate with the FAD team to review and improve systems onboarding for non-Ops Team staff annually.

Create and maintain all Hubspot send lists related to Operations Team. Support email sends and campaigns for Operations Team constituents as requested

Support Operations Coordinator as a backup tier-one representative for the organization (as needed). Support with resolving inquiries, routing/escalating inquiries to the appropriate team member, and documenting for follow-up as necessary.

Serve as Hotline 2.0 Operator for the camp season 24-hour Hotline

Work with National Leadership Summit Project Manager to create application, streamline process, and report out on registrations and openings.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Google Drive SuiteGoogle SheetsExcelSalesforceForm AssemblyGoogle Apps ScriptsHTMLCSSAJAXJavascriptJQueryBackboneAngularEmberBilingual (English/Spanish)