Data Analyst

If asked to describe the culture at Metropolitan Family Services, we could do that in one word. COMMUNITY Reflected in both our internal culture as well as through the services we provide, community is at the heart of all we do.

Metropolitan Family Services (MFS) empowers families to learn, to earn, to heal, to thrive. Part mentor, part motivator, part advocate, since 1857, Metropolitan Family Services has been the engine of change that empowers families to reach their greatest potential and positively impact their communities. Are you looking to have an impact on more than just a company's bottom line? Then we'd love to hear from you

We are currently looking to fill a Data Analyst role at our HQ.

SALARY:

• The average starting salary for this position will fall in the range of $45,000 and $55,000 annually. Where candidates fall in this range will be based on skill and experience level.

ESSENTIAL JOB FUNCTIONS:

• Data Collection: Lead the use of the primary REDCap servers utilized by the department, ensure builds are aligned internally and with agency standards, and serve as the expert for the team.
• External Datasets: Gather, understand, and combine data from external databases utilized by MFS programs to support monitoring, reporting, and evaluation.
• Data Cleaning: Conduct complex data cleaning and preparation using advanced software like R, SQL, Tableau Prep, and Python. Support evaluation managers in learning how to prepare their datasets.
• Data Storage: Create and maintain processes for regular use of the data warehouse and data marts. Support other evaluation staff in successfully connecting to the warehouse for their program areas.
• Monitoring: Create complex dashboards in Tableau to view and monitor critical data for program evaluation. This includes gathering user requirements from staff, either independently or in collaboration with other evaluation staff.
• Reporting: Create systems for responding to data inquiries from diverse stakeholders that provide accurate, reliable, and internally consistent data.
• Advise and Consult: Guide team members in best practices for data capture in REDCap and visualization in Tableau.
• Engages in continuous learning and knowledge-building through conferences, meetings, training, and other opportunities to enhance essential functions.
• Other duties as assigned

KNOWLEDGE, SKILLS, and ABILITIES:

• Excellent written and oral communication
• Able to lead a project from start to finish
• Strong interpersonal, analytical, and problem-solving skills
• Commitment to diversity and inclusion
• Effective in collaborative teams and working independently
• Committed to learning and growth
• Flexibility in handling changing priorities
• Highly proficient in Microsoft Word, Excel, and PowerPoint
• Mobility to travel within Metropolitan Chicago Area

QUALIFICATIONS:

• Bachelor's Degree in economics, psychology, sociology, political science, statistics, public policy, social work, or other relevant social/mathematical science field data science, data engineering, computer science, public policy, social service field, or applicable quantitative discipline required
• Four years' data management, entry, and analysis experience
• Expert in REDCap
• Highly proficient in Tableau
• Proficient in SQL
• Certified Tableau Data Analyst preferred

ADDITIONAL REQUIREMENTS:

• Satisfactorily pass all relevant screening and criminal background checks.

TRANSPORTATION/TRAVEL REQUIREMENTS:

• Driving not required

PHYSICAL DEMANDS

• While performing the essential duties of this job, the employee is required to sit and stand for sustained periods of time, frequently talk, hear, use hands and fingers to feel, handle, and operate objects or controls, and occasionally stand, bend, stretch, stoop, kneel and crouch. The employee is required to have close visual acuity to perform an activity such as preparing and analyzing data and figures, transcribing, and viewing a computer terminal.

Metropolitan Family Services puts our people first with a top-of-the-line benefits package. Find out more by clicking here

Some highlights include:

• Medical Coverage, Dental Coverage, and Vision Coverage.
• Metropolitan Family Services contributions of $2,000 to individual, and $4,000 to family, HSA accounts, pro-rated to your benefits start date.
• FREE General Medicine and Behavioral Health Teladoc services provided to all team members.
• Ascensus 401K plan services with a 4% employer match, vested at 100% on day one of eligibility.

And so much more Make sure you click here to see the full suite of benefits offered

• Some of the above benefits are available for part-time and temporary workers, but not all. Be sure to inquire upon your hire as to which benefits apply to you.

MORE ABOUT US:

Metropolitan is Illinois' first comprehensive human services agency and reaches more than 122,970 individuals and families in Chicago, Evanston/Skokie, the southwest suburbs, and DuPage County with services promoting education, economic stability, emotional wellness, and empowerment.

Required

• Proficient in SQL
• Highly proficient in Tableau
• Expert in REDCap
• 4 year(s): Experience with data management, entry, and analysis

Required

• Organizational Skills
• Verbal and Written Communication
• Analytical Skills

Preferred

• Team Player: Works well as a member of a group
• Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.