Data Analyst

Chicago Housing Authority

. Process data into comprehensive reports and produce accessible information for different departments in the authority .

Posted 10/3/2026full-timeChicago • Illinois • United StatesMid-LevelSenior💰 $85,000 - $95,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL Development, Power BI report creation, and data analysis, with a strong focus on optimizing data systems and delivering comprehensive reports. Proficient in collaborating with stakeholders to translate business requirements into effective data models and visualizations.

Highest-signal resume keywords

SQL DevelopmentPower BI Report DevelopmentSSRS ReportingData AnalysisPerformance Tuning

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL Stored ProceduresDAXPower QueryData ModelingRelational Database TheoryData TransformationPerformance Tuning MethodsData GatheringData CleaningData Warehousing

Soft Skills

Excellent Communication SkillsOrganizational SkillsProblem-Solving SkillsCustomer Service SkillsCollaboration Skills

Tools & Technologies

Microsoft SQL ServerPower BISSRSFreshServiceCrystal ReportsTableauGIS

Industry Keywords

Business IntelligenceData VisualizationData ArchitectureTechnical ArchitectureEmbedded Analytics

Tech Stack

Tools & technologies

MS SQL ServerSQLTableau

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

Bachelor’s Degree in Computer Science, Software Engineering or related field
Minimum of five (5) years hands-on experience with SSMS / SSRS/ Power BI
Extensive knowledge in SQL Development and underlying data structures
Proficiency with Microsoft SQL Server
Familiarity with one or more database query languages, such as SQL Stored Procedures or equivalent
Ability to collaborate with management, users, peers, and other stakeholders to identify report requirements, user and technical requirements, solution designs, technical architecture, and delivery in accordance with the CHA reporting specification
Excellent verbal, oral and written communication skills
Organizational and documentation skills
Ability to interface with developers, management and other ITS personnel and communicate knowledge to audiences of diverse technical abilities
Complex and quantitative problem-solving skills
Strong customer service skills
Thorough knowledge of relational database theory and practice
Ability to work independently and collaboratively with data systems teams
Tableau and GIS experience is a plus
Enthusiasm and drive to learn Yardi Reporting

Benefits

Comp & perks

Vacation, Sick and Personal, competitive PTO package
Medical (HMO, PPO, and No employee cost High-Deductible PPO), Dental, Vision, and Life Insurance
Short-Term and Long-Term Disability Insurance
Long-Term Care Insurance
Pet Insurance
Parking Transit
Prepaid Legal Services
Brightstar 529 College Savings Plan
Identity Theft Protection
Hospital Indemnity Insurance
Voluntary Critical Illness Insurance
Deferred Compensation Plan: Empower 457/401(a) with a 3% employer match
Pension Plan: CHA makes contributions on behalf of the employee, along with the employee's 3% contribution; 100% vesting occurs after 6 years of continuous employment or opt-out of CHA's Retirement Plan and continues to participate in the Municipal Employees Annuity and Benefit Fund of Chicago
Hybrid work schedule (position specific)
This position may be eligible for remote work following a successful completion of a 90-day probationary period according to CHA’s established policies and procedures