Data Engineer

Roadrunner; Downers Grove (IL); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Competitive salary

Benefits package

Professional growth opportunities

Job summary

Roadrunner in Downers Grove, IL seeks an experienced Data Engineer with a MS BI focus to design, build, and maintain robust data pipelines and analyses. You will work with SQL Server, SSAS tabular models, and Power BI to enable data-driven decisions across transport and logistics datasets.

The role emphasizes backend data engineering, data quality, governance, and collaboration with cross-functional teams. A strong MS BI background and 5+ years of experience are required, with a hybrid work

Qualifications

• 5+ years of experience as a Data Engineer or BI Developer.
• Expertise in the Microsoft BI stack: SSIS, SSAS, Power BI.
• Strong SQL, data warehousing concepts, performance tuning.
• Knowledge of Azure data services is a plus.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines.
• Develop SSAS tabular models and DAX calculations.
• Create Power BI datasets, reports, and dashboards.
• Collaborate with stakeholders to design data models that meet business needs.
• Implement data quality checks, governance, and monitoring.

Skills

SQL

Analytical thinking

Data modeling

Communication

Team collaboration

Education

Bachelor's degree in CS/IS/Data Engineering

Tools

SSIS

SSAS

Power BI

Azure SQL

DAX/MDX

SQL Server

Job description

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 Data Engineer - Microsoft BI Focus 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 Data Engineer with expertise in the Microsoft Business Intelligence stack to design, build, and maintain robust data pipelines and analytical models. This role focuses on backend data engineering using strong SQL skills, SQL Server Analysis Services (SSAS) for tabular modeling, and Power BI for data visualization and reporting. The ideal candidate will support data-driven decision-making by ensuring high-quality, scalable data solutions.Experience in the transportation and logistics industry is preferred, as the role involves working with datasets related to supply chain, routing, inventory, freight, and operational efficiency.Critical Job Functions:Design, develop, and optimize ETL/ELT processes using SQL Server Integration Services (SSIS) or similar tools to ingest, transform, and load data from various sources into data warehouses or lakes.Build and maintain SSAS tabular models, including data modeling, DAX calculations, relationships, partitions, and row-level security.Develop complex SQL queries, stored procedures, views, and functions for data extraction, aggregation, and performance tuning on SQL Server databases.Create and support Power BI datasets, reports, and dashboards, connecting to SSAS models or direct data sources for interactive visualizations.Collaborate with stakeholders to gather requirements, design data models, and ensure solutions meet business needs for reporting and analytics.Implement data quality checks, governance, and monitoring to maintain accuracy and reliability of data pipelines.Optimize data models and queries for performance, scalability, and cost efficiency.Support migration or integration of legacy systems into modern Microsoft BI environments.Job Requirements:Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent experience).5+ years of experience as a Data Engineer, BI Developer, or similar role with hands-on Microsoft BI stack.Strong SQL proficiency: Expert in writing advanced T-SQL queries, performance tuning, indexing, and handling large datasets.Expertise in SQL Server Analysis Services (SSAS) Tabular models: Building semantic models, DAX/MDX, KPIs, perspectives, and processing.Proficiency in Power BI: Data modeling, Power Query, DAX for calculations, report/dashboard development, and publishing/sharing.Experience with SSIS for ETL pipelines and data integration.Familiarity with data warehousing concepts (e.g., star/snowflake schemas, dimensional modeling).Knowledge of Azure data services (e.g., Azure SQL, Azure Analysis Services, Fabric) is a plus.Strong problem-solving, analytical, and communication skills.Ability to work independently and in cross-functional teams.Preferred QualificationsExperience in the transportation, logistics, or supply chain industry (e.g., working with data on fleet management, routing optimization, inventory tracking, or freight analytics).Familiarity with SSRS for reporting or other BI tools.Certifications: Microsoft Certified: Data Analyst Associate, Power BI Data Analyst, or Azure Data Engineer.Experience with Python or other scripting for data manipulation is a bonus.What We OfferCompetitive salary and benefits package.Opportunity to work on impactful projects in a data-driven environment.Professional growth in Microsoft technologies and industry-specific analytics.If you have a passion for turning complex data into actionable insights and thrive in a backend-focused engineering role, we encourage you to apply!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, ILBenefits:PTOPaid HolidaysMedical InsuranceDental InsuranceVision InsuranceLife Insurance401kRoadrunner 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, ILAbout RoadrunnerRoadrunner 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.