Roadrunner Freight is seeking a Data Engineer with expertise in the Microsoft Business Intelligence stack to design, build, and maintain robust data pipelines and analytical models to support data-driven decision-making in the transportation and logistics industry
Requirements
- 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
- Experience with Python or other scripting for data manipulation is a bonus
Responsibilities
- 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
- 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
Other
- 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 problem-solving, analytical, and communication skills
- Ability to work independently and in cross-functional teams
- Experience in the transportation, logistics, or supply chain industry (e.g., working with data on fleet management, routing optimization, inventory tracking, or freight analytics) is preferred
