ZipRecruiter

Log In

1

Excel Reporting Analyst Jobs in Chicago, IL (NOW HIRING)

Pivotal Solutions

Reporting Analyst

Chicago, IL · On-site

About the Role The Reporting Analyst will partner with key stakeholders to build data structures ... Advanced knowledge of MS Excel and various delimited text file formats for data movement.

US Bank

Trust Reporting Analyst

Chicago, IL · On-site

Try new things, learn new skills and discover what you excel at-all from Day One. U.S. Bank Global ... These services include Trust Reporting, which requires review of the deal documents, set up of ...

Covista

Clinical Reporting Analyst

Lisle, IL · On-site

The Clinical Reporting Analyst is responsible for generating and delivering a variety of critical ... Advanced proficiency in Microsoft Excel is mandatory. * Prior experience working with Salesforce ...

Covista

Clinical Reporting Analyst

Lisle, IL · Hybrid

The Clinical Reporting Analyst is responsible for generating and delivering a variety of critical ... Advanced proficiency in Microsoft Excel is mandatory. * Prior experience working with Salesforce ...

Trustmark

Business Reporting Analyst

Lake Forest, IL · On-site

Produce standard and custom client and broker level reports, utilizing Salesforce, Microsoft Excel ... Excellent analytical skills, including the ability to examine data for meaningful relationships.

Walgreens

Senior Reporting Analyst

Deerfield, IL · On-site

$89K - $118K/yr

Strong working knowledge of Microsoft Office tools including Word, Excel, Visio, PowerPoint and ... Query / analytics / reporting tools such as: SAS, R, SQL, Hadoop, Teradata * In-depth knowledge of ...

Fay Servicing

Investor Reporting Analyst II

Rosemont, IL · Hybrid

$35.57 - $49.87/hr

Reporting to the AVP, Investor Reporting, this position is responsible for managing complex ... Solid skills and experience in MS Word, Excel to compile and analyze data, PowerPoint and Outlook

ITW

Analyst/Sr Analyst- Management Reporting

Glenview, IL · Hybrid

$74K - $88K/yr

The Management Reporting group provides timely and effective management reporting, issuing accurate ... Proficient with key financial applications, including Excel, experience with Oracle HFM a plus

next page

Showing results 1-20

All JobsExcel Reporting Analyst JobsExcel Reporting Analyst Jobs in Chicago, IL

Excel Reporting Analyst information

See Chicago, IL salary details

$21.1K

$83.3K

$133.4K

How much do excel reporting analyst jobs pay per year?

As of Aug 30, 2026, the average yearly pay for excel reporting analyst in Chicago, IL is $83,300.00, according to ZipRecruiter salary data. Most workers in this role earn between $63,900.00 and $102,000.00 per year, depending on experience, location, and employer.

What is an Excel Reporting Analyst?

An Excel Reporting Analyst is responsible for gathering, analyzing, and presenting data using Microsoft Excel. They create reports, dashboards, and data visualizations to support business decision-making. Their role involves working with large datasets, applying formulas, and using advanced Excel functions like pivot tables, VLOOKUP, and macros. They collaborate with teams to ensure data accuracy and optimize reporting processes. Strong analytical skills and attention to detail are essential for this role.

What are the key skills and qualifications needed to thrive as an Excel Reporting Analyst?

To thrive as an Excel Reporting Analyst, you need advanced proficiency in Excel, strong analytical abilities, and a background in data analysis or a related field. Experience with reporting tools (such as Power BI or Tableau), VBA for automation, and familiarity with databases or SQL are highly valued, and certifications like Microsoft Excel Expert can be beneficial. Excellent attention to detail, problem-solving skills, and clear communication help analysts deliver accurate reports and collaborate effectively with stakeholders. Together, these abilities ensure high-quality data analysis, efficient reporting, and persuasive data-driven insights within an organization.

What are some typical challenges faced by Excel Reporting Analysts in their daily work?

Excel Reporting Analysts often deal with large, complex data sets that require meticulous attention to detail to ensure accuracy and consistency. One common challenge is managing tight deadlines while addressing last-minute data requests or changes in reporting requirements. They also need to effectively communicate findings to both technical and non-technical stakeholders, which involves simplifying complex data insights. Overcoming these challenges helps analysts add significant value through reliable, actionable business reports.

What are the most commonly searched types of Excel Reporting Analyst jobs in Chicago, IL?

The most popular types of Excel Reporting Analyst jobs in Chicago, IL are:

What are popular job titles related to Excel Reporting Analyst jobs in Chicago, IL?

For Excel Reporting Analyst jobs in Chicago, IL, the most frequently searched job titles are:

What job categories do people searching Excel Reporting Analyst jobs in Chicago, IL look for?

The top searched job categories for Excel Reporting Analyst jobs in Chicago, IL are:

Excel Reporting Analyst jobs near you
Infographic showing various Excel Reporting Analyst job openings in Chicago, IL as of August 2026, with employment types broken down into 1% As Needed, 79% Full Time, 16% Part Time, 3% Contract, and 1% Nights. Highlights an 88% Physical, 4% Hybrid, and 8% Remote job distribution, with an average salary of $83,300 per year, or $40 per hour.

Reporting Analyst

Pivotal Solutions

Chicago, IL • On-site

Full-time

Re-posted 11 days ago

Job description


About the Role
The Reporting Analyst will partner with key stakeholders to build data structures and processes to produce meaningful and actionable organizational reporting. This person will need to be able to extract and manipulate data from many different sources to provide a standardized and cohesive view of data to institutional leadership. This position will monitor data sources to enforce best practices and business rules to promote data integrity for all reports. The Reporting Analyst will play a critical role in defining and enabling the organizational data strategy.
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.

Apply