Data Analyst

• 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.
• Optimizing internal SQL scripts via performance tuning methods.
• 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 system, while providing documentation & source control for
• business logic and dependencies.

• Creation and management of Power BI Server Semantic Models & Architecture.
• Strong understanding of measures, calculated columns, variables, and

optimization.

• Utilization of Dax/ Power Query to data model fact & dimension tables.
• 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

• Bachelor’s Degree in Computer Science, Software Engineering or related field,
• with a minimum of five (5) years hands-on experience with SSMS / SSRS/ Power BI.
• Master’s 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

• Hybrid work schedule (position specific) This position may be eligible for

• remote work following a successful completion of a 90-day probationary period
• according to CHA’s established policies and procedures.

• "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."

Salary Range: $85,000-$95,000

Grade: S8

FLSA: Exempt

Union: None