Track Data & Reporting Specialist

PTS Advance; Big Spring (TX); On-site; USD 45,000 - 65,000; Full time

Job summary

PTS Advance in Texas seeks an experienced Track Coordinator to support daily Track system activities, reporting, PO coordination, and budget-to-actual reporting. The role serves as a key resource for Track users and timekeepers, ensuring reports are generated accurately and issues are routed to the appropriate teams.

The ideal candidate will be an experienced Track user with strong attention to detail and solid knowledge of Microsoft Excel, including pivot tables, charts, and graphs.

Qualifications

• Demonstrated experience as an experienced Track user with a strong understanding of the system and its reporting capabilities.
• Working knowledge of Microsoft Excel, including Pivot tables, basic charts and graphs, sorting, filtering, and organizing data.
• Updating established reporting templates and maintaining accuracy across templates.

Responsibilities

• Run standard reports within Track and compile data into established Excel reporting templates.
• Utilize Excel pivot tables, charts, and graphs to organize and present Track data.
• Maintain accurate and timely reporting to support project and operational needs.
• Assist timekeepers with Track-related questions and issues, serving as a first point of coordination and submitting help tickets to Mserv when necessary.
• Assist with Purchase Order (PO) issues by identifying the appropriate support needs and submitting help tickets to Procurement.
• Monitor outstanding Track and PO support requests and help ensure issues are appropriately routed and addressed.
• Update the Budget vs. Actual Excel report on a monthly basis.
• Distribute monthly Budget vs. Actual reporting to designated stakeholders.
• Maintain consistency and accuracy across recurring reports and spreadsheets.
• Work with timekeepers, project personnel, Mserv, Procurement, and other stakeholders to resolve administrative and reporting issues.
• Support other Track-related reporting and coordination activities as needed.

Skills

Track system

Microsoft Excel

Pivot tables

Data reporting

Attention to detail

Time management

Communication skills

Independent work

Tools

Track system

Job description

PTS Advance in Texas seeks an experienced Track Coordinator to support daily Track system activities, reporting, PO coordination, and budget-to-actual reporting. The role serves as a key resource for Track users and timekeepers, ensuring reports are generated accurately and issues are routed to the appropriate teams.

The ideal candidate will be an experienced Track user with strong attention to detail and solid knowledge of Microsoft Excel, including pivot tables, charts, and graphs.