CCRAB is seeking a qualified professional or team of professionals to provide data management, analysis and communication services to support community-led environmental and public health research and monitoring in Charleston County, SC. This request is for services only and does not include equipment or any other unallowable costs/activities.
A successful candidate will demonstrate an ability to create systems for data management and communication that can be easily learned and maintained by CCRAB staff and citizen scientists with limited training and support, and that do not require a significant annual financial investment.
The specific responsibilities of the consultant(s) are detailed below.
Develop and maintain affordable and user-friendly systems for long-term data collection and analysis.
Establish a Data Access Hub, a centralized location for all environmental and public health data collected by CCRAB and other community partners. Data on the Data Hub will be available for online viewing, download and/or via API feed (when available).
Assist with the development and maintenance of an alert system using real-time air quality data to notify residents when there is increased risk of exposure to air pollutants. The alert system will include:
text and email alerts
a visible indicator installed on high gear monitors
Develop systems for generating compelling and easy-to-understand data visuals, to be used by CCRAB to communicate air quality and other environmental trends and progress to residents, area policymakers, local governments, public health agencies and non-profits providing services to the focus communities. Focus groups will be used to assist with design, testing and validation of all data access and reporting methods.
Experience with developing and implementing QA/QC procedures to ensure data integrity.
Experience in gathering, compiling, visualizing, and analyzing data, including documenting workflows via protocol development, metadata documentation, and production of reports. Experience with environmental and/or public health data is strongly preferred.
Strong familiarity with open-source, non-proprietary programs and software for data collection, management, sharing and visualization.
Strong skills in working with spatial data and GIS.
Experience establishing data collection systems that include crowdsourcing methods and manual field entry.
Strong skills in development of reproducible data management workflows and programming using scripted software (e.g. R, python, SQL).
Experience producing data visuals that communicate complex information in accessible, digestible ways.
Experience managing large and/or diverse datasets (e.g. tabular, spatial, photographic, etc, but especially sensor-based data), including compiling associated metadata
Experience with setting up and maintaining a shared database, including use of cloud data storage and access when appropriate, and server development and maintenance.
Familiarity with data sharing agreements and memorandums of understanding, open data, and data sovereignty.
Experience training or communicating complex technical information to lay people.
Demonstrated ability to acquire and implement new skills through self-directed learning.
Please read the full position description here to learn how to apply. The deadline for proposals is July 3, 2025 at 11:59pm.
QUESTIONS SUBMITTED REGARDING THE DATA MANAGEMENT AND COMMUNICATIONS SERVICES POSITION
How is this work being funded? i.e. what grant program? A: EPA Enhanced Community Air Monitoring (year 2&3 of 3-year grant) and NOAA Sub-award through Biohabitats (3-year grant)
The RFP mentions the option for a timeline extension. If that happens, would there be a budget extension accompanying it? A: If the budget has been exhausted, yes.
What do you have in mind from a data visual perspective for the reports? Are you looking for complex visually appealing graphics generation or moreso basic text word document reports? A: The exact format and content and visuals will be informed by a series of focus groups, but the goal is for CCRAB staff to be able to take over data visual production in the long-term, so the process to create visuals should not be too specialized or complex.
Is it assumed that a software platform(s) will be needed to support the functionality outlined in the scope? Examples would include text alerts (SMS alert platform), GIS administration (cloud based mapping platform) and automation workflows (automation platform). A: Yes.
In the RFP under qualifications you mention, "Strong familiarity with open-source, non-proprietary programs and software for data collection, management, sharing and visualization."
Is there a desire to use open-source platforms, or are proprietary platforms able to be used as well? A: The reason for specifying open-source is because of their affordability. A central goal to this scope of work is to set CCRAB up for long-term success. We are open to proprietary platforms so long as we do not end up with a data management system that is burdensome to maintain from a cost standpoint.
Does "visible monitor" reference a dashboard that will provide indications for alerts? A: "Visible monitor" references a physical indicator to be mounted on the air monitors.
The RFP references that the effort may also include other types of environmental and public health data – can you please provide examples of what additional data CCRAB has in mind? A: Current data includes air quality, water quality, flooding imagery, water levels, precipication, and groundwater levels. Other potential future datasets may include soil contaminants, community-reported public health impacts (survey-based), or other emergent datasets.
Who is responsible for the initial data collection and analysis? A: CCRAB and CCRAB research partners are responsible for data collection and analysis. However, the data management/analysis/communications consultant would advise and assist with setting up a more streamlined process for converting raw data to digestible formats; if this is not already being done by the data collection platform (ex: PurpleAir).
CCRAB provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.