BI Data Engineer

Essor, where brands take flight. We find digital challenger brands and supercharge them into iconic global legends that consumers love. As a next-generation consumer products platform, we leverage technology, industry expertise, and strategic collaborations to ignite growth and launch brands beyond expectations.

Essor’s brand portfolio today includes a broad range of rapidly growing health & wellness and lifestyle brands like Boka, ZitSticka, Puracy, OTOTO Design, FreshCap, Iron Flask, Fullstar, NumNum, Key Nutrients, and Viking Revolution that are sold on Amazon, Direct to Consumer channels, and through national retailers like Target, CVS, and Walmart.

What Youll Do

• Advanced Data Modelling: Lead initiatives to craft and optimize data models, facilitating insightful analytics and reporting.
• Insight Generation: Translate vast data into actionable insights that steer strategic decision-making processes.
• Database Management: Take charge of developing and maintaining databases/data warehouses, guaranteeing the optimal organization and storage of data.
• ETL and Data Pipeline Management: Design and oversee ETL processes and data CI/CD pipelines equipped with QA tests to ensure seamless data extraction, transformation, and loading.
• Collaboration and Integration: Collaborate with cross-functional teams to comprehend and meet their data necessities, merging data from diverse sources to offer a comprehensive view.
• Alert System Management: Set up robust infrastructures and pipelines that feature alert systems for potential issues, safeguarding the integrity of our data systems.
• Documentation and Training: Chronicle your methodologies and findings meticulously, aiding teams in leveraging Looker for a deeper business understanding.
  
  

• From 2-3 years of experience in the Data Engineering domain
• You are passionate about data optimization applying the latest methodologies to increase performance and reduce computing costs.
• Mastery in writing SQL queries, transforming, and modeling data.
• Strong proficiency in Python is needed
• Knowledge of Airflow and orchestration tools (deep expertise not required).
• Able to understand e-commerce operations and bring strategic insights to simplify and connect tools.
• Comfortable being both a data engineer and a scope/product manager—technical and business-savvy.
• High level of organization, impeccable attention to detail, capacity to figure out complex problems without a lot of oversight
• Fluent in English, clear in both written and verbal communication, able to explain complex topics simply
  
  

• Are owners.
• Are continually raising the bar.
• Are sincerely open-minded, and are willing to examine their strongest convictions with humility.
• Nurture and embrace differing perspectives to make better decisions.
  
  

• A supportive, diverse and global team with a growth mindset.
• A scaling company with great industry professionals.
• A flexible (hybrid) working environment.
• Great opportunities to get involved with exciting projects.