SR Business Analyst

Universal Logistics Holdings, Inc.; United States; On-site; USD 70,000 - 100,000; Full time

Job summary

Universal Logistics Holdings, Inc. is seeking a Business Analyst to support multiple groups including Sales, Pricing, Customer Service, Dispatch/Operations, Billing and Payroll settlements. The role spans integration of software connections, auditing, and reporting to executives.

You will develop dashboards, validate data, coordinate with IT and vendors, and translate business needs into technical specifications, focusing on KPIs and strategic insights.

Qualifications

• Bachelor’s degree in a relevant field.
• 4+ years experience in transportation, logistics, business analysis, project management, or financial reporting.

Responsibilities

• Analyze and interpret data from relational databases.
• Develop dashboards and reports using BI tools such as Excel, Qlik, Power BI, and similar.
• Communicate and review business objectives between stakeholders and executive teams.
• Validate and clean data to maintain consistency and integrity.
• Translate business needs into data requirements and provide actionable insights.
• Identify data trends and provide recommendations to support strategic decisions.
• Collaborate with cross-functional teams to define and track KPIs.
• Audit and identify data trends on projects; present findings to stakeholders.

Skills

Analytical skills

Problem-solving

Data analysis

Data visualization

Public speaking

Education

Bachelor's degree in Business / Supply Chain / Logistics

Tools

Excel

Access

Qlik

Job description

Are you looking to join a dynamic team that provides its people with the tools to be successful and opportunities to grow? Universal Logistics is a leading provider of customized transportation and logistics solutions, offering a comprehensive suite of services including transportation, value-added, intermodal, and specialized services utilized throughout entire supply chains. Universal has immediate career opportunities in your area.

Universal Logistics Holdings is a multi-billion dollar logistics provider. We have been in the industry for over 90 years and are proud of our awards and affiliations with industry leaders. Universal celebrates our employees who have company pride and the drive to succeed. Behind our services, technology, and systems stands a talented team that truly delivers results and drives everything we do. Come join the team that made it possible for us to be named Great Supply Chain Partner 2020, Top 50 Logistics Company 2020, Top 100 For-Hire Carrier 2020, and General Motors Carrier of the Year for 2021!

Learn more at: www.universallogistics.com

Description

A Business Analyst will be assigned a multitude of tasks that span across all business groups of our organization. This includes Sales, Pricing, Customer Service, Customer Service, Dispatch/Operations, Billing and Invoicing, Payroll Settlements, Accounts payable. Tasks cover a wide range of objectives spanning from overseeing the implementation of integration connections between software’s, submitting detailed technical write ups to IT, to auditing and reporting business statistics to our stakeholders and executive teams.

Data Analytics Tasks

• Extract, analyze, and interpret data from relational databases.
• Develop and maintain interactive dashboards and reports using Business Intelligence tools such as Excel, Qlik, Power Bi, and more.
• Communicate and review business objectives between Stakeholders and Executive teams.
• Validate, Clean data to maintain consistency and integrity.
• Translate business needs into data requirements and provide actionable insights.
• Identify data trends and provide recommendations to support strategic decisions.
• Work with cross-functional teams to define and track key performance indicators (KPIs).
• Audit and identify data trends on all projects.
• Present and summarize findings and data visualizations to stakeholders in a clear, actionable format.

Project Management

• Help develop comprehensive project plans, define milestones, establish timelines, assign resources, manage dependencies, and ensure projects are delivered on schedule.
• Understand gathering business and technical requirements, documenting workflows, creating business requirements documents (BRDs), and translating business needs into technical specifications.
• Coordinate internal IT departments, business stakeholders, software vendors, developers, and third-party integration partners while maintaining accountability.
• Manage a RACI (Responsible, Accountable, Consulted, and Informed) matrix.
• Review and maintain RAID logs (Risks, Assumptions, Issues, Dependencies), identifying integration risks, managing escalations, and developing mitigation strategies.
• Coordinate unit testing, system integration testing (SIT), user acceptance testing (UAT), defect tracking, and validation of data exchanged between systems.
• Prepare project status reports, executive dashboards, milestone tracking, meeting agendas, action-item logs, and communicate complex technical issues to nontechnical stakeholders.
• Manage and update change requests, evaluating business and technical impacts, preventing scope creep, and maintaining formal approval processes.

Ideal Candidate Will

• Have Bachelor’s degree in Business, Supply Chain Management, Logistics, or a related field.
• Have a combination of 4+ years experience between any or all the following groups transportation, logistics, business analysis, Project Management, or Financial reporting.
• Have Strong analytical and problem-solving skills with proficiency in data analysis tools and data visualization tools including Excel, Access, Qlick.
• Have Strong Interpersonal and Public speaking abilities. Be able to lead, present, and react on regular conference calls.
• Ability to work independently and in a team-oriented environment.
• Experience with transportation management systems (TMS) and enterprise resource planning (ERP) software.
• Knowledge of SQL Queries and Fundamentals primary keys and database fundamentals.
• Have a solid understanding of Application Programming Interface (APIs) and Electronic Data Interchange (EDI). Be able to explain differences between a 204, 990, 214, 210, 997.
• Be able to pass and explain reasons for formulas on a Microsoft excel competency exam in person.

Universal Logistics Holdings, Inc. (NASDAQ: ULH) is a holding company that owns subsidiaries engaged in providing a variety of customized transportation and logistics solutions throughout the United States, Mexico, and Canada. Our operating subsidiaries provide customers with supply chain solutions that can be scaled to meet their changing demands and volumes. Universal’s consolidated subsidiaries offer customers a broad array of services across the entire supply chain, including Contract Logistics, Dedicated Transportation, Intermodal, and Trucking.