ZipRecruiter

Log In

1

Contract Excel Reporting Analyst Jobs in Chicago, IL

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.

Fay Servicing

Investor Reporting Analyst

Rosemont, IL · Hybrid

$31.83 - $38.65/hr

Reporting to the AVP, Investor Reporting, this position is responsible for reconciling, reporting ... 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

Ferrara

Analyst, Reporting & Consolidation

Chicago, IL · On-site

$71.10K/yr

The Analyst, Reporting & Consolidation is responsible for supporting the accurate and timely ... High proficiency in MS Excel and Office Suite What We Offer At Ferrara, we're proud to support our ...

next page

Showing results 1-20

People also search for

All JobsContract Excel Reporting Analyst JobsContract Excel Reporting Analyst Jobs in Chicago, IL

Contract Excel Reporting Analyst information

See Chicago, IL salary details

$21.1K

$83.3K

$133.4K

How much do contract excel reporting analyst jobs pay per year?

As of May 28, 2026, the average yearly pay for contract 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 are the key skills and qualifications needed to thrive as a Contract Excel Reporting Analyst, and why are they important?

To thrive as a Contract Excel Reporting Analyst, you need advanced Excel skills, strong analytical abilities, and experience with data management or reporting, often supported by a degree in business, finance, or a related field. Proficiency with Excel functions like VLOOKUP, pivot tables, macros, and possibly exposure to BI tools such as Power BI or Tableau is typically required. Attention to detail, problem-solving, and effective communication are vital soft skills for interpreting data and conveying insights to stakeholders. These competencies ensure accurate, actionable reporting that supports business decision-making and contract compliance.

What are some common challenges faced by Contract Excel Reporting Analysts when working with large datasets?

Contract Excel Reporting Analysts often encounter challenges such as managing and cleaning vast amounts of data, ensuring accuracy in complex formulas, and maintaining consistency in reporting formats. Dealing with data from multiple sources can also present compatibility issues, requiring strong problem-solving skills and attention to detail. Collaboration with stakeholders is essential to clarify requirements and ensure reports meet business needs, so effective communication is a key part of the role.

What is a Contract Excel Reporting Analyst?

A Contract Excel Reporting Analyst is a professional hired on a temporary or project basis to create, manage, and analyze data reports using Microsoft Excel. They are responsible for developing spreadsheets, automating data processes, and generating insights to support business decisions. Their work often involves cleaning and organizing data, creating dashboards, and ensuring the accuracy of reports. This role is critical for organizations that require short-term expertise in Excel without hiring a full-time employee.
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 Contract Excel Reporting Analyst jobs in Chicago, IL? For Contract Excel Reporting Analyst jobs in Chicago, IL, the most frequently searched job titles are:
What job categories do people searching Contract Excel Reporting Analyst jobs in Chicago, IL look for? The top searched job categories for Contract Excel Reporting Analyst jobs in Chicago, IL are:
What cities near Chicago, IL are hiring for Contract Excel Reporting Analyst jobs? Cities near Chicago, IL with the most Contract Excel Reporting Analyst job openings:
Contract Excel Reporting Analyst jobs near you

Reporting Analyst

Pivotal Solutions

Chicago, IL • On-site

Full-time

Posted 7 days ago

Job description

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