Tech Lead Data Engineer

TurnKey Tech Staffing; México; Remote; MXN 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Fully remote

Health and wellness package

PTO + holidays

Personal laptop

Job summary

Balsam Brands in Mexico is seeking an experienced Tech Lead to design and deliver scalable data warehousing solutions using Snowflake, dbt, and Python. You will serve as the pod’s technical authority and own delivery within its domain.

You’ll lead migration of data platforms, guide engineers, collaborate with Product and Data teams, and help shape data strategy while working remotely with occasional in-person events in Mexico.

Qualifications

• 8+ years of professional data engineering experience.
• Hands-on Python development and polyglot programming.
• Experience designing scalable data pipelines across multi-cloud environments.

Responsibilities

• Design and implement scalable data solutions using Snowflake, dbt, and Python.
• Lead migration of data platforms to Snowflake with minimal disruption.
• Own pod-level technical delivery and provide reliable estimates.
• Collaborate with Product, Data, and Design teams to meet data needs.
• Guide engineers and drive performance tuning and automation.

Skills

Python

Data engineering

Cloud platforms (Azure AWS GCP)

English proficiency (Advanced)

REST APIs

Data modeling (Medallion Architecture)

Kanban / Agile

Stakeholder communication

Tools

Snowflake

dbt

SQL

Job description

Balsam Brands is a global, eCommerce retailer with roots in seasonal, Christmas, and home décor. We are thrilled to extend our reach into Mexico, bringing the magic of the holidays to a vibrant new location. Your role will be pivotal in shaping the future and trajectory of our company right here in Mexico!

Why Balsam Brands?

At Balsam Brands, we’re not just a company. Our people-first approach means that you’re not just an employee; you’re a valued member of a community that values relationship building, authenticity, and doing the right thing. We’ve been sharing joy across the globe, with growing teams in Boise, ID, Redwood City, CA, Dublin, IE, and Manila, PH. Now, we’re excited to welcome talent from Mexico!

Our Mission:

Create Joy Together. Join us in empowering our team and partners to love what they do. At Balsam Brands, we’re about more than just the products we sell; we’re about creating experiences that inspire meaningful moments with family and friends. Your work will contribute to our larger mission of giving back to our families and communities in impactful ways.

When you join Balsam Brands, you’re not just joining a company; you’re joining a culture of caring and interesting people doing challenging work to grow together to delight our customers. Together, we’re building a workplace where everyone feels welcome, supported, and encouraged to bring their best selves to work every day.

As a Tech Lead, you will design and develop scalable data warehousing solutions while serving as the pod’s technical authority and owning technical delivery within its domain. You will remain hands‑on in building and optimizing data solutions using Snowflake, dbt, and Python, while guiding technical decisions, developing engineers, and ensuring reliable delivery. You will partner with Product on pod commitments and provide capacity insights and technical risks to Engineering and Program leaders. Program Managers own cross‑pod initiative delivery and sequencing.

This full-time position reports to the Director of Data Engineering and has been categorized as a teleworker position. Teleworkers do not have a permanent corporate office workplace and, instead, work from home. It is required for teleworkers to reside in Mexico, as we will require attendance for occasional in‑person events. To ensure sufficient overlap with functional and cross-functional team members globally, some flexibility with this role’s regular work schedule will be required. Most of our teams have overlap with early morning and/or early evening PST. Specific scheduling needs for this role will be discussed in the initial interview.

What you’ll do:

• Design and implement robust, scalable, and high-performance data solutions using Snowflake, dbt and Python
• Lead the migration of existing data platforms to Snowflake, ensuring minimal disruption to business operations
• Manage the full lifecycle of data within Snowflake, from ingestion and storage to analytics and reporting
• Conduct performance tuning and troubleshooting of the Snowflake environment to ensure optimal efficiency
• Be accountable for building and maintaining the data infrastructure for the organization
• Collaborate with systems analysts and cross functional partners to understand data requirements
• Champion data warehouse, create denormalized data foundation layer and normalized data marts
• Define strategies to capture all data sources and impact of business process changes on data coming from those sources
• Work on all aspects of the data warehouse/BI environment including architecture, design, development, automation, caching and performance tuning
• Build required infrastructure for optimal extraction, transformation and loading of data from various data sources on Cloud leveraging SQL, data cloud platforms like Snowflake
• Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
• Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
• Continually explore new technologies like Big Data, Artificial Intelligence, Generative AI, Machine Learning, and Predictive Data Modeling

Tech Lead responsibilities:

• Serve as the pod’s technical authority, approving solution designs, including AI-generated outputs, and ensuring architectural standards, engineering quality, and production readiness.
• Own pod-level technical delivery, providing reliable estimates, aligning commitments with Product, and sequencing work to deliver against plan.
• Maintain a healthy Kanban workflow through work-in-progress discipline, blocker resolution, and AI-enabled automation that reduces coordination overhead.
• Own the pod’s capacity view, proactively surfacing risks and trade-offs to Engineering and Program leaders; triage production issues and determine immediate action, escalation, or backlog placement.
• Develop engineers through technical coaching and feedback, strengthening judgment, accountability, and adoption of agentic development practices.

What you bring to the table:

• 8+ years of professional experience in the data engineering field
• Hands‑on polyglot programming expertise – hands‑on, current Python experience is a must‑have
• Marketing channel data automation, pipeline monitoring and data delivery is strongly preferred
• Proficiency in Multi cloud platform like Azure, AWS and/or GCP
• Proficiency in designing and implementing data pipelines using diverse data sources including databases, APIs, external data providers, and streaming sources
• Demonstrated history of designing efficient data models using Medallion Architecture
• Deep understanding and experience with relational (SQL Server, Oracle, Postgres and MySQL) and NoSQL databases
• Experience building and supporting REST APIs for both inbound and outbound data workflows
• Proficiency and solid grasp of distributed system concepts to design scalable and fault tolerant data architectures
• Excellent critical thinking to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
• Excellent analytic skills associated with working on structured and unstructured datasets
• Ability to build processes that support data transformation, workload management, data structures, dependency and metadata
• Ability to build and optimize data sets, ‘big data’ data pipelines and architectures
• Ability to understand and tell the story embedded in the data at the core of our business
• Ability to communicate with non‑technical audience from a variety of business functions
• Strong knowledge of coding standards, best practices and data governance
• Demonstrated ability to lead technical delivery, provide estimates, assess team capacity, and coach engineers; familiarity with Kanban workflows and AI-assisted development practices
• Advanced English proficiency (B2–C1 or higher)

We offer:

• We welcome new ideas and allow you to make an immediate impact on the team.
• Accrual-based Paid Time Off (PTO for any reason, including sick days), plus paid national holidays and a flexible work schedule.
• Personal laptop.
• Health and wellness package.
• Fully remote.

As this is an English-speaking role, we kindly ask that all applications be submitted with a CV in English.