SR Business Analyst

hrone; Warren (MI); On-site; USD 65,000 - 90,000; Full time

Job summary

Universal Logistics Holdings, a leading logistics provider, is seeking a Business Analyst to support multiple business groups, including Sales, Pricing, Customer Service, Dispatch, Billing, and Payroll Settlements. You will audit data, build dashboards, and partner with stakeholders and IT to improve processes and insights.

The ideal candidate has a Bachelor's in business or logistics and 4+ years in analytics or PM, with strong Excel, Qlik, and data visualization skills.

Qualifications

• Bachelor's degree in Business, Supply Chain Management, Logistics, or a related field.
• 4+ years of experience in transportation, logistics, business analysis, project management, or financial reporting.
• Strong analytical and problem-solving skills with data analysis and visualization tools.

Responsibilities

• Extract, analyze, and interpret data from relational databases.
• Develop and maintain dashboards and reports using BI tools such as Excel, Qlik, and Power BI.
• Communicate business objectives between stakeholders and executives.
• 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.
• Define and track KPIs with cross-functional teams.
• Prepare project status reports and executive dashboards.

Skills

Data analysis

Data visualization

Communication

Public speaking

Independent work

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 successfull and opportunities to grow?

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 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. A qualified candidate should be able to perform the following tasks

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 enterpri