Data & Pricing Systems Analyst

Posted Yesterday
Be an Early Applicant
Delafield, WI, USA
In-Office
Junior
Logistics • Professional Services • Transportation • 3PL: Third Party Logistics
The Role
Owns the data and systems layer supporting Account Management and Carrier Procurement. Builds repeatable data pulls, pipelines, dashboards, reporting workflows, and automation across MercuryGate, DAT, Excel, and BI tools. Consolidates data sources, improves carrier tendering and pricing workflows, documents processes, and helps develop a truckload rating engine. Partners with business leaders to translate reporting needs into accurate, self-service systems.
Summary Generated by Built In

Description

THE POSTITION

This role owns the data and systems layer that connects Evans' Account Management and Carrier Procurement teams. Today, a lot of that work lives in scattered spreadsheets, one-off exports, and manual pulls. This person will replace that patchwork with reporting, dashboards, and workflows that are fast, accurate, and self-serve.

We're not looking for someone who simply runs reports on request. We need someone who can design the system behind the report: fetch the data, build the pipeline, automate the repeat work, and free up the people who are doing this by hand today.

This role intentionally blends two functions that split into separate teams at larger brokerages: data/BI and pricing. At Evans' current scale, one person owns both end to end. As we grow, this role is positioned to lead whichever side of that split we build out first.

Requirements

ROLES AND RESPONSIBILITIES

  • Consolidate today’s scattered manual reports and exports into standing, repeatable pulls for Account Management and Carrier Procurement
  • Design how data flows between MercuryGate, the DAT integration, Excel tools, and any BI layer, and keep it documented
  • Identify recurring manual work (data pulls, report assembly, status updates) and build the automation or AI-assisted workflows to remove it
  • Consolidate the department’s live dashboards into a single, current, trusted set
  • Track, prioritize, and close incoming data and reporting requests from Account Management, Carrier Procurement, and Yield
  • Improve the waterfall and auto-tendering workflow to carriers, and clean up contract vs. spot labeling inside the TMS
  • Blend Evans’ different data sources (TMS, market rate data, carrier data) into a single view, and help build a new truckload rating engine from that foundation
  • Partner with Account Management, Carrier Procurement, and Yield leadership to understand what they need from the data before building it
  • Perform all other duties as assigned.

An individual in this position must be able to successfully perform the essential duties and responsibilities listed above. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this position.

The above list reflects the general details necessary to describe the principle and essential functions of the position and shall not be construed as the only duties that may be assigned for the position.

MINIMUM QUALIFICATIONS AND REQUIREMENTS

Experience / Training: 2+ years in a data, reporting, or analytics role, ideally with supply chain, procurement, or transportation exposure. Proven ability to build a dashboard, scorecard, or reporting system from scratch and get people to actually use it. Comfortable pulling and blending data from multiple systems (TMS, Excel exports, external data feeds) into one clean source of truth.

Licenses / Certifications: n/a

Technology / Equipment: Strong Excel/Power BI (or similar BI tool) skills; comfortable working inside a TMS (e.g., MercuryGate) and its underlying data structures.

PREFERRED QUALIFICATIONS AND REQUIREMENTS

Experience / Training: Experience standardizing or documenting a process so it runs the same way every time, for everyone. Track record of finding and fixing the root cause of a recurring data or process problem, not just patching it. Comfortable with AI and automation tools, and actively looks for ways to use them to cut manual work. Strong written communication, able to explain a number or a system to someone non-technical. Detail-oriented and comfortable owning the accuracy of numbers other people make decisions from. Self-directed: comfortable being handed a messy, only partly defined problem and building the system to solve it.

Licenses / Certifications: n/a

Technology / Equipment: n/a

PHYSICAL AND MENTAL DEMANDS

While performing the duties of this job, the employee must be able to continuously sit, use a keyboard, calculator, and telephone. The employee is occasionally required to stand, walk, stoop, and/or kneel. The employee must occasionally lift and/or move up to 10 pounds while moving files or small packages. Specific vision abilities required by this job include close vision and the ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The mental and physical requirements described here are representative of those that must be met by an individual to successfully perform the essential functions of this position.

WORK ENVIRONMENT

Work is performed in an office environment. The noise level in the work environment is usually moderate. The work environment characteristics described here are representative of those an individual encounters while performing the essential functions of this position.

The work environment characteristics described here are representative of those an individual encounters while performing the essential functions of this position.

Skills Required

  • 2+ years of experience in data, reporting, or analytics
  • Experience building a dashboard, scorecard, or reporting system from scratch
  • Ability to pull and blend data from multiple systems, including TMS data, Excel exports, and external feeds
  • Strong Excel skills
  • Strong Power BI or similar BI tool skills
  • Comfort working inside a TMS, such as MercuryGate, and understanding its underlying data structures
  • Experience standardizing or documenting repeatable processes
  • Experience identifying and resolving root causes of recurring data or process problems
  • Comfort with AI and automation tools
  • Strong written communication skills and ability to explain data or systems to nontechnical audiences
  • Detail-oriented and accountable for data accuracy
  • Self-directed problem-solving ability
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
1,000 Employees
Year Founded: 1985

What We Do

Founded in 1985, Evans Transportation is a full-service, third-party provider of custom logistics solutions for a diverse range of shippers across North America. For maximized agility, Evans is assetless and privately owned, fueled by unmatched technology and its uncommonly dedicated team. In an industry defined by volatility, Evans’ unwavering commitment to value provision facilitates an average customer retention rate of nine-plus years.

Similar Jobs

Applied Systems Logo Applied Systems

Manager, HRIS

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
100K-160K Annually

PwC Logo PwC

Finance Data, Analytics & AI - Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
39 Locations
370000 Employees
61K-100K Annually

PwC Logo PwC

Managed Services - Revenue Cycle Coding - Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
42 Locations
370000 Employees
124K-280K Annually

BECU Logo BECU

Enterprise Risk Analyst - AI Risk

Fintech • Financial Services
Remote or Hybrid
3 Locations
3000 Employees
68K-128K Annually

Similar Companies Hiring

Toro TMS Thumbnail
Cloud • Enterprise Web • Sales • Software • Transportation
Chicago, IL
80 Employees
Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
43 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account