MIA Data Engineer - Merchant Intelligence Team (Remote)

Constructor is the only search and product discovery platform tailor-made for enterprise ecommerce where conversions matter. Constructor's AI-first solutions make it easier for shoppers to discover products they want to buy and for ecommerce teams to deliver highly personalized experiences that drive impressive results. Optimizing specifically for ecommerce metrics like revenue, conversion rate and profit, Constructor generates consistent $10M+ lifts for some of the biggest brands in ecommerce, such as Sephora, Petco, home24, Maxeda Brands, Birkenstock and The Very Group. Constructor is a U.S. based company that was founded in 2015 by Eli Finkelshteyn and Dan McCormick. For more, visit: https://constructor.com/

We specialize in developing a cutting-edge search and discovery platform, encompassing search, autocomplete, browse, and recommendations, tailored specifically for online retailers, suppliers, and shops. Our goal is to provide all online stores with the ability to have state-of-the-art product discovery powered by AI that optimizes for the key e-commerce metrics, which differentiates us from our competitors.

Boasting a robust infrastructure, we handle billions of requests daily and manage a vast data ecosystem, including ~400 GB of data intake daily and approximately 2PB stored in our data lake.

Merchant Intelligence Team

An important part of our product is the customer dashboard that helps merchandizers to analyze shopping behavior and manually adjust algorithmic results. The goal of the Merchant Intelligence team is to:

• Help merchandizers achieve their e-commerce goals, increasing satisfaction with their sites and retention of customers.
• Provide insights to merchants they can't get anywhere else.
• Become a critical point of merchant planning, decision making, and analysis so we become a sticky part of their organization.

Challenges you will tackle

• Enhance the dashboard experience for merchandizers by building analytics that provide actionable insights to improve e-commerce KPIs.
• Perform data exploration and research user behavior.
• Implement end-to-end data pipelines to support real-time analytics for essential business metrics.
• Take part in product research and development, iterate with prototypes and customer product interviews.

• You are proficient in BI tools (both data analysis and building dashboards for engineers and non-technical folks).

• You are keen to not just prepare more data, but to think critically about how that data can deliver valuable insights and drive impactful decisions for non-technical end users.
• You are an excellent communicator with the ability to translate business requests into technical language and vice versa.
• You are excited to leverage massive amounts of data to drive product innovation and deliver business value.
• You are proficient at SQL (any variant) and well-versed in exploratory data analysis with Python (pandas & numpy, data visualization libraries)
• Practical familiarity with the big data stack (Spark, Hive, Databricks).
• You are adept at fast prototyping and providing analytical support for initiatives in the e-commerce space by identifying and focusing on relevant features and metrics.
• You are willing to develop and maintain effective communication tools to report business performance and inform decision-making at a cross-functional level.
• You get excited to hear feedback from customers and figure out potential solutions.
• You're familiar with math statistics.
• Stack: python, SQL, pyspark, clickhouse, cubejs, docker, git