Data Analyst, Bid Tracking & Accounts Receivable

Little B's Construction, LLC; Medford (OK); On-site; USD 34,000 - 48,000; Full time

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Vision insurance

Life insurance

Paid time off

Job summary

Little B's Construction, LLC is seeking a Data Analyst for Bid Tracking & Accounts Receivable to support day-to-day reporting, procurement visibility, and customer billing on site in Medford, OK. The role offers $25.00 to $35.00 per hour, 40 hours per week, and benefits including 401(k), health, dental, vision, life insurance, and paid time off.

The ideal candidate will build Excel reports and dashboards, manage bid logs, and ensure accurate invoicing and AR workflows while collaborating with

Qualifications

• College degree in Business, Finance, or Accounting.
• 5 years of extensive experience.
• Advanced Microsoft Excel skills with PivotTables and XLOOKUP/VLOOKUP.
• Experience with bid coordination and purchase order tracking.
• Familiarity with SAP Ariba and QuickBooks.
• Strong accounts receivable, invoicing, and collections experience.
• Knowledge of GAAP and internal controls.
• Excellent analytical and organizational skills.
• Willingness to travel to job sites.

Responsibilities

• Collect, validate, and analyze data; build Excel reports, dashboards, and performance-tracking tools; identify trends, discrepancies, and improvement opportunities.
• Maintain bid logs, track submission deadlines and revisions, monitor bid progress and outcomes, and coordinate with internal teams to support timely submissions.
• Track bids using Pro Core and Smartsheet.
• Manage purchase orders from creation through fulfillment; reconcile purchase orders with bids and supporting documentation; follow up on outstanding items.
• Complete customer invoicing and billing record maintenance, including payment tracking, collections, aging reports, account reconciliations, and resolution of billing discrepancies.
• Process credit memos and monitor outstanding balances to support timely payments and cash flow.
• Maintain accurate financial records, reconcile accounts, support general ledger activities, and assist with financial reporting in line with applicable accounting principles and internal controls.
• Use Microsoft Excel, SAP Ariba, QuickBooks, Pro Core, Smartsheet, PivotTables, XLOOKUP, VLOOKUP, electronic data exchange to maintain records and streamline reporting.
• Coordinate with management, customers, vendors, procurement teams, and project personnel to resolve issues, provide status updates, and manage deadlines.

Skills

Advanced Excel

PivotTables

XLOOKUP/VLOOKUP

Dashboards

Accounts Receivable

GAAP

Bid coordination

Education

College degree

Tools

SAP Ariba

QuickBooks

Pro Core

Smartsheet

Job description

Little B's Construction, LLC is hiring an organized, detail-focused Data Analyst for Bid Tracking & Accounts Receivable to support day-to-day reporting, procurement visibility, and customer billing operations onsite in Medford, OK. If you enjoy turning business information into clear reporting and keeping financial records accurate, this role blends data analysis with accounts receivable and billing workflows. The position offers $25.00 to $35.00 per hour and 40 hours per week, plus benefits including 401(k), health, dental, vision, life insurance, and paid time off.

Responsibilities

• Collect, validate, and analyze data; build Excel reports, dashboards, and performance-tracking tools; identify trends, discrepancies, and improvement opportunities.
• Maintain bid logs, track submission deadlines and revisions, monitor bid progress and outcomes, and coordinate with internal teams to support timely submissions.
• Track bids using Pro Core and Smartsheet.
• Manage purchase orders from creation through fulfillment; reconcile purchase orders with bids and supporting documentation; follow up on outstanding items.
• Complete customer invoicing and billing record maintenance, including payment tracking, collections, aging reports, account reconciliations, and resolution of billing discrepancies.
• Process credit memos and monitor outstanding balances to support timely payments and cash flow.
• Maintain accurate financial records, reconcile accounts, support general ledger activities, and assist with financial reporting in line with applicable accounting principles and internal controls.
• Use Microsoft Excel, SAP Ariba, QuickBooks, and other platforms to maintain accurate records, track procurement activity, and streamline reporting.
• Coordinate with management, customers, vendors, procurement teams, and project personnel to resolve issues, provide status updates, and manage competing deadlines. Assist with job-site activities as needed.
• Review and manage billing tickets and invoices, then issue accurate invoices to customers on a timely basis.
• Maintain and update customer invoicing files and records; submit invoices through customer invoicing websites or by electronic data exchange.
• Perform office support duties including answering phones, preparing correspondence, receiving visitors, and assisting with typical office assistant tasks.

Requirements

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

Technology Stack

Microsoft Excel, SAP Ariba, QuickBooks, Pro Core, Smartsheet, PivotTables, XLOOKUP, VLOOKUP, electronic data exchange

Work Details

• Location: In person, Medford, OK
• Expected hours: 40.0 per week
• Compensation: $25.00 - $35.00 per hour