Sql data analyst Empleos en Clearwater fl

Overview

TKC Holdings, Inc.—comprised of Trinity Services Group, Keefe Group, and Courtesy Products - is a mid market respected leader in the corrections and hospitality industries for more than 40 years. With thousands of team members across the country, we continue a tradition of innovation, integrity, and success. TKC is committed to delivering excellent products and services, exceeding customer expectations, and empowering the career development of every team member. We are proud to be a military and veteran-friendly employer. BENEFITS: We care about our employees and offer benefits that support your health, finances, and career growth. Medical, Dental & Vision Insurance 401(k) Retirement Plan with Company Match Paid Time Off (PTO) Tuition Reimbursement Paid Training Career Advancement Opportunities Life Insurance & AD&D Coverage Voluntary Benefits including Short-Term Disability, Long-Term Disability, Critical Illness, Accident Coverage, and more. About This Position You will support Trinity Services Group's FOB + Freight program and local and direct vendor spend management. Responsibilities include coordinating freight activity and maintaining freight and vendor data. They also involve reviewing invoices, tracking savings, and preparing spend and bid analyses. Additionally, responsibilities include supporting sourcing and contract activities for vendors outside Trinity's primary negotiated programs, such as Trinity Managed, Produce Alliance, and Entegra. You will support distributor scorecards, compliance reporting, and other performance analytics for national and regional food distributors on the Distribution & Compliance team. You will work under the direction of Procurement leadership and provides accurate data, follow-up, and practical analysis to support sourcing and operational decisions. This is a role in a dynamic procurement organization with career growth opportunities. You will work onsite and remotely. You will report to the Senior Procurement Manager. Essential Functions/Main Responsibilities Create pickup, delivery, vendor, and facility locations in Uber Freight TMS. Enter transportation orders from PO information; coordinate load creation and confirmation with Uber Freight. Pull SONAR rate estimates when invoices are not yet available. Review weekly Uber Freight invoices; update actual costs, dates, and surcharges. Maintain the Freight and Markup Tracker, including FOB cost comparisons and savings calculations. Report freight savings and cost-mitigation performance metrics. Coordinate with vendors, manufacturers, and distribution partners on pickup/delivery exceptions. Support freight lane bid activities by gathering requirements, preparing bid documents, organizing carrier responses, and completing bid comparisons for Procurement leadership review. Review local and direct vendor spend, maintain vendor information, and identify opportunities for additional analysis or contract coverage outside Trinity's main negotiated programs (Trinity Managed, Produce Alliance, and Entegra). Support sourcing and contracting activities by gathering vendor information, preparing spend and pricing analyses, coordinating documentation, and tracking open items through completion. Review Entegra and other GPO contract information and identify potential applicability to local and direct vendor spend for Procurement leadership review. Build and maintain distributor performance scorecards and supporting analytics for Distribution & Compliance. Support distribution compliance reporting and performance metrics. Other responsibilities as determined by our needs. What You'll Need We prefer a Bachelor's degree in Business, Supply Chain, or a related field; we may consider equivalent relevant experience. Exposure to truckload, less-than-truckload, or other transportation industry. Experience supporting vendor analysis, bid events, contract administration, or supplier coordination. One or more years of experience in procurement, supply chain, transportation, logistics, data analysis, or a related business function. Organize and prioritize recurring freight tasks, reporting deadlines, and assigned procurement projects. Provide written expression across vendors, carriers, and our teams. Interpret spend and freight data to identify trends. Intermediate to advanced Microsoft Excel skills, proficiency in Word and PowerPoint. Experience with Power BI or similar reporting and data visualization tools. Working knowledge of ERP and TMS systems (Uber Freight TMS preferred). Support vendor discussions, maintain organized follow-up, and contribute to cost-saving and process-improvement plans. We do not require CPM, CPSM, or other procurement or supply chain certification, but we consider it a plus. One or more years of experience. You will work within established processes and escalate sourcing, contracting, and award decisions to Procurement leadership. Manage recurring freight tasks, data maintenance, reporting, and assigned procurement projects with appropriate guidance. Coordinate with vendors, carriers, and our teams. Analyze information, identify trends or issues, and provide clear findings to support daily freight and vendor-spend decisions. Follow established procedures, maintain accurate documentation, and seek guidance when issues fall outside standard processes. Comfortable working in a team-oriented environment. Define problems, collect data, establish facts, and draw valid conclusions. Address work-related issues. Complete tasks while maintaining efficiency.