ZipRecruiter

Log In

1

Contract Excel Reporting Analyst Jobs in Springfield, MA

L3HHCM20

Lead, Contracts Manager

Northampton, MA

$110K - $205K/yr

... contract records management and reporting. * Coordinate all essential activity with legal Counsel ... Ability to identify and analyze problems; use sound reasoning to reach conclusions; find ...

Baystate Health

Senior Financial Analyst

Springfield, MA · Hybrid

$85K - $106K/yr

Design and enhance financial reporting tools and dashboards that improve visibility into practice ... Advanced proficiency with Microsoft Excel and Microsoft Office applications. * Excellent ...

Baystate Health

Senior Financial Analyst

Springfield, MA · On-site

$85K - $106K/yr

Design and enhance financial reporting tools and dashboards that improve visibility into practice ... Advanced proficiency with Microsoft Excel and Microsoft Office applications. * Excellent ...

previous pagenext page

Showing results 21-40

All JobsContract Excel Reporting Analyst JobsContract Excel Reporting Analyst Jobs in Springfield, MA

Contract Excel Reporting Analyst information

See Springfield, MA salary details

$20.4K

$80.6K

$129K

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

As of Aug 14, 2026, the average yearly pay for contract excel reporting analyst in Springfield, MA is $80,579.00, according to ZipRecruiter salary data. Most workers in this role earn between $61,800.00 and $98,700.00 per year, depending on experience, location, and employer.

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 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 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 cities near Springfield, MA are hiring for Contract Excel Reporting Analyst jobs?

Cities near Springfield, MA with the most Contract Excel Reporting Analyst job openings:

Contract Excel Reporting Analyst jobs near you
Infographic showing various Contract Excel Reporting Analyst job openings in Springfield, MA as of August 2026, with employment types broken down into 75% Full Time, and 25% Part Time. Highlights an 100% In-person job distribution, with an average salary of $80,579 per year, or $38.7 per hour.

Sr. Financial Analyst, Revenue and Reimbursement - 40hrs

Connecticut Children's

Hartford, CT • On-site

$86K - $107K/yr

Full-time

Posted 15 days ago

Connecticut Children's Medical Center rating

7.7

Company rating: 7.7 out of 10

Based on 45 frontline employees who took The Breakroom Quiz

220th of 1,059 rated hospitals

Job description


The Sr. Financial Analyst, Revenue and Reimbursement is responsible for monthly, quarterly, and annual revenue analysis and reporting across all hospital and specialty group departments for both Connecticut Children's Medical Center (CCMC) and Connecticut Children's Specialty Group (CCSG). The role manages State and Federal reporting requirements, directs support for DSH and other audits, and ensures revenue is recognized in accordance with contracted terms through the month-end close process. The Sr. Financial Analyst analyzes payer, physician, and patient payment information against applicable contract terms, government regulations, and internal policies, and supports annual revenue budgeting and forecasting. Work is performed under general supervision in close collaboration with Financial Planning and Financial Analysts across the department.
Responsibilities
Revenue Analysis & Reporting-40%
  • Prepares monthly, quarterly, and annual revenue analysis and reporting across all hospital and specialty group departments.
  • Ensures revenue recognized for CCMC and CCSG through the month-end close process is in accordance with contracted terms for services rendered.
  • Demonstrates technical knowledge of generally accepted revenue recognition standards specific to the hospital industry.
  • Analyzes incoming payment information and communications from payers, physicians, and patients in conjunction with applicable contract terms, reimbursement schedules, government regulations, and internal policies.
  • Identifies and investigates revenue variances; prepares written analysis and presents findings to leadership as needed.
  • Monitors payer contract performance and identifies opportunities for revenue optimization or recovery.
  • Develops productive relationships across Finance departments, including Revenue Cycle, Financial Operations, Financial Reporting, and Contract Management.

Budgeting & Forecasting-20%
  • Supports the annual revenue budget process, including preparation of supporting schedules and documentation.
  • Provides regular updates to revenue forecasts, incorporating changes in payer mix, utilization trends, contract terms, and regulatory developments.
  • Supports new business initiatives with revenue expectations and scenario modeling.

Reimbursement & Compliance-10%
  • Assists with establishing physician fee schedules by CPT codes for each cost center and department.
  • Supports reimbursement analysis and regulatory compliance monitoring.
  • Ensures all actions are consistent with applicable government regulations, contractual terms, and internal policies and procedures.
  • Maintains current knowledge of changes to CMS regulations, state Medicaid policy, and managed care reimbursement methodologies.

State & Federal Reporting Requirements-20%
  • Completes the following requirements in a timely manner:
  • CMS Annual Cost Report.
  • Connecticut Hospital Association Surveys.
  • Children's Hospital Association Surveys.
  • DSH Survey.
  • OHS Annual Filing and OHS 12 Month Filing.
  • CHGME Grant:
    • Initial Application.
    • FTE Documentation.
    • Reconciliation Application.
    • Annual Report Facilitation.

Audit Support-10%
  • Directs the preparation of support materials related to DSH audits and other audit requirements as needed.
  • Coordinates with internal departments and external auditors to ensure timely and accurate responses to audit inquiries.

Performs Other Duties as Assigned.
Qualifications
Education and/or Experience Required:
  • Education: Bachelor's degree from accredited college or university.
  • Experience: 5 years' experience in Healthcare Revenue Cycle or Healthcare Finance departments.

License and/or Certification Required:
  • N/A

Knowledge, Skills and Abilities:
Knowledge:
  • ICD-10, CPT coding, and medical terminology.
  • Insurance regulations and reimbursement policies, including managed care, Medicare, and Medicaid.
  • Generally accepted revenue recognition standards specific to the hospital industry.
  • State and Federal reporting requirements applicable to healthcare finance.
  • CMS cost report methodology and DSH program requirements.
  • Healthcare financial management principles, including budgeting and forecasting.
  • Microsoft Word and Excel; experience with healthcare financial systems preferred.

Skills:
  • Strong analytical and financial modeling skills with a high degree of accuracy and attention to detail.
  • Proficiency in data analysis, variance reporting, and revenue reconciliation.
  • Excellent written and verbal communication skills, including the ability to present financial data clearly to varied audiences.
  • Strong organizational and project management skills with the ability to manage multiple deadlines simultaneously.
  • Ability to develop and maintain effective working relationships across departments.

Abilities:
  • Ability to interpret and apply complex regulatory requirements, payer contracts, and internal policies.
  • Ability to work independently under general supervision while exercising sound judgment.
  • Ability to identify problems, analyze root causes, and recommend practical solutions.
  • Ability to adapt to changing priorities in a dynamic healthcare environment.
  • Commitment to maintaining strict confidentiality of all financial and patient-related information.

About Us
Connecticut Children's is the only health system in Connecticut that is 100% dedicated to children. Established on a legacy that spans more than 100 years, Connecticut Children's offers personalized medical care in more than 30 pediatric specialties across Connecticut and in two other states. Our transformational growth establishes us as a destination for specialized medicine and enables us to reach more children in locations that are closer to home. Our breakthrough research, superior education and training, innovative community partnerships, and commitment to diversity, equity and inclusion provide a welcoming and inspiring environment for our patients, families and team members.
At Connecticut Children's, treating children isn't just our job - it's our passion. As a leading children's health system experiencing steady growth, we're excited to expand our team with exceptional team members who share our vision of transforming children's health and well-being as one team.

What Connecticut Children's Medical Center employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom

Apply