CAPS Payroll Logo

CAPS Payroll

Senior Data Engineer

Posted 5 Days Ago
Remote
Hiring Remotely in United States of America
135K-165K Annually
Senior level
Remote
Hiring Remotely in United States of America
135K-165K Annually
Senior level
Design, build, and operate scalable cloud-native data platforms and pipelines supporting analytics, reporting, AI workloads, and customer-facing applications. Develop ETL/ELT processes, data lakes, event-driven and streaming solutions, data models, enterprise integrations, and automated monitoring and deployment systems. Collaborate with software, platform, product, and data teams to ensure reliable, secure, high-performance production systems.
The summary above was generated by AI

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 Senior Data Engineer to 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.

Similar Jobs

2 Days Ago
Remote or Hybrid
United States
Senior level
Senior level
AdTech • Consumer Web • Digital Media • eCommerce • Marketing Tech • SEO
Build and support scalable data platforms and pipelines, leading migrations such as Snowflake to BigQuery and transitioning reporting to Looker. Responsibilities include data architecture, ETL/ELT, API and marketing integrations, data quality, production troubleshooting, warehousing, performance optimization, and platform modernization. The role partners with analytics and business teams, owns projects through production, documents solutions, and provides technical guidance.
Top Skills: AWSAzureBigQueryConfluenceDraw.IoGCPGitJIRAKafkaLookerLucidchartMiroModeNotionPower BIPythonSnowflakeSparkSQLTableauTalend
4 Days Ago
Remote or Hybrid
17 Locations
110K-200K Annually
Senior level
110K-200K Annually
Senior level
Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Design and scale lakehouse architecture, including Bronze, Silver, and Gold data layers. Build reliable streaming and batch pipelines with Kafka, Spark, and Airflow; manage Iceberg, Delta, and Hudi table formats; optimize Trino, Starburst, and Databricks queries; and improve platform reliability, data quality, and performance. Collaborate with data scientists, analysts, and product teams to deliver scalable data platform solutions.
Top Skills: Apache AirflowApache HudiApache IcebergApache KafkaSparkDatabricksDelta LakeLakehouse ArchitectureMedallion ArchitecturePythonSQLStarburstTrino
4 Days Ago
Remote or Hybrid
17 Locations
110K-200K Annually
Senior level
110K-200K Annually
Senior level
Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Design and scale lakehouse architecture, streaming and batch pipelines, and reliable data platforms using Kafka, Spark, Airflow, Iceberg, Databricks, and related technologies. Build Medallion-layer data systems, manage open table formats, optimize distributed queries, monitor platform reliability, resolve data quality issues, and collaborate with analysts, data scientists, and product teams.
Top Skills: Apache AirflowApache HudiApache IcebergApache KafkaSparkDatabricksDelta LakePythonSQLStarburstTrino

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account