Data Analyst & Bid Tracking Specialist

Job Summary

We are seeking a highly organized, detail-oriented Data Analyst & Bid Tracking Specialist to support business operations through data analysis, bid management, purchase order (PO) tracking, and performance reporting. The ideal candidate is an expert-level Microsoft Excel user with strong analytical skills, experience with SAP Ariba, and the ability to manage multiple projects, deadlines, and data sources accurately.

This role requires someone who can turn raw data into meaningful business insights, maintain accurate bid and PO records, monitor project progress, and provide clear reporting to support informed business decisions. Occasional travel to job sites may be required.

Key Responsibilities

Data Collection, Analysis & Reporting

• Collect, organize, validate, and clean data from multiple sources to ensure accuracy and consistency.
• Analyze historical and current data to identify trends, patterns, discrepancies, and opportunities for improvement.
• Develop and maintain Excel reports, dashboards, charts, and tracking tools to monitor business performance.
• Prepare recurring and ad hoc reports for management and project stakeholders.
• Translate data findings into actionable recommendations that support operational efficiency and business decisions.

Bid Tracking & Management

• Maintain accurate and up-to-date bid tracking logs, spreadsheets, and reporting systems.
• Monitor bid opportunities, submission deadlines, statuses, revisions, and outcomes.
• Track bid progress from initial opportunity through submission and award.
• Coordinate with internal teams to collect required bid information and ensure deadlines are met.
• Identify outstanding items, potential delays, and follow-up actions related to active bids.

Purchase Order (PO) Tracking

• Track purchase orders from creation through approval, issuance, and fulfillment.
• Maintain accurate records of PO numbers, values, statuses, dates, and associated projects.
• Reconcile bid information, purchase orders, and supporting documentation to identify discrepancies.
• Follow up with internal departments, vendors, and project teams regarding outstanding purchase orders.
• Provide regular status updates and reports on open bids, pending POs, and project-related commitments.

SAP Ariba & Systems Management

• Utilize SAP Ariba to support procurement activities, bid management, purchase order tracking, and documentation.
• Maintain organized electronic records and ensure information is entered accurately and consistently.
• Assist with tracking procurement activity and resolving data or documentation discrepancies.

Organization & Project Support

• Manage multiple priorities, deadlines, and projects in a fast-paced environment.
• Maintain organized files, tracking logs, reports, and supporting documentation.
• Communicate effectively with management, vendors, procurement teams, and project personnel.
• Travel to job sites as needed to gather information, review project progress, and coordinate with on-site teams.

Required Qualifications & Skills

• Expert-level proficiency in Microsoft Excel, including advanced formulas, PivotTables, XLOOKUP/VLOOKUP, data validation, conditional formatting, and large-data-set management.
• Strong experience with bid tracking, bid coordination, and deadline management.
• Experience tracking purchase orders and maintaining accurate procurement records.
• Working experience with SAP Ariba.
• Strong analytical, problem-solving, and data interpretation skills.
• Experience creating reports, dashboards, and performance-tracking tools.
• Exceptional organizational skills and attention to detail.
• Ability to manage multiple projects and competing deadlines independently.
• Strong written and verbal communication skills.
• Ability to identify discrepancies, investigate issues, and follow through to resolution.
• Willingness and ability to travel to job sites as required.

Ideal Candidate

The ideal candidate is a proactive, highly organized professional who combines expert Excel skills with analytical thinking and strong administrative follow-through. They are comfortable managing detailed tracking systems, monitoring bids and purchase orders, identifying discrepancies, and communicating status updates to multiple stakeholders. They take ownership of their work, maintain accurate records, and can be relied upon to keep information organized, deadlines visible, and reporting current.

Pay: From $30.00 per hour

Expected hours: 40.0 per week

Work Location: In person

Salary : $30