Data Analyst, Bid Tracking & Accounts Receivable

Position Summary:

We are seeking a highly organized, detail-oriented professional to manage data analysis, bid tracking, purchase order (PO) management, accounts receivable, and financial reporting. This role requires advanced Microsoft Excel skills, experience with SAP Ariba and accounting systems, and the ability to maintain accurate financial and procurement records while supporting business operations and management decision-making.

Key Responsibilities:

Data Analysis & Reporting: Collect, validate, and analyze data; develop Excel reports, dashboards, and performance-tracking tools; identify trends, discrepancies, and opportunities for improvement.

Bid Tracking & Management: Maintain bid logs, monitor submission deadlines and revisions, track bid progress and outcomes, and coordinate with internal teams to ensure timely submissions. Track bids using Pro Core and Smartsheet's.

Purchase Order Management: Track POs from creation through fulfillment, reconcile purchase orders with bids and supporting documents, and follow up on outstanding items.

Accounts Receivable: Complete customer invoicing, billing records, payment tracking, collections, aging reports, account reconciliations, and resolution of billing discrepancies. Process credit memos and monitor outstanding balances to support timely payments and healthy cash flow.

Financial Management & Reconciliation: Maintain accurate financial records, reconcile accounts, support general ledger activities, and assist with financial reporting in accordance with applicable accounting principles and internal controls.

Systems & Documentation: Utilize Microsoft Excel, SAP Ariba, QuickBooks, and other relevant platforms to maintain accurate records, track procurement activities, and streamline reporting processes.

Communication & Project Support: Coordinate with management, customers, vendors, procurement teams, and project personnel to resolve issues, communicate status updates, manage competing deadlines, and support job-site activities as needed.

Manages and reviews all billing tickets, invoices, etc. Complete and issue accurate invoices to customers on a timely basis.

Maintain and update customer invoicing files and records.

Process credit memos as required.

Process and enter invoices into customer invoicing websites or submit invoices by electronic data exchange.

Basic Office Duties: Answers phones, prepare correspondence, receives visitors, along with other typical office assistant duties.

Required Qualifications:

• College degree in Business, Finance or Accounting or 5 years of extensive experience.
• Strong advanced Microsoft Excel skills, including PivotTables, XLOOKUP/VLOOKUP, formulas, dashboards, and large-data-set management.
• Experience in bid coordination, purchase order tracking, and procurement documentation.
• Working knowledge of SAP Ariba and accounting software such as QuickBooks.
• Strong accounts receivable, invoicing, collections, and account reconciliation experience.
• Knowledge of double-entry bookkeeping, general ledger accounting, GAAP, and internal controls.
• Excellent analytical, organizational, communication, and problem-solving skills.
• Strong attention to detail and the ability to manage multiple projects and deadlines independently.
• Willingness to travel to job sites as required.

Will have to prove they are advanced user in excel by completing a test.

Pay: $25.00 - $35.00 per hour

Expected hours: 40.0 per week

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Work Location: In person

Salary : $25 - $35