Data Engineer (Fully Remote)

Constructor; United States; Remote; USD 120,000 - 190,000; Full time

Benefits offered by this job

Unlimited vacation

Remote work stipend

Apple laptop

Annual training budget

Stock options

Team offsites

Job summary

Constructor is seeking a data-engineering oriented role focused on analytics pipelines and data modeling for an ecommerce insights platform. You will build batch pipelines, own data cubes, and support dashboards that reveal agent insights and opportunities across the shopping journey.

You will work with Python, SQL, Spark (PySpark), Databricks and dbt in a fully remote environment with a work-from-home stipend and ongoing training. Stock options and offsites are part of the package.

Qualifications

• Proficiency in Python and SQL; able to write clean, scalable queries.
• Experience building and maintaining batch data pipelines with Spark (PySpark).
• Familiarity with Databricks, ClickHouse and dbt in a production setting.

Responsibilities

• Build and own batch pipelines and cubes behind dashboard analytics and agent insights.
• Model shopper, trend, and benchmark data for opportunities across the shopping journey.
• Shape data for each role, from merchandiser categories to executive-level totals.

Skills

Python

SQL

PySpark

Tools

Databricks

ClickHouse

dbt

Job description

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

Requirements:

• 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.
• Unlimited vacation with a recommended minimum of 3 weeks per year.
• Fully remote team, work-from-home stipend, and Apple laptop.
• Annual training and development budget, stock options, and regular team offsites.

Constructor

Constructor is an AI-first e-commerce search and discovery platform that helps shoppers find the right products and enables global e-commerce brands to drive revenue and conversion gains. With a remote team and a culture of growth and collaboration, they offer unlimited vacation, training budgets, and regular offsites.