Data Analyst

The Chicago Housing Authority; Chicago (IL); Hybrid; USD 85,000 - 95,000; Full time

Benefits offered by this job

Vacation time

Medical Insurance

Dental & Vision

Disability Insurance

RETIREMENT PLAN 457/401(a) with 3% CH

Parking Transit

Job summary

The Chicago Housing Authority is seeking a Data Analyst to transform complex data into actionable reporting across departments. The role emphasizes SQL, Microsoft reporting tools, and Power BI development to support business needs.

Key responsibilities include creating and optimizing SQL procedures, developing Power BI dashboards, and delivering detailed, well-documented data models. Hybrid work in Chicago is possible after a 90-day probation period.

Qualifications

• Bachelor’s degree in CS or related field.
• Minimum of five years hands-on experience with SSMS, SSRS, and Power BI.

Responsibilities

• Create and refactor SQL Stored Procedures.
• Optimize SQL scripts via performance tuning.
• Modify SQL Open Query for ySQL (Yardi internal scripting).
• Design, develop, test, and deploy Power BI reports.
• Develop automated routines to extract information and document logic.
• Create Power BI Server semantic models and architecture.
• Compile reports using Power BI, Crystal Reports, SSRS, and SQL.
• Translate business requirements into data models.
• Connect to data sources and transform data into dashboards for BI.

Skills

SQL development

SSMS/SSRS

Power BI

Yardi Reporting

Tableau

GIS

Data modeling

Education

Bachelor’s Degree in Computer Science or related

Tools

SQL Stored Procedures

Power BI

SSRS

SSMS

Crystal Reports

Tableau

GIS

Yardi Reporting

Job description

The Chicago Housing Authority is seeking a Data Analyst to turn complex data into comprehensive reporting that supports business needs across departments. The role focuses on analysis, reporting, and data documentation, with an emphasis on SQL, Microsoft reporting tools, and Power BI development.

Responsibilities

• Create and refactor SQL Stored Procedures.
• Optimize internal SQL scripts using performance tuning methods.
• Modify SQL Open Query for ySQL (Yardi Internal Scripting).
• Manage and update the Fresh Service Ticketing System.
• Update SSRS paginated reports by refreshing data sources and datasets via stored procedures.
• Design, develop, test, and deploy reports for Power BI development and administration.
• Develop automated and reusable routines to extract requested information from the database system, including documentation and source control for business logic and dependencies.
• Create and manage Power BI Server Semantic Models and architecture.
• Compile detailed reports using Power BI, Crystal Reports, SSRS, and SQL.
• Translate business requirements into appropriate data models.
• Develop, publish, and schedule Power BI reports according to business requirements.
• Connect to data sources, import data, and transform data into dashboards and reports for Business Intelligence.
• Integrate Power BI content into other applications using embedded analytics through Power BI service (SaaS) and API automation.
• Develop custom visuals for Power BI and implement row level security, including understanding application security layer models in Power BI.
• Partner with business analysts, application architects, and application developers to build data transactions and warehousing systems.
• Support data gathering, cleaning, prototyping, design, and requirement analysis.
• Perform other duties and projects as assigned.

Requirements

• Bachelor’s Degree in Computer Science, Software Engineering, or a related field.
• Minimum of five (5) years of hands-on experience with SSMS, SSRS, and Power BI.
• Extensive knowledge of SQL development to understand underlying data structures.
• Proficiency with Microsoft SQL Server.
• Familiarity with one or more database query languages, such as SQL Stored Procedures or an equivalent approach.
• Ability to collaborate with management, users, peers, and stakeholders to identify report requirements and solution designs in accordance with the CHA reporting specification.
• Strong communication, organization, and documentation skills, with the ability to interface with developers, management, and other ITS personnel for audiences with diverse technical abilities.
• Ability to demonstrate complex and quantitative problem-solving skills and produce timely, creative solutions.
• Strong customer service orientation and a thorough knowledge of relational database theory and practice.
• Capability to work independently and collaboratively with data systems teams; Tableau and GIS experience is a plus.
• Enthusiasm for learning Yardi Reporting.

Technologies

• SQL, T-SQL
• SQL Stored Procedures
• SSMS, SSRS
• Power BI, Power BI DAX, Power Query
• ySQL (Yardi Internal Scripting), Yardi Reporting
• Power BI Server Semantic Models
• Power BI service (SaaS), API automation
• Crystal Reports
• Fresh Service Ticketing System
• Tableau, GIS
• SQL Open Query
• Row level security

Location and Work Arrangement

Chicago, IL (hybrid). This position may be eligible for remote work following successful completion of a 90-day probationary period, according to CHA’s established policies and procedures. The hybrid schedule is position specific.

Compensation

USD 85,000 - 95,000 per year.

Benefits

• Vacation, sick and personal time with a 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 participation continues in the Municipal Employees Annuity and Benefit Fund of Chicago.