Data Engineer - AI-Driven Analytics & Dashboards (Remote)

Constructor; San Francisco (CA); Remote; USD 80,000 - 120,000; Full time

Benefits offered by this job

Unlimited vacation

Fully remote team

Work-from-home stipend

Apple laptop for new employees

Annual training budget

Parental leave

Stock options

Team offsites

Job summary

Constructor.io is hiring a data/analytics engineer to design and own batch data pipelines and data products that power dashboard analytics and the AI agent’s insights. You will model shopper trends, shape role-based data views, and ensure data freshness and trust across analytics surfaces.

You will collaborate with engineers, analysts, and product teams to turn merchant questions into concrete data solutions, shipping analytics UIs and agent capabilities that drive e-commerce growth.

Qualifications

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

Responsibilities

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

Skills

Python

SQL

Spark (PySpark)

Data modeling

Data quality

Communication

Frontend UIs (nice-to-have)

Pandas

NumPy

Tools

Databricks

ClickHouse

dbt

Job description

Constructor.io is hiring a data/analytics engineer to design and own batch data pipelines and data products that power dashboard analytics and the AI agent’s insights. You will model shopper trends, shape role-based data views, and ensure data freshness and trust across analytics surfaces.

You will collaborate with engineers, analysts, and product teams to turn merchant questions into concrete data solutions, shipping analytics UIs and agent capabilities that drive e-commerce growth.