Lead Data Engineer

Redwood Logistics•Chicago, IL

12h•$120,000 - $140,000•Hybrid

About The Position

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.

Requirements

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
Self-starter, entrepreneurial, highly adaptable who can take initiative in a fast-moving environment.
Strong communication and leadership skills

Nice To Haves

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

Responsibilities

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

Benefits

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