Roehl Transport is looking for a Senior Data Engineer in Appleton, WI (onsite) to design and deliver modern data solutions that support enterprise decision-making. This hands-on senior individual contributor role sits within a small, highly trusted data and analytics team, where you will build reliable data assets, modernize data platforms, and help business teams get timely, meaningful information.
What you’ll build and own
- Design, develop, optimize, and support SQL-based data solutions, with a strong focus on T-SQL, including stored procedures, views, and functions with performance-aware query design.
- Create and maintain relational and dimensional data models, including ERDs and operational models built for clarity and usability.
- Build and support data pipelines, integrations, and transformations 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 high-value, practical 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.
Skills and experience we need
- 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 (including third normal form), dimensional modeling, metadata practices, and data governance concepts.
- Multiple years of experience building and maintaining data warehousing, data integration, or analytical data solutions.
- Experience building in a modern Microsoft-centric data stack, including SQL Server, Python, cloud technologies, and modern data platforms.
- Experience with Microsoft Fabric and/or familiarity with 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 collaborate with both technical and business teams.
Tools you’ll work with
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
- Microsoft Fabric experience or strong interest in building 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, and architecture diagrams (including Visio and ERDs).
- Experience in transportation, logistics, operations, or similarly data-rich environments.
How your work connects to the mission
Roehl is a data-rich environment. Operational, customer, driver, logistics, and communications systems generate valuable data every day. You will help transform that information into trusted data assets that improve business performance, driver success, operational efficiency, and decision-making.
Roehl values and culture
Roehl’s values are Safety, Driver Driven, Do the Right Thing, Innovation, Delivering Success, and Unity in Diversity. The company emphasizes purpose-driven work, strong foundations, good partnerships, and doing things the right way. You can expect a culture that values technical depth, ownership, accountability, and collaboration while solving meaningful business problems through better data.
About Roehl Transport: Founded in 1962, Roehl Transport 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.
