SR Business Analyst

Universal Logistics Holdings, Inc.; Warren (MI); On-site; USD 70,000 - 100,000; Full time

Job summary

Universal Logistics Holdings, Inc. in Warren, MI seeks a Business Analyst to support Sales, Pricing, Customer Service, Dispatch, Billing, Payroll and more by extracting and interpreting data from relational databases and building interactive dashboards with Excel, Qlik, and Power BI.

You will collaborate with stakeholders to define KPIs, document BRDs, and coordinate IT and vendor teams while managing project plans, risks, and change requests in a structured, RAID-tracked process.

Qualifications

• Bachelor’s degree in Business, Supply Chain Management, Logistics, or related field.
• 4+ years experience in transportation, logistics, business analysis, project management, or financial reporting.
• Strong analytical and problem-solving skills with proficiency in data analysis tools and data visualization tools including Excel, Access, Qlik.
• Strong interpersonal and public speaking abilities. Lead, present, and participate in conference calls.
• Experience with transportation management systems (TMS) and ERP software.
• Knowledge of SQL Queries and fundamentals; APIs and EDI concepts.

Responsibilities

• Extract, analyze, and interpret data from relational databases.
• Develop and maintain interactive dashboards and reports using Excel, Qlik, Power BI, and more.
• 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.
• Define and track KPIs with cross-functional teams.
• Audit data trends on all projects and present findings to stakeholders.
• Prepare project status reports, executive dashboards, milestone tracking, meeting agendas, and action-item logs to communicate complex issues to nontechnical stakeholders.
• Coordinate unit testing, SIT/UAT, defect tracking, and data validation between systems.
• Manage RAID logs, risks, issues, and dependencies; develop mitigation strategies.
• Develop comprehensive project plans, milestones, timelines, resources, and RAID management to ensure on-schedule delivery.

Skills

Analytical thinking

Public speaking

Interpersonal skills

Independent work

Education

Bachelor’s degree in Business, Supply Chain Management, Logistics, or related field

Tools

Excel

Access

Qlik

Power BI

SQL

ERP systems

TMS

Job description

Are you looking to join a dynamic team that provides its people with the tools to be successfull 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. Apply today to become part of the Universal team!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. Apply today to become part of the Universal team!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.comDescription· 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 tasksData 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.