Data Engineer for AI Creative Platform

Engg; United States; Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Comprehensive health benefits

Monthly stipends

Company retreats

Job summary

Pika is hiring a Data Engineer to design, build, and scale the data infrastructure powering our AI creative platform. You will architect data pipelines, analytics systems, and data models to enable reliable, data-driven decisions for millions of creators.

You will work with product, engineering, and data teams to ensure data quality, security, and accessibility while leveraging AWS/GCP, Redshift, BigQuery, and Snowflake.

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 proficiency in Python, SQL, and/or similar languages.
• 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.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL workflows.
• Build, automate, and optimize our data infrastructure for analytics, reporting, and machine learning applications.
• Ensure data quality, consistency, and security across all 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

Data quality

Communication

Tools

Airflow

Dagster

Prefect

Redshift

BigQuery

Snowflake

Postgres

Kubernetes

Job description

Pika is hiring a Data Engineer to design, build, and scale the data infrastructure powering our AI creative platform. You will architect data pipelines, analytics systems, and data models to enable reliable, data-driven decisions for millions of creators.

You will work with product, engineering, and data teams to ensure data quality, security, and accessibility while leveraging AWS/GCP, Redshift, BigQuery, and Snowflake.