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

Department Function

• Collects and presents data and information to support day-to-day program operations, measure program outcomes and impact, and inform resource allocation and program strategies.
• Supports data needs for a variety of CRED and non-CRED Teams, including CRED’s Program, Citywide, Development, and Finance Teams, Community Partners, Funders, and Researchers
• Administers and maintains CRED’s Program Management platform, Salesforce

Essential Duties and Responsibilities

• Manage short and long-term data projects including gathering requirements, developing project timelines, selecting appropriate tools for data cleansing, analysis, and visualization
• Apply critical thinking and objective analysis to data sets, identify data trends, highlight anomalies
• Build new functionality in CRED Salesforce system to support the evolving needs of the organization
• Provide Salesforce support to CRED Program Teams and Partner Program Teams through end-user setup and training, generating reports and dashboards
• Ensure data quality through identifying, investigating, and managing the resolution and escalation of data quality issues
• Export and import data, along with facilitating data transformations
• 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.
• Prepare data visualization
• Integrate CRED Salesforce system with external partners
• Other duties as assigned

Experience and Qualifications

• Salesforce administration and/or development
• Understanding of Salesforce automation best practices including use of Flow
• Data visualization utilizing Tableau or other data visualization software, along with strong quantitative, and analytical skills
• Experience working with a range of data sets; sensitive and/or confidential, small to large, complex and/or administrative data
• Intermediate experience with Google Sheets and Excel
• Strong communication skills and ability to present to various stakeholders of varied technical backgrounds
• Flexibility to adapt to changing needs in order to best support CRED’s mission
• Works effectively and efficiently, both virtually and in-person, independently and part of a team
• Learns new technologies quickly and takes a pragmatic approach to using data and technology

Preferred Experience and Qualifications

• Experience using data to support and/or measure the outcomes and impact of social service programs
• Experience with Python and utilizing Pandas for data manipulation
• Experience with Google Apps Script or JavaScript
• Experience using Geospatial data

Educational Requirements

• Bachelor's degree in Data Analytics, Computer Science, Information Technology, or equivalent combination of education and experience
• Salesforce Administrator Certification and/or Salesforce Certified Platform App Builder

Location

This position will be hybrid, based out of the downtown Chicago office, but will require travel to site locations on the west side, south side, and other locations within the Chicago area.

Physical Requirements and Working Environment

• Ability to sit for extended periods of time.
• Ability to work with a computer for extended periods of time
• Schedule is generally 9-5 but flexibility is expected to support the Program Team whose hours can vary

*Candidates should submit a cover letter*

CRED is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Job Type: Full-time

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

Benefits:

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

Schedule:

• Monday to Friday

People with a criminal record are encouraged to apply

Experience:

• Data management: 1 year (Preferred)

Ability to Relocate:

• Chicago, IL 60601: Relocate before starting work (Required)

Work Location: Hybrid remote in Chicago, IL 60601