SC2 Data Coordinator

Chicago CRED is a mission-driven organization focused on reducing violence in Chicago through direct services and policy reform. They are seeking an SC2 Data Coordinator to collaborate with various communities, manage data projects, and ensure data integrity across multiple platforms.

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 help inform performance and strategize with SC2 leadership on technical next steps
• Assist with data clean up 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 and contribute to SC2 and data transformation committees and projects
• Ability to align data security standards with those that are nationally approved
• Other case management system and data management duties as assigned
• Manage short and long-term data projects including gathering requirements, developing project timelines, selecting appropriate tools for data cleansing, analysis, and visualization
• Create reports in the database to share updates with the hubs as well as reporting back to funders (as applicable)
• Provide SC2 organizations with technical assistance and evaluation oversight
• Collect and analyze crime and violence data from a range of public and private sources including the City of Chicago Violence Reduction Dashboard, City of Chicago Data Portal, Salesforce, external violence prevention organizations, etc

Skills

• Experience using statistical computer languages (R, SQL, etc) to manipulate data and draw insights from large data sets
• Experience working with data security measures and architecture
• Experience using visualization tools such as Adobe Indesign, Tableau, and/or Power BI
• Experience with mapping software (ArcGIS, QGIS etc)
• Strong communication skills and ability to present to various stakeholders of varied technical backgrounds
• Experience in data monitoring, cleaning, and analysis for varying audiences
• Experience using different data platforms such as Salesforce, Apricot, etc
• Experience using data to support and/or measure impact of social service programs
• Bachelors Degree or relevant experience required

Benefits

• Medical
• Dental
• Vision
• Disability
• 401K

Company Overview