Apply on Employer Site

Roadrunner · 2 weeks ago

Data Engineer - Microsoft BI Focus

Downers Grove IL

Full-time

Hybrid

Mid, Senior Level

$70K/yr - $110K/yr

5+ years exp

Roadrunner is a leading company in the transportation and logistics industry, seeking an experienced Data Engineer with expertise in the Microsoft Business Intelligence stack. The role involves designing, building, and maintaining robust data pipelines and analytical models to support data-driven decision-making.

LogisticsSupply Chain ManagementTransportation

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

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

Qualification

SQL proficiencySQL Server Analysis ServicesPower BIETL/ELT processesData warehousing conceptsAzure data servicesAnalytical skillsPythonCertificationsProblem-solving skillsCommunication skillsTeamwork

Required

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

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