Chicago Housing Authority
Chicago Housing Authority
501 – 1,000 कर्मचारी
रियल एस्टेटसरकार
Chicago Housing Authority (CHA) एक सार्वजनिक एजेंसी है, जो शिकागो के निवासियों के लिए किफायती आवास और आवास सहायता पर केंद्रित है। इसके कार्यों में सार्वजनिक आवास संपत्तियों का प्रबंधन, Housing Choice Voucher कार्यक्रम का संचालन, आवेदन और किरायेदार पोर्टलों का रखरखाव, तथा युवा कार्यक्रमों, गतिशीलता परामर्श और घर का मालिक बनने के मार्ग जैसी सेवाओं के माध्यम से निवासियों की सहायता शामिल है। CHA आवास और पड़ोस के विकास से जुड़ी परियोजनाओं में भी सहयोग करती है और किफायती आवास से संबंधित खरीद तथा अनुबंध के अवसरों का प्रबंधन करती है। इसकी टीमें संपत्ति प्रबंधन, निवासी सेवाओं, सामुदायिक सहभागिता, डेटा रिपोर्टिंग और सार्वजनिक क्षेत्र के संचालन सहित विभिन्न क्षेत्रों में काम करती हैं।

Data Analyst - SQL and Power BI | Chicago Housing Authority

The Chicago Housing Authority is seeking a Data Analyst to develop SQL, SSRS, and Power BI reporting. The role builds data models, dashboards, and automated reporting solutions for authority departments.

विवरण

  • Turn data into comprehensive reports and accessible information for authority departments
  • Analyze complex data systems and document data elements, flows, relationships, and dependencies
  • Create and refactor SQL stored procedures
  • Improve internal SQL scripts through performance tuning
  • Modify SQL Open Queries for ySQL, Yardi’s internal scripting environment
  • Administer and maintain the FreshService ticketing system
  • Update SSRS paginated reports, including data sources and datasets through stored procedures
  • Design, develop, test, and deploy Power BI reports for development and administration
  • Build reusable, automated database extraction routines with documented business logic, dependencies, and source control
  • Create and maintain Power BI Server semantic models and architecture
  • Apply measures, calculated columns, variables, and optimization methods
  • Use DAX and Power Query to model fact and dimension tables
  • Produce detailed reports with Power BI, Crystal Reports, SSRS, and SQL
  • Translate business requirements into corresponding data models
  • Develop, publish, and schedule Power BI reports
  • Connect to data sources and import and transform information into Business Intelligence visuals and reports
  • Embed Power BI reports in other applications through embedded analytics, Power BI service, or API automation
  • Create custom Power BI visuals and implement row-level and application security models
  • Work with business analysts, application architects, and developers on data transaction and warehousing systems
  • Conduct data gathering, cleaning, prototyping, design, and requirements analysis
  • Handle other assigned duties and projects

आवश्यकताएँ

  • Bachelor’s degree in computer science, software engineering, or a related discipline
  • At least five years of hands-on experience with SSMS, SSRS, and Power BI
  • Extensive knowledge of SQL development and underlying data structures
  • Proficiency with Microsoft SQL Server
  • Familiarity with SQL stored procedures or equivalent database query languages
  • Ability to collaborate with management, users, peers, and stakeholders on report, user, technical, solution design, architecture, and delivery requirements under CHA reporting specifications
  • Excellent verbal, oral, and written communication skills
  • Strong organization and documentation abilities
  • Ability to communicate with developers, management, and ITS personnel and explain technical concepts to audiences with varied technical backgrounds
  • Advanced complex and quantitative problem-solving ability
  • Strong customer service skills
  • Thorough understanding of relational database theory and practice
  • Ability to work independently and collaboratively with data systems teams
  • Tableau and GIS experience is a plus
  • Interest in learning Yardi Reporting

लाभ

  • Vacation, sick, and personal leave with a competitive PTO package
  • Medical coverage including HMO, PPO, and an employee-cost-free high-deductible PPO, plus dental, vision, and life insurance
  • Short- and long-term disability insurance
  • Long-term care insurance
  • Pet insurance
  • Parking and transit benefits
  • Prepaid legal services
  • Brightstar 529 College Savings Plan
  • Identity theft protection
  • Hospital indemnity insurance
  • Voluntary critical illness insurance
  • Deferred compensation plan through Empower 457/401(a), including a 3% employer match
  • Pension plan with CHA contributions and a required 3% employee contribution; 100% vesting follows six years of continuous employment
  • Hybrid work schedule, depending on the position
  • Potential eligibility for remote work after successfully completing a 90-day probationary period under CHA policies and procedures

संबंधित नौकरियाँ

Core BTS

Client Advocate Manager - Philadelphia Hybrid

Core BTS

Partner with Account Managers to co-sell technology solutions, build pipeline, and develop strategic customer and partner relationships. The role combines prospect research, sales coordination, account planning, and customer engagement.

खोलें
Autodesk

Senior Customer Advocate, AECO Customer Reliability – Autodesk Hybrid

Autodesk

Lead Autodesk’s customer reliability efforts for AECO products by turning customer insights into prioritized action. Partner across Product, Engineering, Support, and other teams to improve reliability, productivity, sentiment, and technical readiness.

खोलें
Graphic Packaging International, LLC

Customer Advocate III - Onsite in Kalamazoo, Michigan

Graphic Packaging International, LLC

Customer Advocate III supporting strategic global packaging accounts for Graphic Packaging International. The role coordinates order management, logistics, planning, and customer service across manufacturing operations.

खोलें
Rackspace Technology

Senior Technical Evangelist, AI Infrastructure and GPU Technologies

Rackspace Technology

Lead technical evangelism for Rackspace Technology’s GPUaaS business through partner enablement, technical education, and industry thought leadership. Represent AI infrastructure and GPU technologies in events, customer forums, and technical discussions.

खोलें
Equinix

Senior Director, Developer Experience — Equinix (Redwood City, Hybrid)

Equinix

Lead Equinix’s developer platform, IDE integrations, AI coding copilots, and quality engineering standards. Improve developer velocity across global digital infrastructure operations.

खोलें
Autodesk

Autodesk Customer Advocate, Design & Manufacturing

Autodesk

Improve the reliability of Autodesk’s design and manufacturing software by turning customer intelligence into product, engineering, and scalable support actions. Connect recurring customer issues with strategic decisions and measurable resolution.

खोलें
Graphic Packaging International, LLC

Customer Advocate II (Onsite) – Lancaster, Texas

Graphic Packaging International, LLC

Manage filter-frame customer accounts, orders, inventory, and service issues for Graphic Packaging International, a paperboard packaging manufacturer. Coordinate with sales, logistics, planning, and manufacturing teams to support reliable order fulfillment.

खोलें
Benco Dental

Regional Sales Manager, Customer Advocate - Benco Dental (Michigan Remote)

Benco Dental

Lead regional sales, branch operations, and customer advocacy for Benco Dental, the largest privately owned full-service dental distributor in the United States. Manage sales teams, service quality, logistics, and customer relationships across an assigned Michigan territory.

खोलें
Graphic Packaging International, LLC

Customer Advocate II – Sturgis, Michigan

Graphic Packaging International, LLC

Support packaging customers after purchase by resolving issues and coordinating orders. Partner with production and distribution teams at Graphic Packaging International.

खोलें
Motorola Solutions