Data Analyst

Role Overview

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.

What You Will Do

Creation & Refactoring of SQL Stored Procedures, Optimizing internal SQL scripts via performance tuning methods, Design, Develop, Test, and Deploy reports for Power BI development and administration, Developing automated and reusable routines for extracting requested information from database system, Creation and management of Power BI Server Semantic Models & Architecture.

Why It Might Be a Fit

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.

Requirements

• Bachelor’s Degree in Computer Science, Software Engineering or related field
• Minimum of five (5) years hands-on experience with SSMS / SSRS/ Power BI
• 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
• Excellent verbal, oral and written communication skills, organizational and documentation skills
• Ability to demonstrate complex and quantitative problem-solving skills and the ability to come up with quick and creative solutions

Benefits

• 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

Tagged as: Data Analysis