Data Analyst, Bid Tracking & Accounts Receivable

W3Global; Medford (OK); On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Life insurance

Paid time off

Vision insurance

Job summary

W3Global is seeking a highly organized data and financial operations professional to manage data analysis, bid tracking, PO management, accounts receivable, and financial reporting for our Oklahoma operations. This role demands advanced Excel, SAP Ariba, and QuickBooks proficiency to maintain accurate records and support management decisions.

You will coordinate with management, vendors, and project teams to ensure timely invoicing, robust reconciliation, and compliant financial processes while

Qualifications

• College degree or 5+ years of experience in finance, data analysis, or procurement.
• Advanced Excel skills including PivotTables, XLOOKUP/VLOOKUP, dashboards.
• Experience in bid coordination, PO tracking, and procurement documentation.
• Knowledge of SAP Ariba and QuickBooks accounting software.
• Strong AR, invoicing, collections, and account reconciliation experience.
• Understanding of GAAP and internal controls; detail-oriented and analytical.
• Excellent communication, organization, and problem-solving abilities.
• Willingness to travel to job sites as required.

Responsibilities

• Data analysis and reporting: collect, validate, and analyze data; create Excel dashboards and performance trackers.
• Bid tracking: maintain bid logs, monitor deadlines, track progress and outcomes; coordinate with teams.
• PO management: track POs from creation to fulfillment; reconcile with bids and documents.
• Accounts receivable: invoicing, billing records, payment tracking, aging reports, reconciliation.
• Financial management: maintain records, GL support, and internal-controls-aligned reporting.
• Systems & documentation: use Excel, SAP Ariba, QuickBooks to maintain records and streamline reporting.
• Communication & project support: coordinate with management, customers, vendors, and project teams.
• Billing administration: manage and issue invoices; maintain invoicing files and credit memos as needed.
• Invoicing processes: enter invoices into customer portals or via EDI.
• Office duties: basic clerical tasks as needed.

Skills

Analytical skills

Attention to detail

Multitasking

Communication skills

Excel proficiency

Time management

Education

College degree in Business/Finance/Accounting

5 years of relevant experience

Tools

SAP Ariba

QuickBooks

Pro Core

Smartsheet

Job description

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.
• Expected hours: 40.0 per week

Benefits

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