Chicago Housing Authority
Chicago Housing Authority
501 – 1.000 Angajați
GuvernImobiliare
Chicago Housing Authority (CHA) este o agenție publică axată pe locuințe accesibile și asistență pentru locuire pentru rezidenții orașului Chicago. Activitatea sa include administrarea proprietăților de locuințe publice, gestionarea programului Housing Choice Voucher, întreținerea portalurilor pentru cereri și chiriași și sprijinirea rezidenților prin servicii precum programe pentru tineri, consiliere privind mobilitatea și căi către achiziționarea unei locuințe. CHA colaborează, de asemenea, la proiecte de dezvoltare a locuințelor și cartierelor și gestionează oportunități de achiziții și contractare asociate locuințelor accesibile. Echipele sale lucrează în domenii precum administrarea proprietăților, serviciile pentru rezidenți, implicarea comunității, raportarea datelor și operațiunile din sectorul public.

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.

Descriere

  • 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

Cerințe

  • 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

Beneficii

  • 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

Locuri de muncă similare

Tiger Analytics

Senior Financial Crime Compliance Business Analyst

Tiger Analytics

Bridge financial-crime compliance teams and IT at Tiger Analytics, an advanced analytics consulting firm. Define AML requirements, data mappings, monitoring rules, and user acceptance testing scenarios.

Deschide
ICF

Senior Publications Managing Editor

ICF

Lead ICF Next’s quarterly magazine from production planning through release, maintaining editorial quality and coordinating stakeholder approvals. Apply federal publishing standards, GPO and Chicago style, and Section 508 accessibility requirements.

Deschide
The Atlantic

Associate Editor, Editorial Booking — The Atlantic

The Atlantic
201 – 500 Angajați
Sponsor pentru viza H1BB2CMedia

Books high-profile interviews and guest appearances across The Atlantic’s print, digital, audio, and video platforms. Coordinates contracts, production logistics, contacts, and internal tracking.

Deschide
Vori Health

Remote Clinical Practice Manager – Tennessee

Vori Health

Manage patient support and clinical operations for Vori Health’s virtual musculoskeletal practice. Oversee scheduling, care coordination, compliance, and a remote support team.

Deschide