All Chicago prevents and ends homelessness through emergency financial assistance, community partnerships, data analytics, and training and research. We manage the Homeless Management Information System (HMIS) database, which contains data on Chicagoans experiencing, or at risk of, homelessness and the services they receive. Our team supports more than 900 individual users at 89 partner agencies with training, reports, and helpdesk services. We analyze and disseminate the data to drive discussion, set strategy, and make policy and funding decisions on the federal and local levels. Learn more at www.allchicago.org.
The Lead Data Analyst plays an essential role in extracting quality data from the HMIS database and sharing it both internally and externally to address project needs to work towards addressing homelessness in Chicago. This position works on an interdisciplinary team focused on transforming data into reports, communication tools, and other innovative means. In addition, this position will supervise, mentor, and guide other data analysts and represent the HMIS team in project team meetings, that may comprise of external stakeholders.
An ideal candidate will have strong data analysis and problem-solving skills for delivering high quality solutions on time and on budget. The Lead Data Analyst will analyze current implementation and define best practices or areas to improve business processes. Day to day activities will include managing a direct report and working closely with project leads, analysts, infrastructure, and database staff to ensure project activities are aligned with architectural and functional objectives.
Data analysis and database development and management (approx. 70%)
Analyze and problem solve reporting issues within the current system as they relate to the workflow implementation, integration and management of data.
Analyze data and develop ad-hoc reports for compliance and application of the data by users, based on funding regulatory requirements or ad hoc basis.
Design and restructure the existing data quality process to align with the needs of quality data and update the plans as needed.
Analyze and interpret data to support the new data quality plans and procedures.
Design and develop Microsoft Windows Server infrastructure including but not limited to SSIS, SQL and SSRS; configure and manage SQL Server; write and optimize in-application SQL queries.
Explore options of various cloud plans, cloud application design, management and monitoring.
Troubleshoot server and application issues utilizing event logs and SQL Profiler.
Ensure the data download is happening frequently and work closely with the vendor to handle challenges and technical issues.
Relationship building (approx. 15%)
Work closely with internal and external users and project leads to understand reporting challenges and offer solutions.
Participate and, in some cases, lead data related meetings with both internal and external teams.
Lead meetings with software vendors to better understand system updates and improvements, develop ad-hoc reports and solve for challenges as they arise.
May have to present in public forums, as needed.
Management (approx. 10%)
Provide on-going guidance, mentor, feedback and motivation to one direct report to ensure competent performance while adhering to department and HR policies and procedures.
Oversee staff workload and provide opportunities for cross-system training.
Other tasks (approx. 5%)
Perform data entry when needed or required.
Actively participate in staff and team meetings.
Other duties as assigned.
SKILLS AND QUALIFICATIONS:
Minimum of a Bachelor’s Degree in Information Systems, Computing, Statistics or related fields.
1-2 years programming and report-writing experience in the job-related field.
Familiarity with cloud architectural design, management and monitoring.
High-level of knowledge and competency in relational database management systems.
Experience with Structured Query Language (SQL), Crystal Reports and/or Business Objects is required.
Experience with creating and maintaining technical documentation.
Good working knowledge/skills with Microsoft Office products including, but not limited to, Excel, Word, PowerPoint, Outlook and Access; familiarity with high-level Excel formulas and features (e.g. Macros, VBA) is preferred.
Strong analytical and problem-solving skills.
Excellent communication skills; ability to convey information in a clear and concise manner to groups with varying levels of technical expertise.
Self-motivated with the ability to prioritize, meet deadlines and manage changing priorities in a fast-paced environment.
Proven ability to be flexible and work hard, both independently and in a team environment.
Willingness to work occasionally outside of normal business hours and to take on more responsibilities as assigned.
A strong work ethic, integrity and the highest ethical standards are expected.
This position may require out-of-state travel approximately two times a year.
Passion for inclusivity and diversity, and interest in being part of a multicultural team.
Work place is a smoke- and drug-free environment.
Intermittent travel to off-site locations required.
Position requires frequent and regular computer and phone use.
This position requires attendance during regular business hours from 9am to 5pm, Monday through Friday. Occasional night and weekend hours are required a few times a year.
All Chicago is an equal opportunity employer and seeks to employ qualified individuals based on individual merit. All Chicago does not discriminate against any individual with respect to the terms and conditions of employment based on that individual’s race, sex, age, religion, color, national origin, disability, genetic information, marital status, veteran status, sexual orientation, gender identity or expression, housing status, or any other non-merit factor protected under state, local or federal laws. Equal Employment Opportunity applies to all personnel actions such as recruiting, hiring, compensation, benefits, promotions, training, transfer, termination, and opportunities for training. All Chicago is committed to a fair and equitable workplace where everyone is a respected and valued member of the team.
Apply online with cover letter and resume (required). No phone calls, please.
Additional Salary Information: Salary is commensurate with experience. We offer a comprehensive benefits package (with some employee contributions) includes medical, dental, vision insurance, and disability. Employer-matched retirement plan. Generous paid leave.
About All Chicago
On any given night, nearly 6,000 Chicagoans don’t have a place to call home. Tens of thousands more are just one unexpected setback away from joining them. Together, we can ensure that all our neighbors have stable homes. All Chicago collaboratively addresses the complex issue of homelessness through our four signature approaches.
The Emergency Fund provides critical financial assistance to people experiencing, or at risk of, homelessness or another serious emergency. We quickly provide payments on a person’s behalf for things like rent, utilities, or even bus passes.
2016 Impact: We served 3,195 households, including more than 1,350 children, with $2.7 million. 94% of clients surveyed reported being housed at the time of follow up, and 88% of clients surveyed reported that the financial assistance resolved their crisis.
Continuum of Care
The Continuum of Care is a membership group that strategizes and plans a coordinated, comprehensive approach to providing housing and services for people experiencing homelessness. We drive Chicago’s city-wide response to homelessness by providing leadership to Chicago’s Continuum of Care through a year-round ...research, evaluation, strategic planning, and federal funding application process.
2016 Impact: We secured $65 million in federal funding for 164 projects and staffed 20 stakeholder committees. Overall, Chicago’s homelessness decreased 13% from 2015 to 2016.
Homeless Management Information System
We manage the Homeless Management Information System database, which contains local data on people experiencing, or at risk of, homelessness and the services they receive. We ensure data quality by supporting more than 900 individual users at 89 partner agencies with training, reports, and helpdesk services.
2016 Impact: We analyzed and disseminated the data to drive discussion, set strategy, and make policy and funding decisions on the federal and local levels. The data is a critical component of the Ending Veteran Homelessness Initiative, which has housed more than 2,300 veterans since 2015.
The Learning Center
The Learning Center provides trainings, workshops, tools, and research to help our partners apply proven strategies to prevent and end homelessness in Chicago even more effectively.
2016 Impact: We hosted 42 trainings for more than 900 attendees on topics such as Legal Issues for Homeless Youth. We participated in Notre Dame’s research study proving that emergency financial assistance lowers instances of homelessness by 76%.