LTL Pricing Manager

About Us

FitzMark is a third-party logistics provider specializing in all modes of transportation. We deliver best-in-class services for both our customers and carriers by leveraging our proprietary technology, DASH, and maintaining a proactive operational approach to ensure all logistics needs are guaranteed. With offices strategically located in Indianapolis (HQ), Atlanta, Birmingham, Buffalo, Chattanooga, Fort Worth, Gainesville, Jackson, Kansas City, Nashville, Omaha and Scottsdale, FitzMark has been able to sustain growth in a complex industry and market. At FitzMark, success is driven by emphasizing our employees’ accomplishments in a collaborative and dynamic environment. We provide the tools and resources necessary to promote a culture of ownership and accountability to guide your career path and financial freedom.

Responsibilities

• Analyze and audit account-level issues and defect patterns
• Identify and correct data errors across various datasets, applying advanced formulas & functions
• Resolve data discrepancies and integration issues by performing robust ETL Processes with Power Query
• Import and clean data from diverse sources (e.g., ERP systems like SAP, CSV files, APIs), merge datasets (e.g., combining carrier invoices with internal tracking data), and expertly handle missing values, duplicates, and inconsistent formats (e.g., date standardization)
• Recommend data-driven solutions and process improvements to team members and management
• Translate complex analytical findings into clear, actionable insights
• Produce high-level PowerPoints and data insights into digestible presentations for leadership
• Recommend data adjustments, corrections, and process changes in collaboration with other analysts and management
• Create custom scripts for Excel using Office Scripts
• Support advanced data visualization initiatives by exporting Excel data to Power BI for comprehensive reporting and dashboard creation

Requirements

• Logistics and Transportation experience preferred
• College Degree in Information Science or related field is preferred
• 1-3 years of Data Analytics preferred
• In-depth knowledge of advanced functions in Microsoft Excel
• Proficiency in Microsoft PowerPoint
• Expertise in PivotTables & Power Pivot for creating dynamic reports, analyzing key performance indicators, and data modeling with large datasets from multiple sources
• Proficiency in Data Validation & Conditional Formatting for ensuring data quality and highlighting outliers

Schedule

Monday to Friday, 8:00 AM to 5:00 PM

Location

On Site, Fort Worth, TX office