Data Analyst Specialist

RINCON FAMILY SERVICES • Chicago, IL

1d • $45,000 - $50,000 • Hybrid

About The Position

The Data Analyst Specialist transforms program and client service data from the Community Engagement and Supportive Services division and the Illinois Welcoming Center into accurate, timely, and actionable information for program leadership, funders, and agency executives. The role designs and maintains the division’s reporting infrastructure – recurring reports, dashboards, and performance metrics tied to grant and contract deliverables – and analyzes service utilization, client demographics, and program outcomes to inform operational decisions. The analyst also owns data quality for the division, defining standards and resolving the root causes of reporting errors rather than correcting records one at a time, while safeguarding confidential client information under all applicable privacy regulations.

Requirements

• Commitment to Rincon’s mission and values, with sound judgment, flexibility, and discretion when handling confidential and sensitive client and program information.
• Analytical rigor – the ability to frame a question, select the appropriate data, test assumptions, and distinguish a meaningful pattern from noise in small or imperfect datasets.
• Ability to communicate quantitative findings clearly to non-technical audiences, including program staff, executive leadership, funders, and community partners.
• Working knowledge of health and human services data concepts: encounters, units of service, episodes of care, enrollment and referral pipelines, and funder-defined performance measures.
• Ability to design and document repeatable processes, so that reporting does not depend on one person’s memory or one undocumented spreadsheet.
• Comfort working with imperfect source data, and the persistence to trace a discrepancy back to its origin rather than adjusting the output.
• Strong organizational skills and the ability to manage concurrent reporting deadlines across multiple programs, contracts, and funders.
• Ability to work independently while collaborating with multiple program teams and levels of leadership.
• Flexibility to work from various offices or program locations as needed to support data collection, analysis, and reporting responsibilities.
• Bachelor’s degree required in a quantitative or related field such as statistics, data analytics, public health, health informatics, social science, or business analytics; an equivalent combination of education and directly relevant experience will be considered.
• Two or more years of experience in data analysis, reporting, or program evaluation; experience in nonprofit, behavioral health, healthcare, or human services settings strongly preferred.
• Advanced Excel required, including pivot tables, lookup and reference functions, Power Query, and structuring datasets for analysis.
• Working proficiency in SQL required – the ability to write queries that join multiple tables and aggregate results without assistance.
• Demonstrated understanding of HIPAA, 42 CFR Part 2, data privacy, and ethical data collection practices involving diverse and immigrant community populations.
• Successful completion of all required pre-employment background checks is required, in accordance with agency policy and applicable program requirements, due to the role’s access to confidential client and program information.

Nice To Haves

• Experience with a business intelligence or visualization platform (Power BI or Tableau) strongly preferred.
• Experience with an electronic health record or client management system preferred; familiarity with Qualifacts Credible is an advantage.
• Experience preparing grant or government contract reporting, and reconciling reported figures to source data, preferred.
• Familiarity with mapping or GIS tools is a plus.

Responsibilities

• Build, maintain, and automate the recurring reports and dashboards used for grant, contract, and internal performance reporting, including required submissions to funders and State agencies.
• Analyze program and client service data to identify trends in service utilization, client demographics, outcomes, referral patterns, and program capacity, and present findings to program leadership in clear written and visual form.
• Extract, join, and validate data across the agency electronic health record (Qualifacts Credible), program tracking systems, spreadsheets, and funder portals to produce a single reliable source of truth for reporting.
• Define and maintain data quality standards for the division – including data dictionaries, entry conventions, and validation checks – and conduct routine audits that identify and correct systemic errors at their source.
• Translate funder, grant, and contract reporting requirements into repeatable data specifications, and reconcile reported figures against source records prior to submission.
• Develop and maintain performance metrics and KPI tracking that allow program leadership to monitor progress against contract deliverables and service targets throughout the reporting period, rather than at the deadline.
• Partner with program staff and supervisors to design intake forms, tracking tools, and documentation workflows that capture required data accurately at the point of service.
• Serve as the division’s data resource during audits, funder monitoring visits, and internal reviews – assembling documentation, explaining methodology, and responding to data requests.
• Support ad hoc analysis for grant applications and renewals, board and executive reporting, program planning, and community needs assessment.
• Protect confidential client and program information in accordance with HIPAA, 42 CFR Part 2, the Illinois Mental Health and Developmental Disabilities Confidentiality Act, and agency data security policy.
• Perform other duties as assigned.

Benefits

• Health insurance
• Dental & Vision insurance
• Life insurance
• Short- and Long-Term Disability Insurance
• 403(b) Retirement Plan
• Generous PTO (Paid time off) – Accrue up to 21 days in Year 1, some PTO carryover allowable.
• Employee Assistance Program
• Professional Development Opportunities
• Employment may qualify for the Public Service Loan Forgiveness Program (PSLF)
• Certain employees may qualify for City of Chicago commuter transit benefits

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level