Back to jobs

Senior Data Engineer

Mexico City

Balsam Brands is a global, omnichannel 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!

Why Balsam Brands? Our people-first approach means that 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. 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. You'll join 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.

Ready to be a part of the joy? Explore more about the Senior Data Engineer role below and apply today!

As Senior Data Engineer, will be responsible for designing and developing robust and scalable data warehousing solutions. You will be responsible for building data solutions based on the business requirements. Data solutions may involve retrieval, transformation, storage, and delivery of the data while following standards and best practices, writing code and providing production support for the enterprise data warehouse. Our ideal candidate is a skillful data wrangler who enjoys building data solutions from the ground up and optimizing their performance.

This full-time position reports to the Senior Manager, Data Engineering and has been categorized as a teleworker position. Teleworkers do not have a permanent corporate office workplace and, instead, work from home. 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:

  • Data Architecture & Infrastructure Development
    • Designs and implements robust, scalable, and high-performance data solutions using Snowflake, dbt, and Python
    • Builds and maintains the organization’s data infrastructure
    • Champions the data warehouse by creating denormalized data foundation layers and normalized data marts
    • Works on all aspects of the data warehouse/BI environment including architecture, design, development, automation, caching, and performance tuning
    • Builds infrastructure for optimal extraction, transformation, and loading (ETL) of data from various sources using SQL and cloud data platforms like Snowflake
    • Defines strategies to capture all data sources and assess the impact of business process changes on data inputs
  • Data Platform Management & Optimization
    • Leads the migration of existing data platforms to Snowflake, ensuring minimal disruption to business operations
    • Manages the full lifecycle of data within Snowflake, from ingestion and storage to analytics and reporting
    • Conducts performance tuning and troubleshooting of the Snowflake environment to ensure optimal efficiency
    • Identifies, designs, and implements internal process improvements, such as re-architecting for scalability, optimizing data delivery, and automating manual processes
  • Cross-functional Collaboration & Stakeholder Support
    • Collaborate with systems analysts and cross-functional partners to understand data requirements
    • Works with stakeholders including Executive, Product, Data, and Design teams to support data infrastructure needs and resolve data-related technical issues
  • Innovation & Continuous Improvement
    • Explores emerging technologies continually such as Big Data, Artificial Intelligence, Generative AI, Machine Learning, and Predictive Data Modeling to enhance data capabilities
    •  
  • Other Duties and Responsibilities
    • Performs other duties that may be assigned from time to time

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
  • 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
  • Demonstrated AI literacy, enabling effective understanding, interaction, and critical evaluation of AI technologies and applications across diverse business functions

Location and Travel: At Balsam Brands, we believe that time spent together, in-person, collaborating and building relationships is important. To be considered for this role, it is preferred that candidates live within the Mexico City, Guadalajara, or Monterrey metropolitan areas in order to attend occasional team meetings, offsites, or learning and development opportunities that will be planned in a centralized location. Travel to the U.S. may be required for companywide and broader team retreats.

Notes: This is a full-time (40 hours/week), indefinite position with benefits. Candidates must be Mexican nationals to be eligible for this position; this screening question will be asked during the application process.  Velocity Global is the Employer of Record for Balsam Brands' Mexico City location, and you will be employed and provided benefits under their payroll. Balsam Brands has partnered with Velocity Global to act as your Employer of Record to ensure your employment will comply with all local laws and regulations and you will receive an exceptional employment experience.

Benefits Offered:

  • Competitive compensation; salary is reviewed yearly and may be adjusted as part of the normal compensation review process
  • Career development and growth opportunities; access to online learning solutions and annual stipend for continuous learning
  • Fully remote work and flexible schedule
  • Collaborate in a multicultural environment; learn and share best practices around the globe
  • Government mandated benefits (IMSS, INFONAVIT, SAR, 50% vacation premium)
  • Healthcare coverage provided for the employee and dependents
  • Life insurance provided for the employee
  • Monthly grocery coupons
  • Monthly non-taxable amount for the electricity and internet services
  • 20 days Christmas bonus
  • Paid Time Off: Official Mexican holidays plus Maundy Thursday, Good Friday and Dia de Los Muertos; 12 vacation days (increases with years of service); plus additional wellness days available at start of employment and volunteer time off

 

 

Create a Job Alert

Interested in building your career at Balsam Brands? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Balsam Brands’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.