> Markdown version of [/jobs/ext/2581438-data-engineer](https://www.wearedevelopers.com/jobs/ext/2581438-data-engineer). 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). --- # Data Engineer - **Company:** Roadrunner Freight - **Location:** Downers Grove, IL, United States - **Experience:** Expert - **Salary:** $70,000.0 - $110,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Big Data, Information Systems, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Mining, Data Warehousing, Database Queries, Dimensional Modeling, Python (Programming Language), Microsoft SQL Server, SQL Azure, Microsoft Business Intelligence, Routing, Performance Tuning, Power BI, Standard Sql, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Transact-SQL, Data Processing, Freeform SQL, Azure Data Factory, Indexer, Backend, Powerquery, Information Technology, Data Pipelines, Ssas Tabular, Legacy Systems - **Published:** August 10, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=6fbe911be786d31a ## About the Role * 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 Qualifications * Experience 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. ## Description 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., 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 - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Creating a routing app with Google Maps API from scratch](https://www.wearedevelopers.com/videos/831-creating-a-routing-app-with-google-maps-api-from-scratch) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)