Data Analyst: Bid & AR Insights (Onsite Medford, OK)

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 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