Data Engineer for AI Creative Tools — Equity & Hybrid

pika; Palo Alto (CA); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Equity

Health benefits

Monthly stipends

Company retreats

Job summary

Pika, a startup in Palo Alto building AI creative tools, seeks a Data Engineer to design, build, and scale data infrastructure powering the platform. You will work closely with product, engineering, and data teams to ensure data is accurate, reliable, and accessible for users and internal needs.

You will combine software engineering know-how with data architecture, helping build robust, scalable systems that support millions of creators and shape the future of AI-powered media tools.

Qualifications

• 4+ years of experience as a data engineer or in a similar role designing, building, and maintaining data infrastructure.
• Strong software engineering background with Python and SQL proficiency.
• Hands-on experience with data pipeline orchestration tools (Airflow, Prefect, Dagster, etc.).
• Experience with cloud data platforms (AWS/GCP, Redshift, BigQuery, Snowflake, etc.).
• Knowledge of database systems, data modeling, and data warehousing best practices.
• Familiarity with monitoring, logging, and data quality practices for data workflows.
• Excellent analytical and problem-solving skills with attention to detail.
• Great communication skills and ability to work cross-functionally in a collaborative environment.
• Self-motivated, curious, and comfortable in a fast-paced, high-growth startup.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL workflows.
• Build, automate, and optimize data infrastructure for analytics, reporting, and ML applications.
• Ensure data quality, consistency, and security across sources and sinks.
• Collaborate with engineering, analytics, and product teams to define data requirements and deliver reliable datasets.
• Implement monitoring solutions and proactively resolve data pipeline issues.
• Optimize storage and data processing performance for growth and efficiency.
• Contribute to data modeling efforts and schema design for analytics and product needs.
• Help establish best practices and empower a data-driven culture across the organization.

Skills

Python

SQL

Data pipelines

Analytical thinking

Problem solving

Tools

Airflow

Prefect

Dagster

Redshift

BigQuery

Snowflake

Kafka

Kinesis

AWS/GCP

Job description

Pika, a startup in Palo Alto building AI creative tools, seeks a Data Engineer to design, build, and scale data infrastructure powering the platform. You will work closely with product, engineering, and data teams to ensure data is accurate, reliable, and accessible for users and internal needs.

You will combine software engineering know-how with data architecture, helping build robust, scalable systems that support millions of creators and shape the future of AI-powered media tools.