SC2 Data Coordinator

Job Title: SC2 Data Coordinator

FLSA Status: Exempt

Reports to: SC2 Implementation Manager

Background:

Chicago CRED is a mission driven organization working to achieve transformational reduction in violence in Chicago. CRED does its work by offering direct services to those who are at the highest risk of violence, advocating for policy reform to increase public investment into community violence interventions, and promoting cross-sector coordination to achieve maximum impact.

Scaling Community Violence Intervention for a Safer Chicago, or SC2, is a growing

community of donors and anti-violence practitioners committed to working together to

advance one of the most promising near-term impact approaches, community

violence intervention (CVI). Their goal is fully resourced, locally-led, at-scale CVI

efforts in the 20 communities with the highest levels of gun violence.

At this early stage, SC2 is a strategy of the Partnership for Safe and Peaceful

Communities (PSPC), a coalition of more than 50 foundations and other philanthropic

entities. It also is a commitment of the Civic Committee of the Commercial Club of

Chicago, the city’s premier business-led organization concerned with the strength,

vitality, and growth of the city and the region. SC2 is supported Chicago CRED and Metropolitan Peace Initiative, the SC2 Implementation Partner. Representatives of these

latter organizations will engage with counterparts in the most-effected communities to

gauge interest and readiness to work at greater scale and share information about

effective tools and practices.

The goal is to grow SC2 to include, at “one table,” all the private, philanthropic,

community, and public leaders and funders, CVI practitioners, and other community-

based organizations needed to support, participate in, and sustain a shared plan to

significantly reduce gun violence in the 20 communities.

Department Function

The data coordinator will work in collaboration with all SC2 communities to help with technical assistance and day to day data responsibilities. This position will work closely with the SC2 Project Manager and will be responsible for cleaning and maintaining specific data coming in from various sources (Salesforce, Apricot, RedCap, Evolve, NeonOne etc) to be able to curate a report that can align and will feed into a visualization softwares. Chicago CRED is seeking a Data coordinator to help work across a broad spectrum of stakeholders, build capacity for organizations in our neighborhoods and to maintain a data platform for ease of use and accessibility by partners.

Essential Duties and 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 including but not limited to ensuring appropriate data is received in a timely manner
• Conduct analyses on raw data metrics being collected for performance reporting and trend analyses
• Data analysis and report writing for SC2-wide reporting
• Assist with data clean up tasks such as duplicates and cleaning
• 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

· Create reports in the database to share updates with the hubs as well as reporting back to funders (as applicable)

· Documentation, evaluation, and reporting of current data collection items and provide suggestions for improvement.

· Provide SC2 organizations with technical assistance and evaluation oversight.

Work in conjunction with SC2 Project Manager to assess potential sites’ current level of documentation and potential areas for growth

· Job duties may shift as we accommodate community needs. Flexibility is required

Experience and Qualifications

· Experience in data monitoring, cleaning, and analysis for varying audiences - required.

· Experience with MS Office Suite - required

· Experience using data to support and/or measure impact of social service programs - required

· Experience using programming languages preferred

· Experience using visualization tools such as Adobe Indesign, Tableau, and/or Power BI preferred

· Ability to collect, organize, interpret, and summarize information

· Strong communication skills and ability to present to various stakeholders of varied technical backgrounds.

Education

· Bachelors Degree or a minimum of 2 years relevant experience required.

Location

This position will be based on Chicago’s West Side, South Side, etc. with local travel to site locations. Must have a valid driver’s license and insurance.

Physical Requirements and Working Environment

· Ability to sit or stand for extended periods of time.

· Ability to work with a computer for extended periods of time-up to 70%.

This position primarily works a hybrid schedule Monday-Friday during business hours but may require nights and weekends on some occasions.

Compensation

$75,000-$80,000 (commensurate on experience)

Chicago CRED offers a competitive benefits package which includes medical, dental, vision, disability and 401K.

Chicago CRED, Inc. is an equal employment opportunity employer dedicated to the fair and equal treatment of all its employees without regard to age, gender, race, color, religion, creed, national origin, ancestry, sexual orientation, disability, political or union affiliation, maternity status, parental status, military status, or any other basis prohibited by law. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of the job.

The above job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required for the position.

Job Type: Full-time

Pay: $75,000.00 - $85,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• Please include a COVER LETTER in addition to your RESUME

Ability to Commute:

• Chicago, IL 60601 (Required)

Work Location: In person

Salary : $75,000 - $85,000