Senior Data Engineer - Cloud Data, SQL & AI-Driven Analytics

Roehl Transport; Marshfield (WI); On-site; USD 120,000 - 160,000; Full time

Job summary

Roehl Transport is seeking a Senior Data Engineer to design and deliver modern data solutions that support decision‑making across the enterprise. You will join a small, trusted data and analytics team to build reliable data assets, modernize data platforms, and enable business teams with timely information.

This hands‑on senior individual contributor role focuses on SQL development, stored procedures, data modeling, cloud data engineering, and data integration.

Qualifications

• Expert-level SQL skills with advanced T-SQL development.
• Designing and optimizing stored procedures, complex queries, views, functions, and SQL-based transformation logic.
• Understanding relational and dimensional data modeling including ERDs and normalization.
• Experience building data warehousing, data integration, or analytical data solutions.
• Experience with Microsoft Fabric, Python, cloud technologies, and modern data platforms.
• Experience with Power BI or similar analytics tools.
• Knowledge of secure data handling, governance, and Agile/DevOps practices.
• Strong communication and cross-functional collaboration abilities.

Responsibilities

• Design, develop, optimize, and support SQL-based data solutions with emphasis on T-SQL and stored procedures.
• Create and maintain relational and dimensional data models (ERDs).
• Build and support data pipelines across operational systems, reporting platforms, and cloud environments.
• Partner with BI Developers, Data Analysts, Data Owners, Application Developers, and stakeholders to translate requirements into practical data solutions.
• Support Roehl's Microsoft Fabric strategy and develop data assets powering Power BI and enterprise reporting.
• Use Python and AI-enabled tools 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

Advanced SQL / T-SQL

Stored procedures

Data modeling

Data warehousing

Python

Power BI

Cloud data platforms

Collaboration

AI-assisted tooling

Tools

Microsoft Fabric

Azure Data Factory

Azure SQL

Power BI

GitHub

Azure DevOps

Job description

Roehl Transport is seeking a Senior Data Engineer to design and deliver modern data solutions that support decision‑making across the enterprise. You will join a small, trusted data and analytics team to build reliable data assets, modernize data platforms, and enable business teams with timely information.

This hands‑on senior individual contributor role focuses on SQL development, stored procedures, data modeling, cloud data engineering, and data integration.