Business Data Analyst

Gateway Truck & Refrigeration; Collinsville (IL); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

401K with company match

Health, dental and vision insurance

Company paid short-term & long-termdis

Paid time off

Paid holidays

Employee assistance program

Life insurance

Job summary

Gateway Truck & Refrigeration in Collinsville, IL is seeking a data-driven Business Data Analyst to safeguard data integrity and build reporting frameworks across our 15-location dealership network. You will transform operational data into actionable insights, develop dashboards, and present findings to leadership to improve profitability, efficiency, and customer service.

Collaborating with sales, service, parts, inventory, and finance, you will establish KPIs, automate data collection, and

Qualifications

• Bachelor's degree in CS/statistics/economics or equivalent.
• Strong analytical and problem-solving abilities.
• Ability to multitask with attention to detail.
• Continuous improvement mindset.
• Able to work independently or in a team.
• Strong written and verbal communication.
• 3–5 years' experience in data analytics or related field.
• Technical expertise with data models, database design development, data mining and segmentation.

Responsibilities

• Collect and filter data across multiple systems and locations to ensure accuracy.
• Clean, prepare, and curate datasets for analysis.
• Use statistical tools to identify patterns and trends.
• Create dashboards and visualizations for leadership.
• Prepare reports and present insights to stakeholders.
• Collaborate with all departments to define KPIs.
• Improve reporting functions and maintain data quality.
• Support data-driven decision making across sales, service, parts, inventory, and finance.

Skills

Analytical skills

Problem-solving

Attention to detail

Communication skills

Independent/Team work

Education

Bachelor's degree in computer science, statistics, mathematics, economics, or business administration or equivalent experience

Tools

SQL

Data mining

Data modeling

Job description

As a leading Carrier Refrigeration, Volvo, Hino, and TICO dealership, Gateway Truck & Refrigeration proudly operates 15 locations across Illinois, Missouri, Wisconsin, and Tennessee. We are seeking dedicated individuals to join our hardworking, experienced, and long‑standing team in Collinsville, Illinois. At Gateway Truck & Refrigeration, data drives better decisions. We're looking for an analytical problem solver who enjoys uncovering trends, improving processes, and helping leaders make informed decisions across sales, service, parts, and finance. If you're passionate about turning data into meaningful business insights and want to make a measurable impact within a growing, family‑owned dealership organization, we'd love to meet you!

Job Summary

The Business Data Analyst is responsible for overseeing our data systems and reporting frameworks, guaranteeing the integrity and precision of data. As our Data Analyst, you'll help leadership make smarter business decisions by transforming operational data into meaningful insights that improve profitability, efficiency, customer service, and overall performance across our 15‑location dealership network.

Job Duties

Data Collection, Cleaning and Preparation

• Collect and filter data across multiple business systems and locations, manage missing values, and prepare the dataset for analysis to ensure accuracy and relevance.
• Use automated tools to extract data from primary and secondary sources.
• Curate internal and external data.
• Remove corrupted data and fix reporting errors.

Data Exploration and Analysis

• Use statistical tools and techniques to explore and analyze data, identifying patterns, relationships, and trends.
• Structure large data sets to find usable information.
• Bring technical expertise to ensure the quality and accuracy of operational information.

Data Visualization

• Create visual representations of data findings through charts, graphs, and dashboards to make the data understandable at a glance.

Reporting

• Prepare reports and presentations to communicate the insights and findings from the data to stakeholders, which can influence policy and decision‑making processes.
• Develop dashboards and reports that provide leadership with actionable insights into sales, service, parts, inventory, and financial performance.
• Enhance analytical and reporting functions, as well as supervising performance and quality assurance processes, to pinpoint areas of enhancement.
• Maintain existing reports to ensure correct data points are being measured as industry standards evolve.

Collaboration

• Work with all departments to understand their business system and data needs to help them make informed decisions based on data insights.
• Work with business leaders to identify opportunities for improvement.
• Collaborate with team members to collect and analyze data, including internal and external data.
• Establish KPIs to measure the effectiveness of business decisions.
• Perform other duties as assigned.

Qualifications

• Bachelor's degree in computer science, statistics, mathematics, economics, or business administration or equivalent experience.
• Strong analytical skills and problem‑solving abilities.
• Ability to multitask with strong attention to detail.
• Continuous improvement mindset.
• Ability to work independently or in a team environment.
• Strong written and verbal communication skills.
• 3‑5 years' experience preferred in:
• Data analytics or related field.
• Technical expertise regarding data models, database design development, data mining and segmentation techniques.

Benefits

• 401K with company match
• Health, dental and vision insurance
• Company paid short‑term & long‑term disability insurance
• Paid time off
• Paid holidays
• Employee assistance program
• Life insurance

This job description is subject to change at any time based on company needs.

We're an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Salary: $85000 - $110000 per year