Project Specialist, IKE

Orange Barrel Media
  • Columbus, Ohio
    3 days ago

    Job Description

    About the role

    The Project Specialist keeps IKE deployments moving by owning the administrative and coordination work behind every site. This role supports the Project Managers in an assigned region on scheduling, vendor and invoice processing, material tracking, documentation, and data accuracy in SiteTracker.


    This is the role that catches what falls between the cracks. When a permit expires, an invoice ages, a kiosk ships to the wrong market, or a date in SiteTracker no longer matches reality, the Project Specialist is the one who finds it and fixes it before it costs the schedule.


    The right person is organized, persistent, and comfortable chasing people for answers. They are not waiting to be told what to look at. They notice when something is off and say so.


    This role is also where the program's reporting lives. The Project Specialist builds and maintains the reports and dashboards in SiteTracker that Project Managers and leadership run the business on, and uses that data to spot where sites are slipping before anyone has to ask.


    This role is remote eligible and aligned to an assigned region, with occasional travel.


    What you'll do

    • Maintain SiteTracker data for assigned markets, including dates, statuses, costs, and documentation, and keep it accurate enough that leadership can trust it without re-checking
    • Run the weekly data hygiene pass and flag records where the data and the field do not agree
    • Process purchase orders, vendor invoices, and change orders, track them to payment, and chase aging items before they become disputes
    • Track kiosk fabrication, shipment, and delivery, and tell Project Managers when a unit is landing ahead of or behind site readiness
    • Build and maintain reports and dashboards in SiteTracker for Project Managers, the Associate Director, and program leadership
    • Compile and distribute weekly status, go-live forecast, and jeopardy reporting for assigned markets
    • Analyze cycle times across siting, permitting, construction, and energization, and surface where markets are trending off plan
    • Track vendor performance on schedule, first-pass permit approval, and cost, and turn it into reporting the team can act on
    • Collect and file closeout documentation, including as-builts, inspection sign-offs, warranties, and photos, so markets close cleanly
    • Schedule site walks, pre-construction meetings, and inspections, and keep the calendar current for the team
    • Set up new vendors, route agreements and insurance certificates for review, and keep vendor records current
    • Support Project Managers with meeting notes, action item tracking, and follow-up so commitments do not get lost
    • Serve as a first point of contact for vendor and agency questions that do not require a Project Manager
    • Contribute to templates, trackers, and process documentation as the program scales
    • Travel occasionally to assigned markets as business needs require

    Qualifications

    • 4+ years in project coordination, administration, or operations support, preferably in construction, infrastructure, telecom, or utility work, including at least 2 years in a reporting or analytics capacity.
    • Strong organizational skills and the ability to track many open items at once without dropping any.
    • Comfort following up with vendors, agencies, and internal teams until a question is answered.
    • Experience with purchase orders, invoices, and basic project cost tracking.
    • A data analytics background, with demonstrated experience turning raw project data into reporting that drives decisions.
    • Advanced Excel skills, including pivot tables, lookups, and building reports others rely on.
    • Experience building reports or dashboards in a project tracking or CRM system.
    • Clear written communication, particularly in status reporting and email follow-up.
    • Experience with SiteTracker, Salesforce, or a similar project tracking system, or demonstrated ability to learn one quickly.
    • Proficiency in Microsoft Office Suite.

    Preferred

    • Experience supporting projects in the public right-of-way.
    • Familiarity with permitting processes and agency submittal requirements.
    • Exposure to utility service applications or power make-ready coordination.
    • Experience building SiteTracker or Salesforce reports, dashboards, and list views.
    • Working knowledge of SQL, Power BI, Tableau, or a similar analytics tool.
    • Experience building or improving a tracker, template, or reporting process.
    • Associate or Bachelor's degree, or equivalent experience.

    Numbers & Facts

    LocationColumbus, Ohio

    Skills

    • Administrative Skillsunmatched
    • Analysis Skillsunmatched
    • Billingunmatched
    • Building Permitsunmatched
    • Change Requests/Ordersunmatched
    • Communication Skillsunmatched
    • Construction Inspectionunmatched
    • Customer Relationship Management (CRM) Systemsunmatched
    • Data Analysisunmatched
    • Data Qualityunmatched
    • Documentationunmatched
    • Forecastingunmatched
    • Infrastructure Constructionunmatched
    • Insurance Documentationunmatched
    • Internet Key Exchange (IKE)unmatched
    • Leadershipunmatched
    • Market Trend Analysisunmatched
    • Materials Trackingunmatched
    • Meeting Minutesunmatched
    • Microsoft Officeunmatched
    • Operational Supportunmatched
    • Organizational Skillsunmatched
    • Performance Analysisunmatched
    • Pivot Tablesunmatched
    • Power BIunmatched
    • Project Trackingunmatched
    • Project/Program Coordinationunmatched
    • Project/Program Managementunmatched
    • Purchase Ordersunmatched
    • Record Keepingunmatched
    • Reporting Dashboardsunmatched
    • SQL (Structured Query Language)unmatched
    • Salesforce.comunmatched
    • Tableauunmatched
    • Time Managementunmatched
    • Vendor/Supplier Evaluationunmatched
    • Vendor/Supplier Planningunmatched
    • Vendor/Supplier Selectionunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Resume Builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Resume Builder