Data Engineer

redwoodlogistics; Monterrey; Remote; MXN 600,000 - 1,100,000; Full time

Benefits offered by this job

Learning & Development opportunities

Internal mobility

Employee referral program

ERGs

Charitable fundraising & volunteering

Life Insurance after 30 days

Health Insurance

23–30 days vacation depending on year

Meal vouchers

Cell phone allowance

Job summary

Redwood Logistics is seeking a Data Engineer to design, develop, and maintain scalable data pipelines, a data vault, and data warehouses/marts. This role collaborates with stakeholders across departments to deliver key metrics and insights.

You will work in a remote setup with Monterrey and/or Queretaro locations, contributing to data-driven decision making and optimization of logistics platforms. A bilingual English/Spanish capability and a strong SQL/data modeling background are essential.

Qualifications

• Bachelor's degree required; preference in Business Administration, Mathematics, Computer Science, or related field.
• 5+ years technology experience with data pipelines, data vault, and data warehouses.
• Experience with TMS, WMS, or other enterprise logistics platforms is a plus.
• Proficient in SQL development and data modeling.

Responsibilities

• Design, develop, and maintain scalable data pipelines and data vaults, warehouses, and marts.
• Collaborate with stakeholders across departments to deliver key metrics.
• Maintain and improve data structures to support evolving business requirements.
• Work with internal and external users including executives, engineers, and vendors.

Skills

SQL development

Performance tuning

Bi-lingual English/Spanish

Strong communication skills

Data modeling

Self-starter

Analytical thinking

Entrepreneurial

Problem solving

Team collaboration

Education

Bachelor's Degree in related field

Tools

Snowflake

Fivetran

Azure Data Factory

REST API

AWS/Azure/Google Cloud

Aurora MySQL

Microsoft SQL Server

Data Vault 2.0

Job description

Data Engineer

Reports To: Lead Data Engineer

Location: Monterrey and/or Queretaro

Environment: Remote

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.

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 a Data Engineer working within Shared Services (one of our entities), you will be responsible for 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.

How You Make a Difference Everyday?

• 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

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

You’ve Got This?

• Bi-lingual in English/Spanish; proficient level for verbal and written communication

• 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

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

• 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

• Self-starter, entrepreneurial, highly adaptable who can take initiative in a fast-moving environment.

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

• 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 starting at 12 days. Additional days will increase per Mexican Law

• Premium Vacation 50% vacation days (Prima vacacional)

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