Reporting Analyst

Pivotal Solutions; Chicago (IL); Hybrid; USD 70,000 - 90,000; Full time

Job summary

A leading solutions provider is seeking a Data Analyst in Chicago, IL, to design reports and manage data integrity while utilizing tools like Power BI and SQL. The ideal candidate has a Bachelor's in Computer Science, with strong SQL and ETL skills, alongside excellent communication abilities. This position offers the opportunity to work remotely part of the week and values a collaborative team spirit, professionalism, and data security.

Qualifications

• Intermediate knowledge of MS Power BI.
• Excellent SQL skills are required.
• Ability to create and maintain basic ETL scripts.
• Advanced knowledge of MS Excel for data movement.

Responsibilities

• Design and maintain data views for reports.
• Assist users in building ad-hoc reports.
• Monitor ETL processes for data population.
• Document data structures in data dictionaries.

Skills

MS Power BI

Structured Query Language

ETL scripting

MS SQL Server Management Studio

MS Excel

Data Visualization

Communication Skills

Collaboration

Education

Bachelor’s Degree in Computer Science or related fields

Job description

Chicago, United States | Posted on 02/09/2026

Location:

Chicago (Loop) with ability to work remotely part of each week

Department:

Shared Services — Information Services

Reports To:

Vice President of Information Services

FLSA Status:

Exempt

Primary Responsibilities:

• Design and maintain data views needed for requested reports.
• Assist power users with utilization of data views to produce their own ad-hoc reports.
• Build and maintain advanced reports as requested by end-users.
• Create and monitor extract/transform/load processes used in database population and application integrations.
• Document all data structures, relationships, and attributes in organizational data dictionaries.
• Identify and report data integrity issues across data sources to promote ongoing data quality.
• Assist Information Services staff with making data visualizations available on other platforms such as the organization’s intranet.
• Utilize the department ticketing system to obtain position-related end-user support requests, and work with the users to resolve their issues.
• Perform other duties as assigned.

Required Qualifications:

• Intermediate knowledge of MS Power BI.
• Excellent structured query language skills.
• Ability to create and maintain basic ETL scripts.
• Working knowledge of MS SQL Server management studio environment.
• Ability to create thorough documentation for maintenance and end-user training.
• Advanced knowledge of MS Excel and various delimited text file formats for data movement.
• Demonstrates a collaborative spirit and values team goals above personal contributions.
• Ability to be self-motivated for constant improvement/optimization of existing processes.
• Demonstrates passion for showcasing advanced capabilities of existing tools.
• Ability to perform the role with the utmost integrity including maintaining the privacy and protection of institutional data.
• Excellent verbal and written communication skills, and comfortable communicating in-person as well as through video conferencing.

Preferred Qualifications:

• Experience using Power BI to design high impact visualizations on board-level reports.
• Knowledge of SharePoint integrations with Power BI.
• Advanced knowledge of MS SQL Server table/query optimization and complex ETL scripting.
• Experience with accessing data from a variety of cloud hosted applications.
• Knowledge of reporting tool utilization in an MS Azure environment.
• Industry or role-related certifications.
• Prior experience working in health care or academic settings.

Physical Requirements:

• Prolonged periods of sitting at a desk and working on a computer.

Education/Experience:

• Bachelor’s Degree in Computer Science, Business, Management or other related fields, or equivalent work experience preferred.
• 2 years of work experience performing similar duties.