What you'll do
Build and own the batch pipelines and cubes behind dashboard analytics and agent insights
Model shopper, trend, and benchmark data so the agent can find opportunities across the shopping journey
Shape data for each role: a merchandiser's category, a product manager's funnel step, an executive's total
Own data quality and trust: freshness, monitoring, alerting, and metric definitions
Work with engineers, analysts, and product to find the data the agent is missing and turn merchant questions into data products
Ship your data into the product: simple analytics UIs, and the agent skills, tools, and prompts that use it
Requirements
Must-have
Proficiency in Python and SQL (any dialect)
Experience building and maintaining batch data pipelines with Spark (PySpark)
Familiarity with the big data stack: Databricks, ClickHouse and dbt
Experience with data modeling for analytics: aggregated tables and cubes that feed dashboards and APIs
Experience with data quality and pipeline monitoring: freshness checks, alerting, incident response
Ability to prototype fast and pick the metrics that matter in e-commerce
Ability to translate business questions into technical requirements, and back
Clear communication with engineers and non-technical stakeholders
Nice-to-have
Experience building frontend UIs, or willingness to work across the full stack to ship data into product features
Experience with pandas, NumPy
Experience building AI agents: tools, skills, prompts, context, and evaluations
Experience with real-time analytics: ClickHouse, Cube.js
Experience with AWS
Familiarity with statistics for experimentation (A/B tests)
Benefits
🏝️ Unlimited vacation, with a recommended minimum of 3 weeks per year
🌎 Fully remote team: choose where you live
🛋️ Work-from-home stipend to set up your home office
💻 Apple laptop for new employees
🧑🎓 Annual training and development budget for every employee
👪 Maternity and paternity leave for qualified employees
🧠 Smart colleagues who help you grow and make a meaningful impact
💵 Base salary: 80-120K USD, depending on knowledge, skills, experience, and interview results
📈 Stock options, in addition to the base salary
🎉 Regular team offsites to connect and collaborate
Diversity, Equity, and Inclusion at Constructor
At Constructor.io http://Constructor.io we are committed to cultivating a work environment that is diverse, equitable, and inclusive. As an equal opportunity employer, we welcome individuals of all backgrounds and provide equal opportunities to all applicants regardless of their education, diversity of opinion, race, color, religion, gender, gender expression, sexual orientation, national origin, genetics, disability, age, veteran status or affiliation in any other protected group. Studies have shown that women and people of color may be less likely to apply for jobs unless they meet every one of the qualifications listed. Our primary interest is in finding the best candidate for the job. We encourage you to apply even if you don’t meet all of our listed qualifications.
How we handle your data. By submitting this application, you acknowledge that Constructor will collect and process the personal data you provide for the purpose of evaluating your candidacy for this role. If you are not selected, we will retain your data for a limited period as described in our Recruitment Privacy Notice https://constructor.com/recruitment-privacy-notice. After that period your data will be deleted or anonymized.
