Lead Data Engineer

Redwood Logistics LLC; Santiago de Querétaro; A distancia; MXN 900.000 - 1.300.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Learning & Development opportunities

Internal mobility

Employee Resource Groups

Life Insurance

Health Insurance

30 days Aguinaldo

Vacation 12 days

Saving Plan

Food Coupons

Cell Phone Allowance

Descripción de la vacante

Redwood Logistics LLC is seeking a Lead Data Engineer to design, build, and maintain scalable data pipelines, a data vault, and various data warehouses and marts. You will lead a team across departments to deliver key metrics and define data strategy.

The role emphasizes collaboration with stakeholders, mentoring engineers, and advancing the data platform, with remote work options and a focus on robust data infrastructure.

Formación

• Bachelor’s Degree required (or equivalent experience) in Business Administration, Mathematics, Computer Science, or related field.
• Strong leadership and mentoring of data engineers.
• 8+ years technology experience with one or more of the following: Amazon Relational Database Service (Aurora, MySQL), Microsoft SQL Server, Snowflake.
• Strong Python with Pandas, Streamlit, NumPy, JSON/CSV, and Requests.
• Experience with TMS, WMS or other enterprise logistics platforms is a strong plus.
• Cloud platforms such as AWS, Azure, or Google Cloud experience.

Responsabilidades

• Lead and mentor a team of data engineers, providing guidance and technical expertise.
• Manage backlog grooming, sprint planning, and prioritization for data engineering projects.
• Collaborate with business and technical leaders to set and execute initiatives.
• Stay current with emerging trends and technologies in data engineering and evaluate new platforms to enhance the stack.
• Design, develop, and maintain data pipelines from various data sources including TMS.
• Develop and maintain Data Vault, Data Warehouse, and Data Marts.
• Improve and harden deployments, data validation, error handling, and data democratization.

Conocimientos

Aurora/MySQL

SQL Server

Snowflake

Python

Pandas

Streamlit

NumPy

JSON/CSV

Requests

Git

CI/CD

Educación

Bachelor's Degree

Herramientas

Fivetran

Azure Data Factory

REST API

AWS

Azure

Google Cloud

Coalesce.io

YAML

Descripción del empleo

Current job opportunities are posted here as they become available.

This position is full-time and remote Monday through Friday with an hour break

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

What We Offer:

• Access to experts and resources for your Learning & Development journey
• Opportunity for internal mobility
• Employee Resource Groups (ERGs)
• Annual fundraising and volunteer events to give back to communities
• Employee referral bonus program
• Life Insurance policy for you starting 30 days after employment
• Personal Health Insurance coverage for you – Major Medical
• 30 days “Aguinaldo” Christmas bonus or prorated percentage your first year
• Vacation time starts at 12 days. Additional days will increase per Mexican Law
• You will also receive benefits like Saving Plan (Fondo de Ahorro) and Food Coupons (Vales De Despensa) 6% or the Maximum amount by Mexican Law
• You will be provided with a Cell Phone Allowance of $800 pesos per month minus applicable taxes

Redwood is an equal opportunity employer. Employment decisions at the Company are based on individual merit, qualifications, abilities, and the Company’s needs and resources. The Company does not discriminate in recruiting, hiring, compensation, promotions, discipline, termination or any other aspect of employment on the basis of an individual’s actual or perceived race, color, creed, religion, sex (including pregnancy, childbirth and related medical conditions), sexual orientation, gender identity, national origin, ancestry, citizenship status, age, disability, marital status, military service or status, genetic information, arrest and conviction record, credit history, or any other basis protected by applicable law.

REDWOOD LOGISTICS
1765 N. Elston Ave., Suite 216,Chicago,IL,60642
P:844-467-3396
E:[e-mail]