STATE CONTRACT REPORTING ANALYST

Experience - 4 to 7 years

Department: Pricing / Contract Management
Role: State Contract Reporting Analyst
Industry: IT Products, Distribution & Government Contracts

Job Summary

We are seeking a detail-oriented State Contract Reporting Analyst to support contract reporting, transaction reconciliation, pricing compliance, and administrative fee reporting. This role is important to maintaining accurate contract records, preparing timely sales reports, validating transaction data, and coordinating with internal teams to resolve discrepancies. The successful candidate will maintain supporting documentation, track reporting deadlines and outstanding actions, and support audit and month-end close activities.

Key Responsibilities Transaction Tracking and System Updates

· Review and track sales and contract-related transactions for state and cooperative purchasing contracts, including NASPO ValuePoint, TIPS, BuyBoard, Carahsoft, and other applicable programs.

· Extract, consolidate, and update transaction details from purchase orders, invoices, Power BI, and ConnectWise, ensuring records are complete, accurate, and current.

· Monitor outstanding transactions, missing information, reporting exceptions, and aging items; follow up with relevant teams and escalate unresolved issues as needed.

Reconciliation and Documentation

· Reconcile sales and transaction data against purchase orders, invoices, contract records, and supporting documentation before reporting or submission.

· Investigate discrepancies, duplicate or missing transactions, pricing variances, and documentation gaps; coordinate corrective action with the appropriate stakeholders.

· Maintain complete and organized contract-specific records, sales reports, fee statements, submission confirmations, and payment support to facilitate audit requests and compliance reviews.

· Support month-end and periodic close activities by reviewing outstanding transactions, validating report data, and following up on unresolved items.

Contract Pricing and Administrative Fee Coordination

· Review transaction pricing against contract price lists, discount structures, contract terms, and Not-to-Exceed (NTE) requirements; flag discrepancies for review and resolution.

· Calculate and validate administrative fees based on applicable contract terms and reported sales.

· Prepare administrative fee statements, track payment status and pending approvals, and coordinate follow-up with Finance and other responsible teams.

Reporting, Controls, and Process Improvement

· Prepare and maintain periodic contract sales reports and Excel-based trackers covering reported sales, outstanding transactions, administrative fees, exceptions, and submission status.

· Use Excel features such as PivotTables, lookup formulas, and SUMIFS, along with Power BI dashboards, to validate data and monitor reporting activity.

· Track monthly and quarterly reporting deadlines, pending approvals, and outstanding actions to support timely completion of contract obligations.

· Follow established procedures and internal controls when handling commercial, contract, and financial information; maintain accurate records to support audit readiness.

· Identify recurring data-quality issues and recommend workflow improvements that increase reporting accuracy, consistency, and efficiency.

Coordination and Communication

· Coordinate with Pricing, Finance, Sales Operations, Accounts Receivable, Accounts Payable, and Contract Management to resolve transaction, invoice, pricing, and reporting discrepancies.

· Respond to internal inquiries, provide status updates, and communicate outstanding issues, required actions, and expected resolution timelines.

· Collaborate across teams to ensure accurate reporting, timely follow-up, and adherence to agreed service levels and deadlines.

Qualifications

· Bachelor’s degree in Commerce, Business Administration, Finance, Supply Chain Management, or a related discipline preferred.

· Relevant experience in contract reporting, transaction reconciliation, pricing support, sales operations, finance operations, or related analytical work.

· Working knowledge of purchase orders, invoices, contract records, reporting workflows, and supporting documentation.

· Experience with procurement, ERP, or reporting applications; ConnectWise and Power BI experience is an advantage.

· Proficiency in Microsoft Excel, including PivotTables and VLOOKUP/XLOOKUP; familiarity with SUMIFS and report validation is beneficial.

· Strong written and verbal English communication skills and the ability to coordinate effectively with US-based and cross-functional stakeholders.

· Strong analytical, organizational, and problem-solving skills, with a high level of attention to detail.

· Ability to work independently, prioritize multiple tasks, manage deadlines, and meet defined turnaround times.

· Ability to follow company policies, procedures, and internal controls, and maintain confidentiality when handling commercial and financial information.

· Willingness and ability to work hours that provide the required overlap with US business hours, as determined by the team.

Required Skills and Competencies

· State and cooperative purchasing contract reporting, including NASPO ValuePoint, TIPS, BuyBoard, and Carahsoft.

· Sales data reconciliation and administrative fee calculations.

· Contract pricing validation, discount review, and NTE compliance checks.

· Excel-based reporting, Power BI dashboards, data validation, and variance analysis.

· Documentation management, audit support, deadline tracking, and process improvement.

· Cross-functional stakeholder communication and analytical problem-solving.

Key Performance Indicators (KPIs)

· Accuracy and completeness of contract transaction and sales reports.

· Timely completion and submission of contractual reports.

· Accuracy of administrative fee calculations and supporting statements.

· Timely identification, escalation, and resolution of pricing and reconciliation discrepancies.

· Completeness of supporting documentation and audit records.

· Effective follow-up on outstanding transactions, pending payments, and approvals.

· Adherence to contract-specific reporting requirements and internal controls.

What We Offer

Competitive compensation.

Group medical insurance and other employee benefits in accordance with company policy.

Provident Fund (PF) and applicable statutory benefits in accordance with Indian regulations and company policy.

Paid leave and holidays in accordance with the applicable India leave policy.

Role Objective

To maintain accurate contract transaction records, coordinate reconciliation and documentation, monitor pricing and administrative fee compliance, and support timely reporting and month/quarter-end close through effective cross-functional coordination and reliable data controls.

Pay: ₹700,000.00 - ₹1,200,000.00 per year

Benefits:

• Flexible schedule
• Health insurance
• Provident Fund

Application Question(s):

• Are you able to work hours that overlap with US business hours (e.g., evening or night shift IST)?
• How many years of experience do you have in contract reporting, transaction reconciliation, pricing support, sales operations or finance operations?
• Do you have hands-on experience with Excel PivotTables and VLOOKUP/XLOOKUP?
• do you have experience in Contract reporting for cooperative and state programs.
• what is your experience with either of the reporting tools like NASPO ValuePoint, TIPS, BuyBoard, Carahsoft.
• do you have experience in finance background or domain .

Education:

• Bachelor's (Required)

Work Location: In person