Data Engineer II - Insights, Strategy & Analysis
Backend Developer
3d Design Tools
Big Data
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Operations
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
ETL
Google Cloud Bigquery
Informatica
Information Technology (IT)
Rendering Engines
Reporting and Analytics
Snowflake
SQL
Job Description
Join Sony Pictures Entertainment’s Insights, Strategy and Analytics (ISA) organization and help power analytics, reporting, and AI/ML use cases with reliable, scalable ELT pipelines. This Data Engineer II role focuses on designing and building data foundations that support strategic decision-making, including ingestion into Sony Pictures’ Snowflake platform. You will collaborate with cross-functional partners to deliver datasets and tools that keep business metrics consistent, trustworthy, and ready for downstream consumption. The position is based in Culver City, CA (hybrid).
What you’ll do
- Translate complex business requests into robust data models, business metrics, and semantic layers using dbt and SQL to improve maintainability, reliability, and performance.
- Support ingestion of new sources into SPE’s Snowflake data platform by partnering with central IT and cloud operations teams to define ingestion requirements and validate pipelines against business needs, while adhering to SPE data governance and security policies.
- Work with product managers, strategic analysts, data scientists, data visualization teams, and business stakeholders to deliver impactful tools by harmonizing data from disparate systems and creating ready-to-use datasets for reporting, advanced analytics, and decision-making.
- Contribute to a high-performance team through open collaboration that builds a culture of ownership, accountability, and continuous improvement.
What you bring
- Bachelor’s or Master’s degree in Computer Science, Data Science, Business Analytics, or a related field (advanced degrees are a plus).
- 5+ years in analytics engineering, data engineering, or another related technical role in a production environment.
- Experience supporting data for television, film, streaming, AVOD, FAST channels, content distribution, audience analytics, or media strategy.
- Familiarity with studio-relevant business entities, metrics, and datasets, including content and title metadata, audience measurement, ratings, content performance, talent, production, licensing, and distribution datasets. Experience with industry data providers such as IMDb, Gracenote, Luminate, Nielsen, or similar sources is highly desirable.
- Advanced SQL and Python; strong preference for experience building transformation pipelines with dbt.
- Proficiency with modern cloud data platforms such as Snowflake, GCP/BigQuery, or AWS/Redshift, plus experience with pipeline orchestration tools.
- Familiarity with CI/CD, version control, and automated testing frameworks to meet data quality standards.
- Exposure to generative AI technologies and practical interest in applying AI-driven approaches to data engineering, data quality, metadata management, and analytics workflows.
- Strong problem-solving skills, attention to detail, and the ability to communicate effectively with both technical and non-technical stakeholders.
Tools you’ll work with
dbt, SQL, Python, Snowflake, GCP/BigQuery, AWS/Redshift
Compensation
The anticipated base salary for this position is $125,000 to $145,000 per year.
- The actual base salary offered will depend on qualifications, years of relevant experience, level of education, certifications or other professional licenses held, and (if applicable) the location of the position.
Similar Jobs
