ZipRecruiter

Log In

1

Contract Excel Reporting Analyst Jobs in Kansas (NOW HIRING)

KeyBank

Investor Reporting Analyst

Overland Park, KS · On-site

$63K - $96K/yr

Review, communicate, and set up new contracts in core systems including Strategy Investor Setup ... Use of advanced Excel functions for ad-hoc reporting and financial analysis * Mentoring peers and ...

Keybank

Investor Reporting Analyst

Overland Park, KS

$63K - $96K/yr

Review, communicate, and set up new contracts in core systems including Strategy Investor Setup ... Use of advanced Excel functions for ad-hoc reporting and financial analysis * Mentoring peers and ...

Starr Insurance Companies

... reports ... The ideal candidate will demonstrate strong data analysis skills, advanced Excel proficiency ...

SitusAMC

AVP, Investor Reporting

Overland Park, KS · On-site

$85K - $100K/yr

... excel formulas, data tables and macros, to analyze the loan metrics, cash flows, amortization ... reporting * High comfort level with use of various industry related software systems * Strong ...

Icon plc

$59K - $71K/yr

As a Contract Analyst I at ICON, you will prepare, verifying, and carrying out invoicing via electronic processing and reporting activities for an assigned portfolio of accounts. What You Will Do:

Icon plc

$59K - $71K/yr

As a Contract Analyst I at ICON, you will prepare, verifying, and carrying out invoicing via electronic processing and reporting activities for an assigned portfolio of accounts. What You Will Do:

pcg

Corporate Contracts Analyst II

Lenexa, KS · On-site

$69K - $92K/yr

Track and report status of contract negotiations. * Train internal employees on contract ... Strong analytical and critical thinking skills. * Excellent written and oral communication skills.

pcg

Corporate Contracts Analyst II

Lenexa, KS · On-site

$69K - $92K/yr

Track and report status of contract negotiations. * Train internal employees on contract ... Strong analytical and critical thinking skills. * Excellent written and oral communication skills.

Varsity Tutors

Microsoft Excel Tutor

Wichita, KS · Remote

$18 - $40/hr

Ability to explain cell referencing, formula nesting, and data analysis workflows while preparing ... Varsity Tutors does not contract in: Alaska, California, Colorado, Delaware, Hawaii, Maine, New ...

Varsity Tutors

Microsoft Excel Tutor

Overland Park, KS · Remote

$18 - $40/hr

Ability to explain cell referencing, formula nesting, and data analysis workflows while preparing ... Varsity Tutors does not contract in: Alaska, California, Colorado, Delaware, Hawaii, Maine, New ...

Advisors Excel

Life Reporting Intern

Topeka, KS · On-site

$13 - $17.25/hr

Data analytics and reporting for our campaigns and initiatives * Maintaining the life reporting ... Strong knowledge of MS Office, including Word, Excel, PowerPoint and Outlook * Ability to ...

Advisors Excel

Life Reporting Intern

Topeka, KS · On-site

$14 - $18.75/hr

Data analytics and reporting for our campaigns and initiatives * Maintaining the life reporting ... Strong knowledge of MS Office, including Word, Excel, PowerPoint and Outlook * Ability to ...

next page

Showing results 1-20

All JobsContract Excel Reporting Analyst JobsContract Excel Reporting Analyst Jobs in Kansas

Contract Excel Reporting Analyst information

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 key skills and qualifications needed to thrive as a contract Excel reporting analyst?

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 cities in Kansas are hiring for Contract Excel Reporting Analyst jobs?

Cities in Kansas with the most Contract Excel Reporting Analyst job openings:

Contract Excel Reporting Analyst jobs near you

Investor Reporting Analyst

KeyBank

Overland Park, KS • On-site

$63K - $96K/yr

Full-time

Re-posted 17 days ago

KeyBank rating

8.2

Company rating: 8.2 out of 10

Based on 99 frontline employees who took The Breakroom Quiz

52nd of 172 rated banks

Job description

Location:
11501 Outlook Street, Overland Park Kansas
Job Summary
Under the supervision of the department manager, the Investor Accounting Analyst III is responsible for accurate and timely reporting and remitting as dictated by the related servicing agreements for assigned contracts. In addition to standard Investor Analyst responsibilities, this role handles more complex and potentially labor-intensive manual calculations for deals such as Participation, Third-Party, and CMBS contracts.
Essential Functions
  • Perform all functions of an Investor Analyst II
  • Interpret Pooling and Servicing Agreements (PSA), Sub-Servicing Agreements (SSA), Interim Servicing Agreements (ISA), Participation Agreements, and other complex third-party agreements to determine portfolio reporting and remittance requirements and respond to investor inquiries
  • Review, communicate, and set up new contracts in core systems including Strategy Investor Setup, Collection Account Setup, RECWEB Investor Summary/Calendar Setup, and Trustee File Setup
  • Resolve servicing fee and other validation exceptions
  • Monitor calculation and reporting of Realized Losses, Appraisal Reduction Amounts (ARA), and Appraisal Subordinate Entitlement Reductions (ASERS)
  • Provide advice, oversight, and assistance to management in identifying, managing, and escalating risk issues
  • Communicate with Rating Agencies, Trustees, and Investors, ensuring confidentiality documents are current and on file
  • Exceed performance goals and consistently push self and others for results
  • Assist in the development and training of new employees
  • Support peers with reconcilement issues and questions
  • Participate in special projects, including testing phases of system upgrades and enhancements
  • Contribute to team development and team building initiatives
  • Performs other duties as assigned; duties, responsibilities and/or activities may change or new ones may be assigned at any time with or without notice
  • Complies with all KeyBank policies and procedures, including without limitation, acting professionally at all times, conducting business ethically, avoiding conflicts of interest, and acting in the best interests of Key's clients and Key.

Education
  • Bachelor's Degree in Finance or Accounting (preferred)
  • OR equivalent experience (required)

Work Experience
  • 1+ years of investor reporting or related experience within the industry, with emphasis in loan servicing or commercial real estate reporting (preferred)

Skills
  • Preparation and validation of complex investor reports and remittances per servicing agreements
  • Analysis of PSAs, SSAs, ISAs, and third-party contracts to determine reporting requirements
  • Configuration of investor and trustee data in systems like Strategy and RECWEB
  • Execution of labor-intensive calculations for specialized contracts such as CMBS and Participation deals
  • Resolution of exceptions and discrepancies in servicing fee calculations
  • Monitoring and reporting of Realized Losses, ARAs, and ASERS for investor portfolios
  • Identification and escalation of risk issues to ensure compliance and operational integrity
  • Professional interaction with rating agencies, trustees, investors, and internal teams
  • Use of advanced Excel functions for ad-hoc reporting and financial analysis
  • Mentoring peers and assisting with reconcilement and procedural questions
  • Onboarding and development of new employees through knowledge sharing
  • Participation in testing phases of system upgrades and enhancements
  • Recommendation and implementation of changes to investor reporting procedures
  • Ability to manage multiple tasks and deadlines with precision and efficiency
  • Commitment to delivering high-quality service and maintaining confidentiality

Core Competencies
  • All KeyBank employees are expected to demonstrate Key's Values and abide by Key's Code of Conduct.

Physical Demands
  • General Office - Prolonged sitting, ability to communicate face to face in person or on the phone with teammates and clients, frequent use of PC/laptop, occasional lifting/pushing/pulling of backpacks, computer bags up to 10 lbs.

Travel
  • Occasional travel to include overnight stay.

Work Location Category
  • Hybrid (2+ days)

COMPENSATION AND BENEFITS
This position is eligible to earn a base salary in the range of $63,000.00 - $96,000.00 annually. Placement within the pay range may differ based upon various factors, including but not limited to skills, experience and geographic location. Compensation for this role also includes eligibility for incentive compensation which may include production, commission, and/or discretionary incentives.
Please click here for a list of benefits for which this position is eligible.
Key has implemented an approach to employee workspaces which prioritizes in-office presence, while providing flexible options in circumstances where roles can be performed effectively in a mobile environment.
Job Posting Expiration Date: 10/08/2026KeyCorp is an Equal Opportunity Employer committed to sustaining an inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, pregnancy, disability, veteran status or any other characteristic protected by law.
Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by emailing HR_Compliance@keybank.com.
#LI-Hybrid

What KeyBank employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom

KeyBank logo

About KeyBank

Sourced by ZipRecruiter

Key is one of the nation's largest bank-based financial services companies. Key provides deposit, lending, cash management, insurance, and investment services to individuals and businesses in 15 states under the name KeyBank National Association through a network of more than 1,200 branches and more than 1,500 ATMs. Key also provides a broad range of sophisticated corporate and investment banking products, such as merger and acquisition advice, public and private debt and equity, syndications, and derivatives to middle market companies in selected industries throughout the United States under the KeyBanc Capital Markets trade name.

Industry

Banking and credit intermediation

Company size

10,000+ Employees

Headquarters location

Cleveland, OH, US

Year founded

1849

View All KeyBank Jobs

Apply