Founding Data Engineer (Core Data Platform)

Department: OpenArt

Location: San Francisco Bay Area

Employment Type: FullTime

🎨 About OpenArt

OpenArt is an AI Storytelling and Visual Creation Platform used by millions worldwide. We’re building the next generation of creative tools powered by cutting-edge AI, enabling anyone to create videos, visuals, characters, and stories with unprecedented speed and imagination. We believe the future of creativity is AI-native, and we’re shaping that future.

🚀 Why Join OpenArt

• Own the entire data foundation of a fast-scaling AI company — from raw data to executive metrics.

• Build from 0 → 1 — define the architecture that powers product, finance, and company-wide decision making.

• High visibility and impact — your work directly informs leadership, product direction, and company strategy.

• Founder-led, fast-moving culture — high ownership, low process, high trust.

• AI-native company — help define how data supports AI systems, agents, and long-term intelligence.

• 7–10X revenue growth over the past 2 years — now scaling the data layer to match.

🎯 About the Role

We’re looking for a Founding Data Engineer to build and own OpenArt’s core data platform and source of truth, supporting product, finance, and leadership decision-making.

This is a 0 → 1 role focused on data reliability, modeling, and long-term scalability — not just analytics or dashboarding.

You will define how data is structured, validated, and served across the company — ensuring that key metrics are consistent, trusted, and production-grade.

You’ll work closely with the Head of Data, engineering, and leadership to establish a robust data foundation that scales with the company.

🛠 What You’ll Do

• Design and build core data pipelines (e.g., product events, payments, internal systems → BigQuery)

• Define and maintain the data warehouse architecture, including schema design, data modeling, and table structure

• Establish and own the single source of truth (SOT) for product and business metrics

• Build and maintain core data models (user, subscription, revenue, engagement, etc.)

• Ensure data consistency across systems (product analytics, billing, internal tools)

• Lead data reconciliation efforts (e.g., Stripe vs internal systems vs reporting)

• Implement data quality checks, validation, and monitoring systems

• Build reliable reporting layers used by leadership and finance (not ad hoc dashboards)

• Establish data standards and contracts (event naming, schema governance, tracking consistency)

• Partner with engineering to improve instrumentation and data correctness at source

• Support downstream teams (analytics, DS) by providing clean, well-documented datasets

• Continuously improve data reliability, performance, and cost efficiency

🧑‍💻 What We’re Looking For

Core Requirements

• 5+ years of experience in data engineering or analytics engineering

• Proven experience building data platforms or warehouses from 0 → 1

• Strong SQL and Python — you write clean, production-quality data code

• Deep expertise in data modeling, ETL/ELT design, and warehouse architecture

• Experience with modern data stack:

  • BigQuery / Snowflake / Redshift

  • dbt or similar transformation tools

  • Workflow orchestration tools (Airflow / Prefect or similar)

• Experience working with financial and product data (e.g., payments, subscriptions, usage data)

• Strong understanding of data reliability, testing, and validation

• Ability to translate business definitions into durable, consistent data models

• High ownership — you can define and drive architecture decisions independently

• Comfortable operating in ambiguous, fast-moving environments

Nice to Have

• Experience building data systems for finance or revenue reporting

• Experience with data reconciliation across multiple systems

• Familiarity with BI tools (Metabase, Looker, etc.)

• Experience designing semantic layers or metric definitions

• Prior experience as an early or founding data hire

⚙ Tech Stack You’ll Work With

BigQuery, dbt (or similar), Airbyte/Fivetran (or custom pipelines), Metabase, Amplitude, Stripe, Python, SQL, GCP

💰 Compensation

• Competitive base salary and bonus program

• Equity — meaningful ownership in what you build

• High autonomy, high growth environment

🌍 Work Setup

• Bay Area preferred (hybrid allowed)

• Visa sponsorship available

• We’ll consider remote