Lead Data Engineer Job Aurora area,Colorado USA,IT/Tech

Careers at Redwood Logistics Back to Job Openings Lead Data Engineer

Lead Data Engineer

Reports To:

Principal Data Engineer

Location:

Remote (within the U.S.)

Environment:
Remote

Status:
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.

Leveraging a comprehensive range of services, data-centric network solutions, and a seamlessly integrated platform, we have established our prominence as a key player in the mid-market segment within the freight tech industry.

Whether you’re just starting your career or are an established professional looking for your next opportunity, Redwood inspires innovation across teams to provide transformative solutions for our customers.

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.

How You Make a Difference Everyday:

Lead and mentor a team of data engineers, providing guidance, support, and technical expertise
Manage backlog grooming, sprint planning, and prioritization activities for data engineering projects
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

You’ve Got This?

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

What We Offer:

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…