Responsibilities
•Develop and maintain high-performance SQL queries and stored procedures in SQL Server, DB2, and Azure SQL
•Design, optimize, and automate ETL processes for operational and logistics data
•Build integrations using RESTful APIs and structured data transfers between systems
•Create and manage Tableau dashboards to support operational insights and executive reporting
•Support TruckMate TMS data extractions and integrations across departments
•Manage and monitor automated workflows via GoAnywhere MFT
•Work with Salesforce data for syncing, reporting, and operational use
•Collaborate with operations, dispatch, and analytics teams to deliver data solutions
•Proactively improve SQL performance, eliminate bottlenecks, and ensure data accuracy
•Document technical processes, schema changes, and data flow logic
________________________________________
Requirements
•4–5+ years of hands-on experience in a Data Engineer or similar data-heavy role
•Expert-level SQL skills — must be fluent with:
oWindow functions
oCTEs
oNested subqueries
oIndex tuning
oPerformance optimization
oComplex joins and aggregations
•Direct experience with:
oMicrosoft SQL Server
•Experience with RESTful API development/integration (JSON, tokens, authentication, etc.)
•Proficiency in Tableau for building dashboards and visualizing operational data
•Experience working with TruckMate or similar transportation management systems
•Familiarity with GoAnywhere or other MFT platforms
•Working knowledge of Salesforce data structures and integration points
•Strong communication and documentation skills
•Ability to work independently and manage priorities in a production environment
________________________________________
Preferred Qualifications
•Background in logistics, transportation, or supply chain
•Experience in building data pipelines that support operations in real-time
•Comfortable troubleshooting across multiple database platformsApache Spark, Python, Apache Hadoop, Apache Kafka, ETL - Extract Transform Load, Microsoft SQL, API - Application Programming Interface, Tableau