Chicago Housing Authority

Data Analyst

• Process data into comprehensive reports and produce accessible information for different departments in the authority
• Analyze complex data systems and document data elements, data flow, relationships, and dependencies
• Create and refactor SQL stored procedures
• Optimize internal SQL scripts using performance tuning methods
• Modify SQL Open Queries for ySQL (Yardi Internal Scripting)
• Manage and update the FreshService ticketing system
• Update SSRS paginated reports, including data source and dataset updates via stored procedures
• Design, develop, test, and deploy reports for Power BI development and administration
• Develop automated and reusable routines for extracting requested information from database systems, with documentation and source control for business logic and dependencies
• Create and manage Power BI Server semantic models and architecture
• Use measures, calculated columns, variables, and optimization techniques
• Use DAX and Power Query to model fact and dimension tables
• Compile detailed reports using Power BI, Crystal Reports, SSRS, and SQL
• Understand business requirements and develop corresponding data models
• Develop, publish, and schedule Power BI reports
• Connect to data sources, import and transform data into visuals and reports for Business Intelligence
• Integrate Power BI reports into other applications using embedded analytics, Power BI service (SaaS), or API automation
• Develop custom Power BI visuals and implement row-level security and application security layer models
• Partner with business analysts, application architects, and application developers to build data transaction and warehousing systems
• Perform data gathering, cleaning, prototyping, designing, and requirement analysis
• Perform other duties and projects as assigned

Project Manager

• Serve as the designated CHA point of contact for resident concerns involving property management, developers, CHA departments, and other responsible parties in mixed-income communities
• Track resident concerns from identification through resolution using CHA systems, including Yardi or other established mechanisms
• Identify and analyze recurring, urgent, or unresolved concerns and recommend next steps
• Facilitate communication among residents, property management, developers, and CHA departments to resolve issues
• Coordinate required Ombudsman meetings, resident notices, reporting, and related activities
• Lead implementation and coordination of the Community Engagement Teams strategy, including supporting quarterly meetings and piloting new strategies
• Work with Resident Leadership, Property Management, CHA’s Property team, and other departments to identify concerns, establish responsibility, and monitor follow-up
• Track recurring property management, unit, common-area, and community concerns raised through CET
• Document progress, outcomes, and lessons learned from the pilot and support recommendations regarding future implementation
• Participate in the onsite inspection team through Quality Assurance and Accountability
• Coordinate with CHA’s Customer Experience Team to address calls and emails
• Build and maintain relationships with CHA residents, resident leaders, community organizations, and other stakeholders
• Coordinate and participate in resident and community meetings, site visits, engagement sessions, and special events
• Engage with CAC, LACs, SHAC, and other resident leadership groups as assigned
• Support surveys, listening sessions, focus groups, redevelopment, capital improvements, community initiatives, and other CHA priorities
• Complete reports and dashboards tracking issues and resolutions
• Identify trends and recurring concerns and provide updates to the Director and Executive leadership
• Support special projects, executive initiatives, and urgent resident or community matters

Data Analyst

Project Manager, Resident Engagement – Ombudsman