[Hiring] Lead Data Engineer @Redwood Logistics

Role Description

As Lead Data Engineer working within Shared Services, 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.
• 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.

Qualifications

• 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
• 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

• 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 an 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.

Work Schedule

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.

Compensation Range

Salary Range: $135,000 - $155,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 actual base salary offered will depend on a variety of factors, including the qualifications of the individual applicant for the position, years of relevant experience, specific and unique skills, level of education attained, certifications or other professional licenses held, and the geographical location in which the applicant lives and/or which they will be performing the job.