Senior Data Engineer

Cast & Crew; United States; Remote; USD 135,000 - 165,000; Full time

Benefits offered by this job

Medical

Dental

Vision

PTO

Health and wellness programs

Employee discounts

Job summary

Cast & Crew is seeking an experienced Senior Data Engineer to design, build, and operate scalable data platforms that power analytics, reporting, and AI‑driven solutions across the entertainment production ecosystem.

This role focuses on building reliable, cloud‑native data pipelines that ingest, transform, secure, and serve operational data for internal engineering teams, business intelligence, and customer‑facing applications.

Qualifications

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related field.
• 5+ years of experience building production data platforms and pipelines.
• Strong Python development experience.
• Strong SQL development and query optimization skills.
• Experience designing and maintaining ETL/ELT pipelines.
• Experience with relational databases (PostgreSQL, MySQL, Aurora).
• Experience with NoSQL databases (DynamoDB, MongoDB, document databases).
• Experience building data lakes and cloud-native data architectures.
• Experience with cloud data warehouses (Snowflake, BigQuery, Redshift).
• Experience with AWS services (S3, Lambda, ECS/EKS, IAM).
• Experience with streaming data and message systems (Kafka, Kinesis, SNS/SQS).
• Experience with Airflow, Prefect, or Dagster for orchestration.
• Experience with CI/CD pipelines (Azure DevOps, GitHub Actions).
• Experience building highly available, scalable production systems.
• Strong understanding of data modeling, partitioning, indexing, and performance optimization.

Responsibilities

• Design, build, and operate scalable data platforms and pipelines.
• Develop cloud-native data architectures for analytics and AI workloads.
• Ingest, transform, secure, and serve operational data for internal teams.
• Collaborate with software engineers, platform teams, and data consumers.

Skills

Python

SQL

ETL/ELT pipelines

Data modeling

Data pipelines

AWS

Kafka

Airflow

Git

CI/CD

Education

Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related field

Tools

Airflow

Git

Dagster

Snowflake

BigQuery

Redshift

Job description

About Us

At Cast & Crew, we’ve empowered creativity and supported the global entertainment industry for decades. Together with our family of brands - Backstage, CAPS, Checks & Balances, Final Draft, Media Services, Sargent-Disc, and The TEAM Companies – we operate as a combined entertainment technology and services provider offering industry standard screenwriting accounting software, digital payroll products, data & reporting, and a host of creative tools. The industry continues to move faster than ever, and the need for our expertise, our technology, and our people has never been greater. We are a production’s best ally every step of the way.#OneCastOneCrew

At Cast & Crew, engineers own the systems they build and operate. Our platforms support mission-critical workflows across the entertainment industry, where reliability, scalability, and accountability matter. We hire engineers who take ownership, solve problems end-to-end, automate wherever possible, and continuously raise the bar for engineering excellence.

Summary

Cast & Crew is seeking an experienced SeniorData Engineerto design, build, and operate scalable data platforms that power mission-critical applications, analytics, reporting, and AI-driven solutions across the entertainment production ecosystem.

This role focuses on building reliable, cloud-native data pipelines that ingest, transform, secure, and serve operational data for internal engineering teams, business intelligence, and customer-facing applications. You will work across structured and semi-structured data, enabling modern analytics, AI workloads, and real-time event processing.

You will collaborate closely with software engineers, platform engineers, product teams, and data consumers while leveraging AI-assisted development tools to accelerate delivery and improve engineering productivity.

Required Qualifications

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related field

• 5+ years of experience building production data platforms and pipelines

• Strong Python development experience

• Strong SQL development and query optimization skills

• Experience designing and maintaining ETL/ELT pipelines

• Experience working with relational databases (PostgreSQL, MySQL, Aurora)

• Experience working with NoSQL databases (DynamoDB, MongoDB, document databases)

• Experience building data lakes and cloud-native data architectures

• Experience with Snowflake, BigQuery, Redshift, or similar cloud data warehouses

• Experience with AWS cloud services including S3, Lambda, EventBridge, DynamoDB, ECS/EKS, and IAM

• Experience building event-driven and streaming data solutions

• Experience working with Kafka, SNS/SQS, Kinesis, or similar messaging technologies

• Experience with data orchestration tools such as Airflow, Prefect, or Dagster

• Experience with Git and modern CI/CD pipelines (Azure DevOps, GitHub Actions, or similar)

• Experience building highly available, scalable production systems

• Strong understanding of data modeling, partitioning, indexing, and performance optimization

• Experience monitoring and operating production data platforms

Nice to Have

• Experience with Apache Spark or distributed processing frameworks

• Experience with Debezium, CDC, or change data capture architectures

• Experience with Iceberg, Delta Lake, or modern lakehouse technologies

• Experience with OpenSearch or Elasticsearch

• Experience supporting AI and machine learning data platforms

• Experience building feature stores or vector databases

• Experience with document processing (OCR, Textract, PDF extraction)

• Experience in media, payroll, financial systems, or enterprise SaaS platforms

• Experience using AI-assisted development tools such as Claude Code or GitHub Copilot

What You Will Build

• Enterprise-scale data ingestion and transformation pipelines

• Cloud-native data platforms supporting analytics and operational workloads

• Real-time event-driven data processing solutions

• Data models supporting reporting, AI, and customer-facing applications

• Secure, scalable integrations between enterprise systems

• Automated monitoring, testing, and deployment pipelines for data infrastructure

What Success Looks Like

• Highly reliable and scalable production data pipelines

• High-quality, trusted data powering operational and analytical systems

• Low-latency, automated data movement across enterprise platforms

• Engineering best practices including automation, observability, and testing

• Strong collaboration with software engineering and platform teams

• Continuous improvement through AI-assisted development and automation

Special Work Conditions

• Sedentary – Involves sitting most of the time but may involve walking or standing for brief periods of time. Some positions may entail exerting up to 15 lbs. of force occasionally and/or a negligible amount of force to lift, carry, push, or pull.

What We Offer

Cast & Crew provides a comprehensive package of employee benefits including: Medical, Dental, Vision, PTO, health and wellness programs, employee discounts, and more! Note: Cast & Crew benefits are subject to eligibility requirements.

Cast & Crew is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.

CA residents
Your personal information may be collected in connection with certain services provided by Cast & Crew or its affiliated companies. A summary of your California privacy rights can be found at: https://www.castandcrew.com/privacy-policy/

Compensation is commensurate with various factors including, but not limited to, relevant experience, qualifications, skills, training, licensure, certifications, geographic cost of labor, and other business and organizational needs. Compensation range for candidates in other locations may differ based on the cost of labor in that location. The compensation range for this position is: $135,000.00 - $165,000.00 per year.