Tech Lead Data Engineer for Balsam Brands

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. Why Balsam Brands?
At Balsam Brands, we're not just a company. At Balsam Brands, we're about more than just the products we sell; When you join Balsam Brands, you're not just joining a company; 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. 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. Most of our teams have overlap with early morning and/or early evening PST. 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 redesigning 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.
Maintain a healthy Kanban workflow through work-in-progress discipline, blocker resolution, and AI-enabled automation that reduces coordination overhead.
triage production issues and determine immediate action, escalation, or backlog placement.
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
~ Extensive experience in designing, developing Snowflake Cloud Data Platform
~ 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
~ 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
~ Strong knowledge of coding standards, best practices and data governance
~ Advanced English proficiency (B2-C1 or higher)

We welcome