Lead Data Engineer

Redwood Logistics

Lead Data Engineer at Redwood Logistics responsible for designing and developing scalable data solutions. Collaborating with teams to deliver key metrics while mentoring data engineers.

Posted 5/12/2026full-timeRemote • Illinois • 🇺🇸 United StatesSenior💰 $120,000 - $140,000 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureCloudMS SQL ServerMySQLNumpyPandasPythonSQLVault

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

Bachelors 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, NumPy
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, DevOps, 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

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonData VaultData WarehouseData MartsJSONCSVPerformance TuningData ValidationData Pipeline Development

Soft Skills

LeadershipCommunicationCreative ThinkingIntellectual CuriosityProblem SolvingAdaptabilityInitiativeCollaborationMentoringContinuous Learning