Senior Data Engineer

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!

• →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

• 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