Data Analyst

At Youth Guidance, we believe that no matter what challenges a young person faces, they are more likely to succeed when they have caring adults in their lives. Our highly-trained staff guides kids to overcome the life and academic challenges facing Chicago’s youth. We meet kids where they are — physically and emotionally — to help them focus on their education, make positive choices, and remain on the right path toward life success.

Youth Guidance creates and implements school-based programs that enable at-risk children to overcome obstacles, focus on their education and, ultimately, succeed in school and in life. Founded in 1924, Youth Guidance is a leading provider of outcomes-driven programs, directly serving approximately 14,000 youth in over 200 schools this year. Youth Guidance’s Counseling & Prevention Programs include Becoming a Man (BAM) and Working on Womanhood (WOW). The organization also provides Community & Afterschool Programming and Youth Workforce Development services.

Position Summary:

The Data Analyst is responsible for supporting the collection and analysis of data as a part of the agency’s improvement efforts. The analyst will work closely with program teams and within the Evaluation and Quality Improvement team to ensure high quality data entry. The analyst will also provide technical support for end users. This is a hybrid remote position.

Essential Duties/Responsibilities:

• Provide ongoing configuration support for the client information system used by program staff.
• Compile data sets from multiple sources and prepare for analysis
• Provide training and internal customer service support to program staff as it relates to the client information system.
• Provide support for data collection across all program teams, including creation of online forms and surveys, and collection of data from internal and external sources
• Monitor service documentation, data entry, data review and cleaning, and report preparation
• Review program service data entered by agency staff for quality, accuracy and completeness
• Support the submission of program reports to stakeholders
• Organize and maintain electronic and paper files of data and reports for easy access, identification, and analysis

Minimum Qualifications:

Education/Experience/Training

• Associate degree from an accredited university or college or equivalent experience
• Minimum of 2 years of experience with data analysis or database management (internships ok)

Skills/Abilities

• Some programming experience (eq. SQL, Python, R) preferred.
• Possess a basic understanding of relational databases including how to query and organize them.
• Proficient in Microsoft Excel (create formulas, pivot tables, charts, and graphs), as well as other Microsoft Office products (Word, PowerPoint)
• Experience with Tableau or PowerBI a plus
• Experience with Salesforce a plus
• Proficient using web-based tools, such as Google docs, SharePoint, etc.
• Ability to communicate data and analyses to a general audience through presentations and/or writing a plus.
• Excellent organization and project management skills
• Ability to work well in group and team settings
• Must possess interpersonal skills that excel in cultural sensitivity and respect for differences
• Must be committed to working with disadvantaged youth
• Must be committed to the continuous improvement to service quality and the organization’s mission

Core Competencies:

• Communication: Uses effective written and oral communication with internal staff, teams, and community served; demonstrates empathy and listening
• Client orientation: Recognizes needs of diverse stakeholders and approaches relationships with a service orientation, to ultimately maximize the impact
• Equity mindset: Understands and is committed to goals of equity, consistently brings an equity mindset to the organization’s work and workplace
• Growth mindset: Views growth as important for personal and professional development; seeks out opportunities to expand skills, even if the change is required, demonstrates curiosity and eagerness to learn
• Ownership and quality of work: Effectively manages own work, and work of the team to ensure delivery of high-quality work
• Supervisory skills: Effectively manages and develops others
• Mission drive: Demonstrates commitment to the missing of the organization as a whole and alignment with organization values

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

• While performing the duties of this job, the employee is regularly required to frequently talk and hear.
• The employee frequently is required to sit and stand for sustained periods of time; walk; use hands and fingers to handle or feel; and reach with hands and arms.
• The employee may occasionally lift and/or move up to 20 pounds.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This job operates in a professional office environment.

• The duties performed are primarily in an office setting, COVID-19 vaccination is required.
• This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.
• Occasional local travel.

DEI Statement

At Youth Guidance, we understand that diversity, equity, and inclusion (DE&I) are fundamental to realizing our vision of bright and successful futures for all young people. We celebrate the diversity of youth and recognize them as empowered leaders, problem-solvers, and experts of their own experiences. At the same time, we acknowledge that many systems and institutions meant to support youth are inequitable and unjust.

As such, we are committed to advancing DE&I through our words and our actions, both internally and externally, by:

• Strengthening cultural competence as well as policies, practices, and organizational structures that foster belonging and leverage the unique backgrounds and talents of staff;
• Offering youth-centered programs that are accessible and responsive to people from diverse racial and ethnic backgrounds, abilities, sexual identity, gender identity and expression, language, and cultural and religious beliefs and practices;
• Influencing systems that youth, their families, and communities are impacted by, such as schools, organizational networks, governmental bodies, researchers, and the funding community, to apply approaches that embrace DEI in addressing the needs and supporting the aspirations of young people.

Youth Guidance is an equal opportunity employer and proudly values diversity. Youth Guidance does not discriminate on the basis of race, color, religion, sex, national origin, disability, veteran status, marital status, sexual orientation, or any other characteristic protected by applicable law and is committed to creating a dynamic work environment that values diversity along all of these lines. People of all backgrounds are encouraged to apply.