Balsam Brands is a global eCommerce retailer with roots in holiday and home décor. Our flagship brand is Balsam Hill™, the world’s leading retailer of artificial Christmas trees and holiday décor. We strive for excellence in everything we do and present a unique opportunity for those seeking to have an impact in a people-first company that values relationship-building, authenticity, and doing the right thing. We have steadily growing teams in Boise, the Bay Area, Canada, Ireland, and the Philippines. 

The company's mission is to create joy together. We empower our team and partners to love what they do, provide products and experiences that inspire meaningful moments with family and friends, and give back to our communities. When you join Balsam Brands, you’ll find a culture of caring people doing challenging work while building a welcoming workplace.

• Balsam Brands on LinkedIn: http://www.linkedin.com/company/balsam-brands/
• Balsam Brands on Instagram: https://www.instagram.com/balsam_brands/
• Balsam Brands in Forbes: https://bit.ly/balsambrandsforbes

At Balsam Brands, we like to think of our people-first culture as more than just a tagline. It's the heart of our company. In fact, our Philippine ROHQ being recognized as one of the Philippine’s Best Work Places by the prestigious Great Place To Work organization is a testament to this. 

We know that you need to feel comfortable in your work environment, so we make sure that everyone in the team is supported and cared for. Team Manila has been working from home since 2010, with occasional in-person meet-ups and events to help build relationships and foster camaraderie. 

Team Manila represents nearly every function in the company—from Marketing to Operations and everything in between. Everyone gets to enjoy company-issued laptops and full employee benefits, including HMO coverage, mental health support, paid time off, 13th-month pay, and many more. The company trips, wellness benefits, and other perks are just the cherry on top of our permanent work-from-home setup.

• Balsam International on Facebook: https://www.facebook.com/BalsamInternationalPH
• Balsam International on LinkedIn: https://www.linkedin.com/company/balsam-international-unlimited

At Balsam International, we strive to build a diverse, equitable, and inclusive team to fulfill our purpose to create joy together. Balsam International is proud to be an equal opportunity employer. We encourage people from all backgrounds, ages, abilities, and experiences to apply. We do not discriminate on the basis of race, ethnicity, religion, national origin, citizenship, marital or family status, disability, sexual orientation, gender identity or expression, pregnancy or caregiver status, or any other legally protected status. We will ensure that individuals with disabilities are provided reasonable accommodations to participate in the job application and interview process, to perform essential job functions, and to receive other benefits and privileges of employment.

Balsam International is looking for a Senior Data Engineer who will be responsible for designing and developing robust, scalable data warehousing solutions. This role reports to the Senior Manager of Data Engineering and focuses on building data solutions aligned with business requirements. Responsibilities include the retrieval, transformation, storage, and delivery of data while adhering to established standards and best practices, coding, and providing production support for the enterprise data warehouse. Our ideal candidate is a skilled data wrangler who enjoys building data solutions from the ground up and optimizing their performance.

What you’ll be doing:

Data Architecture & Infrastructure Development

• Design and implement robust, scalable, and high-performance data solutions using Snowflake, dbt, and Python.
• Be accountable for building and maintaining the organization’s data infrastructure.
• Champion the data warehouse by creating denormalized data foundation layers and normalized data marts.
• Work on all aspects of the data warehouse/BI environment including architecture, design, development, automation, caching, and performance tuning.
• Build infrastructure for optimal extraction, transformation, and loading (ETL) of data from various sources using SQL and cloud data platforms like Snowflake.
• Define strategies to capture all data sources and assess the impact of business process changes on data inputs.

Data Platform Management & Optimization

• 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.
• Identify, design, and implement 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.
• Work with stakeholders including Executive, Product, Data, and Design teams to support data infrastructure needs and resolve data-related technical issues.

Innovation & Continuous Improvement

• Continually explore emerging technologies such as Big Data, Artificial Intelligence, Generative AI, Machine Learning, and Predictive Data Modeling to enhance data capabilities.

Performs other duties that may be assigned from time to time.

What we’re looking for:

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

Location: The Senior Data Engineer position is a remote working position for Balsam International Unlimited Philippine ROHQ in Manila. Team members in the Philippines are located within Metro Manila, Bataan, Batangas, Bulacan, Cavite, Laguna, Pampanga, Rizal, and Tarlac areas only.

Our must-haves:

• Must attend occasional in-person meetings.
• Must have a fast, reliable DSL, Fiber, or Broadband connection (not mobile or broadband stick) as the primary internet connection with a minimum actual speed of 50MBPS.

Note: An online assessment will also be part of the recruitment process.

Status: This is a full-time, permanent position with benefits.

Hardware Provision: Company-issued Laptop will be provided on your first day.

At Balsam International, we strive to offer a competitive compensation and benefits package. For permanent, full-time team members, this includes:

• Government-mandated Benefits (SSS, PAG-IBIG, PhilHealth)
• 13th Month Pay
• Paid Leaves. We use time off to rest, go on vacation, or just sleep in! Our paid time off is flexible to our needs.
• Internet Subsidy. With internet allowance, we are set up for success.
• Healthcare Coverage (+ 2 dependents). We worry less about rising medical costs with flexible quality healthcare benefits.
• Maternity, Paternity, and Solo Parent Benefit. We make sure parents are supported while they navigate work and family life.
• Continuous Learning and Professional Development Benefit. Our professional and personal development are fully supported. Whether it be online courses, workshops or books!
• Mental Health Support. We manage work and life's challenges through Mental Health Day breaks, 24/7 professional counselling, and curated webinars.
• Company Incentive. An additional cash-based perk for all our Brandits based on company's performance.
• Meeting and Team Building Allowance. Happy tummies make our meetings more fun and productive!
• Shutdown Week. We can spend more time on things that matter with an additional one-week paid time off on top of paid leaves.
• Volunteer Time Off. With two paid days off, we are able to volunteer for advocacies we believe in.
• Bereavement Leave. We get additional paid leaves when a loved one passes to grieve and provide immediate support to our families.