SC2 Data & Insights Coordinator

Chicago CRED; Chicago (IL); Hybrid; USD 55,000 - 65,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Disability insurance

401K

Job summary

Chicago CRED is seeking a SC2 Data Coordinator to join the team on a hybrid schedule in Chicago. You will work with SC2 communities to clean, curate, and feed data from multiple sources into a singular data system, enabling accurate reporting and decision support.

The role requires building a data field dictionary, migrating data into Apricot, performing analyses for performance and strategy, and ensuring data security standards are met across platforms.

Qualifications

• Experience using statistical languages (R, SQL) to manipulate data and draw insights.
• Experience with data security measures and architecture.
• Experience using visualization tools such as Tableau and/or Power BI.
• Experience with mapping software (ArcGIS, QGIS).
• Strong communication skills for varied technical audiences.
• Experience using different data platforms such as Salesforce, Apricot, etc.
• Experience using data to support and/or measure impact of social service programs.

Responsibilities

• Document data field dictionary/business glossary of Apricot objects and fields used by SC2 programs
• Coordinate the migration of data into Apricot from third-party systems
• Data analysis for SC2 Capacity Building communities to inform performance and inform strategy with SC2 leadership
• Assist with data cleanup tasks such as duplicates and cleaning for warehouse accessibility
• Assist in managing projects for Apricot optimization and updates
• Assist in user access management with the timely addition and removal of users
• Participate in SC2 and data transformation committees and projects
• Align data security standards with nationally approved guidelines
• Other data management duties as assigned
• Manage short and long-term data projects with requirements, timelines, and tools
• Create reports in the database to share updates with hubs and funders
• Provide SC2 organizations with technical assistance and evaluation oversight
• Collect and analyze crime and violence data from various sources

Skills

R/SQL

Data security

Tableau

Power BI

ArcGIS

QGIS

Communication

Data monitoring

Salesforce

Apricot

Impact measurement

Education

Bachelor's Degree or relevant experience

Tools

Salesforce

Apricot

RedCap

Evolve

NeonOne

Job description

Chicago CRED is seeking a SC2 Data Coordinator to join the team on a hybrid schedule in Chicago. You will work with SC2 communities to clean, curate, and feed data from multiple sources into a singular data system, enabling accurate reporting and decision support.

The role requires building a data field dictionary, migrating data into Apricot, performing analyses for performance and strategy, and ensuring data security standards are met across platforms.