Metropolitan Family Services
Senior Data Analyst - SQL Job at Metropolitan Family Services in Chicago
Metropolitan Family Services, Chicago, IL, US
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. We are currently looking to fill a Senior Data Analyst role at our Headquarters!
The average starting salary for this position will fall in the range of $72,000 and $79,000 annually. Provide advanced data analytics support to Evaluation Managers, including data analysis, data source improvements, and streamlined processes for efficient data cleaning and reporting.
• Support program-specific and agency-wide Tableau dashboard builds.
• Conduct rigorous data cleaning and analysis utilizing advanced software tools, such as R, SQL, or Python.
• Utilize existing databases for evaluation purposes, including writing SQL queries and monitoring data quality and integrity.
• Provide support, training, and technical assistance to program and administrative staff, including guidance on interpretation and usage for non-technical staff.
• Manage and mentor data analytics associates and interns, ensuring a balanced workload that aligns with strategic priorities and fosters professional development.
• Lead or support data-related projects, ensuring timely completion and alignment with organizational goals.
• Review and approve materials and reports created by supervised staff to ensure accuracy, quality, and alignment with organizational standards.
• Document data analytics processes, procedures, best practices, and project-specific decisions.
• Excellent verbal and written communication skills, with the ability to present complex data findings to diverse audiences clearly and effectively.
• Awareness of and sensitivity to the diverse backgrounds and experiences of clients served, with a commitment to promoting equity in data practices.
• Ability to work effectively in a hybrid work environment.
Master’s Degree in a relevant quantitative discipline or social services field with significant quantitative training, OR 8+ years of progressively more advanced work in a relevant field required.
• Experience with data monitoring, cleaning, and analysis in a nonprofit, academic, or social services setting required.
• Advanced quantitative analysis in R, Python, or another software required.
• Intermediate to advanced SQL experience required.
• Advanced experience with Tableau and Tableau Prep required.
• Supervision experience, preferably within a non-profit organization required.
• Bilingual English/Spanish preferred.
TRANSPORTATION/TRAVEL REQUIREMENTS:
• 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.
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.
• Some of the above benefits are available for part-time and temporary workers, but not all. 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.
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.