Senior Data Engineer

Company 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!

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!

Job Description

In this hands-on role as a Senior Data Engineer, your primary responsibility will be to partner with key business partners, data analysts and software engineers to design and build a robust, scalable, company-wide data infrastructure to move and translate data that will be used to inform strategic business decisions. You will ensure performance, stability, cost-efficiency, security, and accuracy of the data on the centralized data platform. The ideal candidate will possess advanced knowledge and hands-on experience in data integration, building data pipelines, batch processing frameworks, and data modeling techniques to facilitate seamless data movement. You will collaborate with various technology and business stakeholders to define requirements and design and deliver data products that meet user needs. The candidate should demonstrate intellectual acumen, excel in engineering best practices, and have a strong interest in developing enterprise-scale solutions using industry-recognized cloud platforms, data warehouses, data integration and orchestration tools.

This full-time position reports to the Senior Manager, Data Engineering and requires in-office presence twice a week (Tuesdays and Wednesdays) to facilitate effective collaboration with both local and remote team members. Some flexibility in the regular work schedule is necessary, as most teams have overlapping hours in the 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 Infrastructure Design: Develop and maintain robust, scalable, and high-performance data infrastructure to meet the company-wide data and analytics needs
• Data Lifecycle Management: Manage the entire data lifecycle, including ingestion, modeling, warehousing, transformation, access control, quality, observability, retention, and deletion
• Strategic Data Movement: Define and implement data integration strategies to collect and ingest various data sources. Design, build and launch efficient and reliable data pipelines to process data of different structures and sizes using Python, APIs, SQL, and platforms like Snowflake
• Collaboration and Consultation: Serve as a trusted partner to collaborate with technical and cross-functional teams to support their data needs, address data-related technical issues, and provide expert consultation
• Process Efficiency and Stability: Apply engineering best practices to streamline manual processes, optimize data pipelines, and establish observability capabilities to monitor and alert data quality and infrastructure health and stability
• Innovative Solutions: Stay updated on the latest technologies and lead the evaluation and deployment of cutting-edge tools to enhance data infrastructure and processes
• Coaching and Mentorship: Foster a culture of knowledge sharing by acting as a subject matter expert, leading by example, and mentoring others

What you bring to the table:

• Must be fluent in English, both written and verbal
• 8+ years of professional experience in the data engineering
• Extensive hands-on experience with designing and maintaining scalable, efficient, secure and fault tolerant distributed database on Snowflake Cloud Data Platform. In-depth knowledge on cloud platforms, particularly GCP and Microsoft
• Proficient in designing and implementing data movement pipelines for diverse data sources including databases, external data providers, and streaming sources, for both inbound and outbound data workflows
• Deep understanding of relational database (SQL Server, Oracle, Postgres, and MySQL) with advanced SQL and Python skills for building API integration, ETLs, and data models
• Proven experience in building efficient and reliable data pipelines with comprehensive data quality checks, workflow management, and CI/CD integration
• Excellent analytical thinking skills for performing root cause analysis on external and internal processes and data, resolving data incidents, and identifying opportunities for improvement
• Effective communication skills for articulating complex technical details in simple business terms to non-technical audience from a various business function
• Strong understanding of coding standards, best practices, and data governance

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.

• Check out our flagship brand, Balsam Hill: www.balsamhill.com
• Balsam Brands in Forbes: https://bit.ly/balsambrandsforbes2023 
• LinkedIn: http://www.linkedin.com/company/balsam-brands/
• Glassdoor: https://bit.ly/balsambrands-glassdoor

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 

Additional Information

All your information will be kept confidential according to EEO guidelines.