Real-Time Supply Chain Analytics Analyst

Jobtailor; Pittsburgh (Allegheny County); On-site; USD 65,000 - 95,000; Full time

Job summary

Jobtailor in the United States is seeking a data analytics professional to develop and maintain supply chain dashboards, reports, and metrics. You will partner with operations, logistics, procurement, and leadership to present clear data insights.

You will leverage advanced Excel and Power BI to drive real-time visibility, carrier performance analysis, and inventory planning. Strong communication and cross-functional collaboration are essential for success.

Qualifications

• Bachelor's degree in Supply Chain, Analytics, or related field.
• Advanced proficiency in Microsoft Excel (Pivot tables, VLOOKUP/XLOOKUP, Power Query).
• Strong analytical, organizational, and problem-solving skills.
• Ability to prepare and present reports to technical and non-technical audiences.
• Strong attention to detail and ability to manage multiple priorities.
• Experience with Power BI or similar data visualization tools.
• Familiarity with transportation, freight rate analyses is a plus.
• Knowledge of supply chain systems and analytics in operations.

Responsibilities

• Develop, maintain, and analyze supply chain reports, dashboards, and metrics.
• Prepare, present, and communicate data findings to cross-functional partners.
• Utilize advanced Excel and Power Query to build tools and models.
• Create and maintain Power BI dashboards for real-time insights.
• Analyze inbound and outbound logistics performance including carrier efficiency.
• Assist in evaluating transportation and freight opportunities.
• Support demand planning, inventory optimization, and warehousing workflows.
• Identify and resolve supply chain inefficiencies using data-driven approaches.
• Partner with internal teams for business reviews, root cause analyses, budgeting, and process improvement.
• Present findings and recommendations to audiences at all levels.
• Collaborate with vendors, carriers, and internal stakeholders to improve data accuracy.

Skills

Excel proficiency

Analytical thinking

Data visualization

Communication

Attention to detail

Time management

Cross-functional collaboration

Education

Bachelor's degree in Supply Chain, Analytics, or related field

Tools

Power BI

Job description

• Develop, maintain, and analyze supply chain reports, dashboards, and metrics to support strategic planning and daily operations.
• Prepare, present, and clearly communicate data findings to cross-functional partners, including operations, logistics, procurement, and leadership.
• Utilize advanced Excel skills (pivot tables, complex formulas, Power Query, macros preferred) to build tools and models that improve visibility and performance tracking.
• Create and maintain Power BI dashboards to deliver real-time insights and trend analysis.
• Analyze inbound and outbound logistics performance, including carrier efficiency, freight spend, and service adherence.
• Assist in evaluating transportation and freight opportunities; experience with transportation/freight rates is a plus.
• Support demand planning, inventory optimization, and warehousing workflows through accurate and timely data analysis.
• Help identify, diagnose, and resolve supply chain inefficiencies using data-driven approaches.
• Partner with internal teams to support business reviews, root cause analyses, budgeting activities, and process improvement initiatives.
• Present findings and recommendations with clarity to audiences at all levels, tailoring communication style as needed.
• Work closely with vendors, carriers, and internal stakeholders to maintain accurate data and improve operational outcomes.

Requirements

• Bachelor’s degree in Supply Chain, Business, Analytics, Operations Management, or related field
• Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, nested formulas, Power Query, etc.)
• Strong analytical, organizational, and problem‑solving skills
• Ability to prepare, present, and communicate reports to technical and non‑technical audiences
• Strong attention to detail and ability to manage multiple priorities
• Experience with Power BI or similar data visualization tools
• Preferred Experience with transportation, freight rate structures, rate analysis, or carrier management
• Knowledge of supply chain management systems
• Prior experience in supply chain, logistics, or operations analytics

🔍 ATS Optimization Keywords
Below are skills and terms extracted directly from this job posting to improve Applicant Tracking System (ATS) visibility. This unique feature helps candidates tailor their applications more effectively — a feature exclusive to JobTailor job listings.

Hard Skills

• Data Analysis
• Supply Chain Reporting
• Metrics Development
• Complex Formulas
• Pivot Tables
• Power Query
• Freight Rate Analysis
• Inventory Optimization
• Demand Planning
• Process Improvement

Soft Skills

• Analytical Skills
• Organizational Skills
• Attention to Detail
• Communication Skills
• Problem-Solving Skills