Senior Data Engineer

Roehl Transport is hiring a Senior Data Engineer in Appleton, WI (onsite) to design and deliver modern data solutions that support enterprise decision-making.

Responsibilities

• Design, develop, optimize, and support SQL-based data solutions with a focus on T-SQL, including stored procedures, views, functions, and performance-aware query design.
• Create and maintain relational and dimensional data models, including ERDs and well-structured operational models.
• Build and support data pipelines, integrations, and transformation processes across operational systems, reporting platforms, and cloud data environments.
• Collaborate with BI Developers, Data Analysts, Data Owners, Application Developers, and business stakeholders to understand requirements and deliver practical, high-value data solutions.
• Support Roehl’s Microsoft Fabric strategy by developing data assets that power Power BI, enterprise reporting, advanced analytics, and future AI-driven use cases.
• Use Python and AI-enabled tools when appropriate to improve automation, integration, analysis, and engineering productivity.
• Apply secure data handling, governance, metadata, and development best practices.
• Provide senior-level technical leadership through design input, code quality, standards, mentoring, and collaboration.

Requirements

• Expert-level SQL skills, including advanced T-SQL development.
• Strong experience designing and optimizing stored procedures, complex queries, views, functions, and SQL-based transformation logic.
• Strong understanding of relational modeling, ERDs, normalization principles, third normal form design, dimensional modeling, metadata practices, and data governance concepts.
• Multiple years of experience building and maintaining data warehousing, data integration, or analytical data solutions.
• Experience developing within a modern Microsoft-centric data stack, including SQL Server, Python, cloud technologies, and modern data platforms.
• Experience with Microsoft Fabric, Azure Data Factory, Azure SQL, OneLake, Lakehouse concepts, or similar cloud data technologies.
• Experience supporting Power BI or other modern analytics and visualization platforms.
• Understanding of secure data handling, Agile development, source control, deployment practices, and tools such as Azure DevOps or GitHub.
• Strong communication skills and the ability to partner effectively with both technical and business teams.

Technologies

• T-SQL, SQL, SQL Server
• Stored procedures, Views, Functions
• Python
• Microsoft Fabric
• Power BI
• Azure Data Factory, Azure SQL
• OneLake, Lakehouse concepts
• Azure DevOps, GitHub
• ERDs

Preferred and plus skills

• Microsoft Fabric experience or a strong interest in developing Fabric expertise.
• Experience with Azure data pipelines, cloud data lake implementations, Lakehouse architecture, or modern ELT patterns.
• Experience using AI-assisted development, AI-enabled analytics, or practical AI tools to improve engineering productivity.
• Experience with C#, Power BI semantic models, dataflows, data quality, lineage, cataloging, governance, Visio, ERDs, and architecture diagrams.
• Experience in transportation, logistics, operations, or similarly data-rich environments.

The opportunity

• Hands-on senior individual contributor role focused on SQL development, stored procedure design, data modeling, cloud data engineering, and data integration.
• Join a small, highly trusted data and analytics team to build reliable data assets, modernize data platforms, and enable business teams with timely, meaningful information.
• Partner with Business Intelligence, Data Management, Application Development, Infrastructure, and business teams to transform data into trusted information assets that improve business performance, driver success, operational efficiency, and decision-making.
• Work in a data-rich environment with operational, customer, driver, logistics, and communications systems generating valuable data daily.

How we work

• Values: Safety, Driver Driven, Do the Right Thing, Innovation, Delivering Success, Unity in Diversity.
• Act with purpose, build on strong foundations, value good partnerships, and take pride in doing things the right way.
• Value technical depth, ownership, accountability, collaboration, and solving meaningful business problems through better data.

Company

• Roehl Transport, founded in 1962
• One of the nation’s largest, most progressive, and safest transportation and logistics companies
• Over 2,800 employees and offices across the U.S.; serving 8,800+ customers
• Work location: in person