Lead Data Engineer

Overview

Location:

Chicago, IL

Environment:
Exempt, Salaried

Who We Are Recognized by Gartner in their Modern 4PL Market Guide, Redwood Logistics is at the forefront of industry innovation. Our cutting-edge supply chain technology pairs with the expertise of our brilliant minds to empower logistics execution across North America and Mexico.

Reports To:

Principal Data Engineer

Location:

Chicago, IL

Environment:
Hybrid – 1-2 days on-site preferred

Status:
Exempt, Salaried

Purpose Of Your Work

As Lead Data Engineer working within Shared Services (one of our entities), you will be responsible for leading a team of data engineers working on designing, developing, and maintaining scalable data pipelines, a data vault, and various data warehouses and marts. You will work with stakeholders across all departments to deliver key metrics across a variety of functional areas, as well as participate in establishing data strategy.

• Lead and mentor a team of data engineers, providing guidance, support, and technical expertise
• Collaborate with business and technical leaders to set and execute both strategic and tactical initiatives
• Stay current with emerging trends and technologies in data engineering. Identify and evaluate new platforms and tools to enhance the tech stack and improve data infrastructure and processes
• Design, develop, and maintain robust data pipelines from various TMS and other data sources
• Design and implement new data structures or extend existing structures to support evolving business requirements
• Ensure the accuracy, reliability, and completeness of data through effective data validation and monitoring processes
• Develop and maintain our Data Vault, Data Warehouse, and Data Marts to deliver key metrics to operational and business stakeholders
• Collaborate with a wide variety of users, including internal stakeholders, executives, clients, engineers, and external vendors
• Improve and harden processes like code deployments, data validation, error handling/alerting, data democratization, and modernizing tech debt

• Bachelor’s Degree required (or equivalent experience); preference in Business Administration, Mathematics, Computer Science, or related field
• Creative thinker who is intellectually curious, with a passion for solving puzzles and continuous learning
• 8+ years technology experience with one or more of the following:
  • Amazon Relational Database Service (Aurora, MySQL)
  • Microsoft SQL Server
  • Snowflake
• Exceptional SQL development and performance tuning skills
• Strong experience with Python language, libraries, applications, and concepts:
  • Pandas
  • Streamlit
  • Num Py
  • Understanding of JSON and CSV
  • Requests
• Experience with the following is a strong plus:
  • TMS, WMS, or other enterprise logistics platforms
  • Data Vault 2.0
  • Fivetran
  • Azure Data Factory
  • REST API
  • Proficiency in clouds platforms such as AWS, Azure, or Google Cloud
  • Coalesce.io
  • YAML
• Experience with git, Dev Ops, and CI/CD is a strong plus
• Self-starter, entrepreneurial, highly adaptable who can take initiative in a fast-moving environment
• Strong communication and leadership skills

• Access to experts and resources for your Learning & Development journey
• Opportunity for internal mobility
• Employee referral bonus program
• Employee Resource Groups (ERGs)
• Annual fundraising and volunteer events to give back to communities
• Paid time off, floating holidays, time off to volunteer and rollover
• Paid parental leave
• Medical, dental, vision and 401k plans (with match)
• Flexible spending account, mass transit and dependent care plans available
• Health savings account, with a annual company contribution for plan participants
• Short-term and long-term disability; life insurance policies subsidized by company
• Additional benefits including pet insurance, accident care, access to legal advice and more

This position is full-time and remote Monday through Friday from 8:00 AM to 5:00 PM with an hour break, but flexibility is available based on coverage.

Salary Range: $120,000 - $140,000. This position is eligible to earn annual incentives based on individual and company performance.

The estimated pay range reflects an anticipated range for this position. The…