Data Analyst

Data Analyst, HMISThe Data Analyst is a member of the Homeless Management Information Systems team. The team works with the community to provide Homeless Management Information System administration, create reports and data extracts, conduct in-person training and provide technical assistance for users across the Chicago Continuum of Care (CoC). The HMIS Data Analyst plays an essential role in reviewing, understanding, and processing data from multiple sources to develop reports, data requests, visualizations, and data transformations based on the needs of the community. The responsibilities of the Data Analyst include creating new reports and custom data extracts as directed, maintaining existing report portfolio by updating content as needed, and testing and validation of output produced.Position responsibilities and work volume will be established and evaluated through ongoing supervision, annual reviews, and the development of an annual professional development plan.Position Responsibilities:Work with requesting partners and internal staff to understand report, visualization, and data extract requestsDocument requirements necessary for solution deliveryDevelop technical specifications for building the requested solutionCreate data sources, tables, spreadsheets, programs, processes, and data flows to support custom reporting and data extract requestsEnsure verification and validation of all data sources and data transformationsProduce report mock-up or proof of concept for review during solution developmentDocument expected results and test plan to verify resultsMaintain and update data dictionary as needed for common data definitions for the CoCPrepare and maintain a catalog of reports and data requestsUpdate report and request catalog based on HUD Data Standards Changes and other system-wide specification changesPursue additional training or knowledge as needed to accomplish the above activitiesProactively identify data quality issues and work with HMIS management to implement solutionsProduce and provide documentation on content, context, and proper use of reports and data requestsTrain internal and external users on utilizing reports and data extractsSystem Administration & Help Desk Support:Collaborate with Help Desk staff and end-users to investigate and resolve issues with existing reports, data extracts, and data visualizationsAssist with supporting production systems that perform regularly scheduled data loads, transformations, and report distributionAdministration of some internal and external data sources other than HMIS systemRemain knowledgeable about current Data Standards, HMIS application and data changes, CoC-specific uses of data, and other relevant topics through independent study, relevant workshops, and conferencesOther Tasks:Keep current on trends and best practices related to reporting toolsActively participate in department and agency meetingsCommunicate effectively with management, peers, and partners in written, oral, video, and in-person communicationsOther duties as assignedRequirements:2 years of overall relevant work experience or a college degree in Information Systems, Computer Science, Data Analytics, Business Analytics or related field1 year of experience in report design and implementation using tools such as MS Excel templates with VBA macros, Python scripting, Microsoft SSRS Report Builder, BusinessObjects Web intelligence, or equivalent toolsExperience defining and performing quality assurance tasks including testing and validation of resultsExpert knowledge/skills with Microsoft Office products including, but not limited to Excel, Word, PowerPoint, Outlook, and AccessWorking knowledge of Microsoft SQL Server databases and query languageExperience with a Homeless Management Information System (HMIS) is preferredExcellent communication skills; ability to convey information in a clear and concise mannerSelf-motivated with the ability to prioritize, meet deadlines and manage changing prioritiesProven ability to be flexible and work hard, both independently and in a team environmentA strong work ethic, integrity, and the highest ethical standards are expectedPassion for inclusivity and diversity, and interest in being part of a multicultural teamCompensation:We offer a comprehensive benefits package which includes medical, dental, vision insurance, and disability, employer-matched retirement plan, paid leave, and more.To Apply:· Please submit cover letter and resume