Roehl Transport is seeking a Senior Data Engineer to design and deliver modern data solutions that support enterprise decision-making. This role is an on-site, hands-on senior individual contributor position focused on SQL development, data modeling, cloud data engineering, and data integration using Microsoft Fabric, Python, Power BI, and AI-enabled ways of working.
Responsibilities
- Design, develop, optimize, and support SQL-based data solutions, with a strong emphasis 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.
- Partner 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 where 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, 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 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 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.
Why This Opportunity
Roehl Transport is seeking a Senior Data Engineer to help design and deliver modern data solutions that support decision-making across the enterprise. As part of a small, highly trusted data and analytics team, you will build reliable data assets, modernize data platforms, and enable business teams with timely, meaningful information.
This is a senior hands-on individual contributor role centered on SQL development, stored procedure design, data modeling, cloud data engineering, and data integration. You will collaborate across Business Intelligence, Data Management, Application Development, Infrastructure, and business stakeholders to transform data into trusted information assets that improve business performance, driver success, operational efficiency, and decision-making.
Roehl is a data-rich environment where operational, customer, driver, logistics, and communications systems generate valuable data every day. The right candidate will bring strong technical judgment, ownership, curiosity, and a desire to advance Roehl’s modern data strategy through SQL Stored Procedures, Microsoft Fabric, Python-enabled engineering, Power BI, and practical AI-assisted ways of working.
How We Work
- Our values include Safety, Driver Driven, Do the Right Thing, Innovation, Delivering Success, and Unity in Diversity.
- We act with purpose, build on strong foundations, value good partnerships, and take pride in doing things the right way.
- We value technical depth, ownership, accountability, collaboration, and a commitment to solving meaningful business problems through better data.
Company Information
Roehl Transport, founded in 1962, is one of the nation’s largest, most progressive, and safest transportation and logistics companies. With over 2,800 employees and offices across the U.S., Roehl serves 8,800+ customers, including recognized brands. Work location is in person in Appleton, WI (onsite).
