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

Ұқсас жұмыс орындары

FloQast

Technical Engineering Manager, Core AI

FloQast

Lead India-based engineering teams building production AI for FloQast’s accounting automation platform. Guide RAG, agentic workflows, LLMOps, and collaboration across global teams.

Ашу
Parexel

Senior Clinical Research Associate, Contractor – Australia

Parexel

Monitor clinical trial sites across Australia for Parexel, overseeing protocol compliance, data quality, documentation, and trial deliverables. This contractor role covers site activities from study initiation through closeout.

Ашу
Integrators services a.s.

Senior Data Engineer – Teradata, Informatica and Databricks

Integrators services a.s.

Design data warehouse solutions for Komerční banka subsidiaries, build Teradata and Informatica integrations, and support migration to Databricks.

Ашу
Ness Digital Engineering

Senior Data Engineer – Ness Digital Engineering (Hybrid, India)

Ness Digital Engineering
1 001 – 5 000 Қызметкерлер
B2BЖасанды интеллектКонсалтинг

Build scalable data pipelines with Python and Spark at Ness Digital Engineering. Develop data-platform solutions using AWS, Databricks, and Snowflake.

Ашу
Capgemini

Junior Claims Operations Specialist – Capgemini, Pune

Capgemini

Provide back-office claims support at Capgemini, handling data entry, documents, and routine reports. Coordinate claims processing with internal teams in Pune.

Ашу
Qureight

Senior Clinical Data Manager, Imaging

Qureight

Lead imaging data quality, sponsor transfers and user acceptance testing for Qureight’s AI-powered clinical trial platform. Oversee DICOM quality control and clinical data processes while supporting junior team members.

Ашу
CDW
MSD

Senior Principal Scientist, Breast Cancer Clinical Research

MSD

Lead clinical research and drug development programs focused on breast cancer at Merck. Design trials, assess findings, and guide cross-functional oncology development.

Ашу
University Hospitals

Clinical Research Assistant, Harrington Heart & Vascular Institute

University Hospitals

Supports clinical trials at Harrington Heart & Vascular Institute through study documentation, participant recruitment and visits, and research sample processing.

Ашу