CAI (Cicatelli Associates Inc) · 5 hours ago
Nonprofit Data & Quality Manager
CAI (Cicatelli Associates Inc) is a nonprofit organization focused on research and evaluation. They are seeking a Data Systems & Quality Manager to oversee the management and promotion of their Quickbase platform, ensuring high-quality data tracking and analytics across various projects.
Responsibilities
Oversee CAI’s Quickbase system to align with strategic objectives and continuous quality improvement
Understand and maintain CAI’s overarching Quickbase Architecture and how it fits into CAI’s Tech Stack overall
Maintain existing connections between CAI’s Learning Management System (LearningStream), CAI’s E-Learning Platform (Moodle), Formstack and Quickbase and between Quickbase project application and the CAI-Wide Dashboards application through Table-to-Table Imports and Pipelines
Build new connections between Quickbase applications with Table-to-Table Imports and Pipelines as needed
Meet with project staff to understand data, reporting, and tracking needs in relation to Quickbase app
Advise project teams, identify solutions and customize CAI’s standard project app template for unique project needs, while aligning with organizational-wide data strategy
Build relational tables to connect data within an app (ex: parent/child relationship, many-to-many relationships)
Develop intuitive reports in Quickbase to display project data (including training and technical assistance data) for project teams and funders
Create dashboards to display and filter multiple reports
Train staff on project app’s Quickbase functionality (ex: demonstrate reporting functionality, explain Learning Stream to Quickbase connection)
Migrate project data from past data sources, including Excel and Quickbase, to new project apps
Spearhead responding to and triaging of Quickbase requests
Common requests include new functionality (fields, forms, reports, and tables), troubleshooting, access, and technical support
Oversee onboarding of new staff to Quickbase (e.g., ensure access to Quickbase accounts, direct to orientation modules, optionally meet with staff to answer questions)
Pull and summarize data for project-level insights and decision-making (ex: synthesizing trainer data)
Build and revise reports and Dashboards for decision support, project performance tracking, and/or funder requests
Train staff as-needed on project-level Quickbase functionality (ex: bulk uploading, addressing inconsistencies in TA logs)
Regularly learn about and apply new features of Quickbase to optimize our work at CAI (including surveys, reporting, and data dashboards)
Archive training data (events, registrants, attendance, and evaluations), technical assistance data, products, project administration activities, and Research & Evaluation activities for projects that have ended, ensuring long-term accessibility and usability of legacy data
Update project profiles in the CAI Wide application, including a project summary, listing key staff involved, and logging Project Impacts
Interview project staff, including Project Administrators, Project Directors, Project Managers, and Project Coordinators, about data processes and where data is stored, including during staff offboarding
Identify gaps in project data completeness or quality with staff and co-develop plans to address the gaps
Search old databases including SharePoint, Neon, Drupal, and paper resources to locate data
Clean data in Excel to ensure data quality and format data to be bulk uploaded to Quickbase
Conduct manual data entry as needed
Regularly conduct descriptive data analysis in Excel, Word, and Quickbase and implement improvements to project databases
Complete final Quickbase App Closeout steps (e.g., turn off pipelines, rename application, change permissions to view-only)
Ensure all data regularly flows from Project Applications to the CAI-Wide Dashboard Application
Build and maintain functionality for Core Resources including Development, Communications, Continuing Education, Research & Evaluation, and other Core Resources as requested
Manage overarching Quickbase functionality including incoming requests from the website’s 'Contact Us' form, room rental requests, fee for services, and finance reports
Perform other duties as necessary/assigned
Qualification
Required
Experience with Quickbase (QB) development is highly desirable; however, candidates without direct Quickbase experience will be considered if they demonstrate strong aptitude with similar platforms and a clear eagerness to learn Quickbase
Translating user needs to technical specifications
App building based on a template, including creating custom tables and fields
Designing intuitive, user-friendly forms to support accurate data entry
Creating useful, accessible reports to support operational and analytical needs
Developing custom dashboards to visualize key data and metrics
Building and managing table-to-table relationships, including implementing many-to-many relationships with a join table
Writing formulas
Testing and troubleshooting
Assigning and managing user roles
Building table-to-table imports and pipelines
1+ years of hands-on experience developing in Quickbase
Comparable experience with another Rapid Application Development (RAD) or relational database platform (e.g., Salesforce, HubSpot, Airtable, Microsoft Power Platform, or similar)
A bachelor's degree in Computer Science, Data Science, Engineering, or a related field
Efficient and detailed data skills including: Cleaning and formatting data in excel by scrubbing for duplicates, converting data types, correcting typos, using formulas and tools to increase efficiency (e.g. Vlookup and Pivot Charts)
Passion for how data can be used for continuous quality improvement
Data analysis and/or management and use of programs (e.g. Excel, R, STATA, Tableau, Power Bi, MAXQDA, Alchemer, SurveyMonkey, REDCap, etc.)
Keen communication skills to interview project staff about workflows and data locations
Perseverance and willingness to sleuth through data
Knowledge of Microsoft Office, virtual meeting software (i.e. Zoom), and other Learning Management Platform Systems (LMS) (e.g. Learning Stream)
Ability to work both independently and as part of an interdisciplinary team in a fast-paced environment
Detail-oriented, highly organized, and able to multi-task/manage multiple projects
Interest in learning new skills
Ability to handle multiple competing priorities at once
Strong written and verbal communication skills
Attention to detail
Providing service excellence to internal clients
Ability to deal with situations and issues proactively
Brainstorming efficient and elegant solutions to solve problems
Following up to ensure high-quality products
Working collaboratively with others to achieve organizational goals
Preferred
Writing formula queries
Company
CAI (Cicatelli Associates Inc)
CAI is a global non-profit organization that tackles the toughest issues facing underserved populations today.