Chicago Housing Authority
4 days ago Be among the first 25 applicants
Job Description
The Data Analyst, is responsible for processing data into comprehensive reports, aiming to produce information that is accessible to different departments in the authority. This position is responsible for data analysis of complex data systems and documenting data elements, data flow, relationships and dependencies to support the business needs of the authority. View More Jobs
Data Analyst
Chicago, IL, United States (Hybrid)
Trending
Job Description
The Data Analyst, is responsible for processing data into comprehensive reports, aiming to produce information that is accessible to different departments in the authority. This position is responsible for data analysis of complex data systems and documenting data elements, data flow, relationships and dependencies to support the business needs of the authority.
Duties And Responsibilities
Creation & Refactoring of SQL Stored Procedures. SQL Open Query Modifications for ySQL (Yardi Internal Scripting) Ability to Manage & Update Fresh Service Ticketing System SSRS Paginated Report Updates. (Data Source + 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. Creation and management of Power BI Server Semantic Models & Architecture. Compile detailed reports using data reporting tools [Power BI, Crystal Reports, SSRS & SQL] Able to properly understand the business requirements and develop data models accordingly. Skilled in developing, publishing and scheduling Power BI reports as per the business requirements. Connecting to data sources, importing data, and transforming data into informative visuals and reports for Business Intelligence. Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Experienced in developing custom visuals for Power BI and able to implement row level security on data and understand application security layer models in Power BI. Work in partnership with business analysts, application architect, application developers to build data transactions and warehousing systems. Knowledge of data gathering, cleaning, prototyping, designing, and requirement analysis. Performs all other duties and projects as assigned.
Qualifications
Bachelors Degree in Computer Science, Software Engineering or related field, with a minimum of five (5) years hands-on experience with SSMS / SSRS/ Power BI. Masters Degree is a plus. Must have extensive knowledge in SQL Development to understand underlying data structures. Proficient with Microsoft SQL Server, familiar with one or more database query languages, such as SQL Stored Procedures or Equivalent. Must be able 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. Must have excellent verbal, oral and written communication skills, organizational and documentation skills, and be able to interface with developers, management and other ITS personnel to effectively communicate knowledge to audiences of diverse technical abilities. Able to demonstrate complex and quantitative problem-solving skills and the ability to come up with quick and creative solutions. Strong customer service skills and a thorough knowledge of relational database theory and practice. The ability to work both independently and collaboratively with data systems teams, and Tableau and GIS experience is a plus. Enthusiastic & driven to learn Yardi Reporting.
Benefits At-a-glance
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
Salary Range: $85,000-$95,000
Grade: S8
FLSA: Exempt
Union: None
"Applications will be accepted for 30 days from the date of posting. However, the position may be closed at any point if a sufficient number of qualified applications are received.
Job Info
Job Identification 1227 Posting Date 05/20/2025, 10:35 PM Apply Before 06/20/2025, 10:00 PM Job Schedule Full time Locations 60 E. Van Buren Street, Chicago, IL, 60605, US (Hybrid) Pay Ranges 85,000 - 95,000
Similar Jobs
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Government Administration Referrals increase your chances of interviewing at Chicago Housing Authority by 2x Sign in to set job alerts for Data Analyst roles.
Chicago, IL $60,900.00-$147,000.00 4 days ago Chicago, IL $75,000.00-$95,000.00 6 days ago Chicago, IL $55,000.00-$65,000.00 3 days ago Chicago, IL $100,000.00-$200,000.00 2 weeks ago Chicago, IL $60,000.00-$121,300.00 3 days ago Quezon City, National Capital Region, Philippines 1 day ago Chicago, IL $68,000.00-$78,000.00 2 days ago SQL Reporting Analyst - Temp to Hire - Remote
Business Intelligence Analyst, Compliance, Sanctions Operations
SQL Reporting Analyst - Temp to Hire - Remote
Burr Ridge, IL $110,000.00-$130,000.00 1 day ago Niles, IL $82,453.00-$103,066.00 1 week ago Chicago, IL $66,000.00-$99,000.00 3 weeks ago Insight Data Analyst - W2 Only - Local to Chicago
Chicago, IL $66,000.00-$76,000.00 4 hours ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
The Data Analyst, is responsible for processing data into comprehensive reports, aiming to produce information that is accessible to different departments in the authority. This position is responsible for data analysis of complex data systems and documenting data elements, data flow, relationships and dependencies to support the business needs of the authority. View More Jobs
Data Analyst
Chicago, IL, United States (Hybrid)
Trending
Job Description
The Data Analyst, is responsible for processing data into comprehensive reports, aiming to produce information that is accessible to different departments in the authority. This position is responsible for data analysis of complex data systems and documenting data elements, data flow, relationships and dependencies to support the business needs of the authority.
Duties And Responsibilities
Creation & Refactoring of SQL Stored Procedures. SQL Open Query Modifications for ySQL (Yardi Internal Scripting) Ability to Manage & Update Fresh Service Ticketing System SSRS Paginated Report Updates. (Data Source + 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. Creation and management of Power BI Server Semantic Models & Architecture. Compile detailed reports using data reporting tools [Power BI, Crystal Reports, SSRS & SQL] Able to properly understand the business requirements and develop data models accordingly. Skilled in developing, publishing and scheduling Power BI reports as per the business requirements. Connecting to data sources, importing data, and transforming data into informative visuals and reports for Business Intelligence. Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Experienced in developing custom visuals for Power BI and able to implement row level security on data and understand application security layer models in Power BI. Work in partnership with business analysts, application architect, application developers to build data transactions and warehousing systems. Knowledge of data gathering, cleaning, prototyping, designing, and requirement analysis. Performs all other duties and projects as assigned.
Qualifications
Bachelors Degree in Computer Science, Software Engineering or related field, with a minimum of five (5) years hands-on experience with SSMS / SSRS/ Power BI. Masters Degree is a plus. Must have extensive knowledge in SQL Development to understand underlying data structures. Proficient with Microsoft SQL Server, familiar with one or more database query languages, such as SQL Stored Procedures or Equivalent. Must be able 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. Must have excellent verbal, oral and written communication skills, organizational and documentation skills, and be able to interface with developers, management and other ITS personnel to effectively communicate knowledge to audiences of diverse technical abilities. Able to demonstrate complex and quantitative problem-solving skills and the ability to come up with quick and creative solutions. Strong customer service skills and a thorough knowledge of relational database theory and practice. The ability to work both independently and collaboratively with data systems teams, and Tableau and GIS experience is a plus. Enthusiastic & driven to learn Yardi Reporting.
Benefits At-a-glance
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
Salary Range: $85,000-$95,000
Grade: S8
FLSA: Exempt
Union: None
"Applications will be accepted for 30 days from the date of posting. However, the position may be closed at any point if a sufficient number of qualified applications are received.
Job Info
Job Identification 1227 Posting Date 05/20/2025, 10:35 PM Apply Before 06/20/2025, 10:00 PM Job Schedule Full time Locations 60 E. Van Buren Street, Chicago, IL, 60605, US (Hybrid) Pay Ranges 85,000 - 95,000
Similar Jobs
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Government Administration Referrals increase your chances of interviewing at Chicago Housing Authority by 2x Sign in to set job alerts for Data Analyst roles.
Chicago, IL $60,900.00-$147,000.00 4 days ago Chicago, IL $75,000.00-$95,000.00 6 days ago Chicago, IL $55,000.00-$65,000.00 3 days ago Chicago, IL $100,000.00-$200,000.00 2 weeks ago Chicago, IL $60,000.00-$121,300.00 3 days ago Quezon City, National Capital Region, Philippines 1 day ago Chicago, IL $68,000.00-$78,000.00 2 days ago SQL Reporting Analyst - Temp to Hire - Remote
Business Intelligence Analyst, Compliance, Sanctions Operations
SQL Reporting Analyst - Temp to Hire - Remote
Burr Ridge, IL $110,000.00-$130,000.00 1 day ago Niles, IL $82,453.00-$103,066.00 1 week ago Chicago, IL $66,000.00-$99,000.00 3 weeks ago Insight Data Analyst - W2 Only - Local to Chicago
Chicago, IL $66,000.00-$76,000.00 4 hours ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr