Business Analyst Sql R Python Jobs in Chicago, IL

Roadrunner's Smart Long Haul is revolutionizing the industry with significant investments in technology, a culture of continuous improvement, and intelligent and efficient direct routing. A Top 100 Trucking company by Inbound Logistics and a Top Tier Service Carrier by Mastio, Roadrunner is an LTL industry leader on the rise.
As a long-haul, metro-to-metro LTL carrier, Roadrunner offers more direct routes than any other nationwide Less-than-Truckload carrier in the United States. With a nationwide presence, terminals across 40+ markets, and more than $400 million in revenue, the company's Smart Long-Haul Network is the preferred choice for shippers looking to move freight quickly and reliably.
Roadrunner is growing and looking for a highly motivated Business Analytics Analyst to join our winning team. If you are results driven and looking for a rapidly growing company with high growth and earnings potential, apply today!
We Run Safe. We Run Smart. We Run Together.

Job Description Summary:

We are seeking an experienced Business Analytics Analyst with a balance of technical data skills and strong business acumen. This role requires someone who can engage directly with Finance, Sales, Operations, and Executive Leadership to understand what the business needs - and then use hands-on SQL skills and familiarity with the Microsoft BI stack to investigate, validate, and deliver reliable analytical solutions.

The ideal candidate is a skilled problem-solver who can look at a report, identify when something doesn't look right, trace it back to the source, and explain it clearly to both technical and non-technical audiences. This is not a pure engineering role, nor a pure business analyst role - it requires someone who is equally comfortable writing a complex SQL query and presenting findings to a VP. Experience in the transportation and logistics industry is preferred, as the role involves working with data related to revenue and billing, driver and fleet operations, customer and sales performance, and on-time delivery metrics.

Critical Job Functions:

Business Analysis & Stakeholder Engagement

• Partner with stakeholders across Finance, Sales, Operations, and Executive Leadership to understand business questions, gather reporting requirements, and translate operational needs into analytical solutions.
• Serve as the primary point of contact between business stakeholders and the analytics team, ensuring alignment on priorities, data definitions, and deliverables.
• Investigate data discrepancies and anomalies, identify root causes, and communicate findings and recommended actions clearly to both technical and non-technical audiences.
• Establish, document, and maintain data definitions, business rules, and metric calculations to formalize institutional knowledge and ensure consistent reporting across the organization.

Data Analysis & SQL Development

• Write and optimize T-SQL queries, stored procedures, and views against SQL Server databases to support reporting, root cause analysis, and business investigations.
• Interpret and validate data models and ETL processes to ensure business logic is accurately represented and data quality issues are identified and resolved.
• Apply solid understanding of data warehousing concepts (star and snowflake schemas, dimensional modeling) to guide solution design and support the analytics team.
• Collaborate with the analytics team to ensure data pipelines and models reliably support downstream reporting and analytical needs.

Reporting & Data Quality

• Develop and maintain Power BI reports and dashboards that deliver clear, accurate, and actionable insights across revenue, fleet operations, customer data, and service performance.
• Implement data quality checks and monitoring to maintain the accuracy and reliability of reporting outputs.
• Support the documentation of data governance standards, business definitions, and reporting logic to reduce reliance on tribal knowledge and improve organizational data literacy.
• Provide guidance and mentorship to junior team members on analytical best practices, SQL development, and business requirements documentation.

Job Requirements:

• Bachelor's degree in Business, Information Systems, Computer Science, or a related field (or equivalent experience).
• 3+ years of experience in a business analyst, data analyst, or BI developer role with demonstrated ability to connect business processes to data outcomes.
• Strong SQL proficiency: ability to write, interpret, and troubleshoot queries for data extraction, validation, and analysis on SQL Server databases.
• Working knowledge of Power BI for report and dashboard development, including data modeling and DAX calculations.
• Familiarity with ETL concepts and the ability to review, validate, and document data pipeline logic.
• Strong analytical and critical thinking skills, with a track record of investigating data issues and identifying root causes.
• Demonstrated ability to gather, document, and translate business requirements into reliable data and reporting solutions.
• Excellent verbal and written communication skills, with the ability to present data findings clearly to both technical and non-technical stakeholders.
• Ability to manage multiple priorities and work independently in a fast-paced, results-driven environment.

Preferred Qualifications

• Experience in the transportation, logistics, or supply chain industry (e.g., familiarity with revenue and billing processes, fleet or driver operations, customer service metrics, or on-time delivery performance data).
• Hands-on experience with SSAS tabular models, including DAX and semantic model design.
• Experience with SSIS or similar ETL tooling for data integration and pipeline development.
• Knowledge of Azure data services (e.g., Azure SQL, Azure Analysis Services, Microsoft Fabric).
• Experience with Python or other scripting languages for data analysis or automation.
• Background or coursework in statistics, data science, or operations research.

What We Offer

• Competitive salary.
• Paid Time Off and paid holidays.
• Medical, Dental, and Vision insurance.
• Life insurance and 401(k).
• Opportunity to work on high-impact projects in a data-driven, rapidly growing organization.
• Professional growth in Microsoft technologies and industry-specific analytics.

Physical Demands and Work Environment: The physical demands and work environment described here are representative of those an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

• Physical Demands:
  • Sedentary physical activity performing non- strenuous daily activities of an administrative nature.
  • While performing the duties of the job, the employee is regularly required to sit, walk, stand, reach/handle items, work with the fingers, and talk and hear others in conversations via the phone or in person.
• Work Environment:
  • The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
  • The noise level in the work environment is usually moderate.

Compensation:

• The compensation for this role is $70,000 to $110,000 per year.

Job Location:

• Hybrid - Downers Grove, IL

Benefits:

• PTO
• Paid Holidays
• Medical Insurance
• Dental Insurance
• Vision Insurance
• Life Insurance
• 401k

Roadrunner Freight is building something special with great people, a winning culture and a differentiated service offering in the marketplace. Join us today to grow your career!

We will not accept unsolicited candidates from external recruiters or recruiting agencies. Thank you!

#LI-HybridDowners Grove, IL

About Roadrunner

Roadrunner is for ambitious, smart people who excel at execution over talking about it, and who would rather invent the next standard in freight than accept the status quo.

We are looking for the Best of the Best. Action driven leaders who want to be part of real change and help design the future of LTL in the U.S. This is a place where high performers can grow, influence outcomes, and make an impact while working directly with executives and smart people from across industries.

We bring a winner mindset. We take ownership, raise the bar, and measure ourselves by results. We Run Safe. We Run Smart. We Run Together. These principles create an environment of high standards, clear ownership, and direct collaboration. We trust data over intuition, move with urgency, and hold each other accountable because winning requires it.

Roadrunner exists to prove that LTL can be better than the industry has settled for. To be the best means we need to think bigger, look outside the box, and question every assumption: too many handoffs, limited visibility, and the quiet belief that "this is just how it works." We rejected that story. We built a proprietary Smart Network for direct, long haul, metro to metro service that delivers fewer touches, faster transit, real time visibility, and genuine accountability. We are the most tech forward company in LTL, and we are not finished widening the gap.

The foundation is already strong. Recognized as one of Built In Chicago's Best Large Places to Work. Earning top marks for improvement, quality, and service. The real opportunity is still ahead: helping invent what comes next.

If you want to be evaluated among the Best of the Best and help set the new standard in LTL, we should talk.