CAPS Payroll Logo

CAPS Payroll

Senior Data Engineer

Posted 13 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
In-Office or Remote
92K-164K Annually
Senior level
92K-164K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Senior Data Engineer responsible for Epic and EHR integrations supporting value-based care, risk and quality workflows, member attribution, roster management, and care-gap tools. The role designs and executes EHR development tasks, coordinates with clinical, data, operations, and development teams, documents business and data flows, evaluates AI and automation opportunities, and develops reporting to identify data-quality issues and prevent outages.
Top Skills: Ai ToolsCaboodleClarityEhr IntegrationsEpicHealthy PlanetSQL
6 Days Ago
Remote or Hybrid
United States
165K-235K Annually
Senior level
165K-235K Annually
Senior level
Big Data • Cloud • Productivity • Software • Database • Analytics • Automation
Build and maintain Databricks-based data platforms, including ingestion, transformation, storage, governance, data modeling, and serving pipelines. Establish medallion architecture standards, canonical data models, quality controls, lineage, schema evolution, and reliable batch or incremental processing. Improve pipeline observability, scalability, idempotency, and recoverability while moving curated data to systems such as ClickHouse. Collaborate across application and analytics teams to create durable, governed production datasets.
Top Skills: Amazon AuroraAmazon RdsApache AirflowSparkBigQueryCdcClickhouseCloud Object StorageDatabricksDelta LakeIamOpenmetadataPostgresSnowflakeUnity Catalog
10 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

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account