> Markdown version of [/jobs/ext/536854-business-analytics-analyst](https://www.wearedevelopers.com/jobs/ext/536854-business-analytics-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Analytics Analyst - **Company:** Roadrunner Transportation Services - **Location:** Downers Grove, IL, United States - **Experience:** Experienced - **Salary:** $70,000.0 - $110,000.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Business Logic, Microsoft Azure, Information Systems, Customer Data Management, Data Validation, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mining, Data Warehousing, Database Development, Dimensional Modeling, Document-Oriented Databases, Python (Programming Language), Microsoft SQL Server, SQL Azure, Power BI, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Transact-SQL, Scripting, Azure Data Factory, Microsoft Fabric, Information Technology, Tools for Reporting, Data Pipelines, Ssas Tabular - **Published:** June 10, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e53d61ca686cc401 ## About the Role 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., * 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. ## Description * 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., 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. ## Related Videos - [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)