Founding Data Engineer Core Data Platform

## 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