Data Engineer II - Insights, Strategy & Analysis
Sony Pictures Entertainment2 months ago
Culver City, CA, USAMid Level
Base Salary
$125k - $145k/yr
Responsibilities
- Translate complex business requests into maintainable data models, business metrics, and semantic layers using dbt and SQL.
- Design, build, and support reliable, scalable ELT and data transformation pipelines.
- Ingest new data sources into the Snowflake platform and define requirements with IT and cloud operations teams.
- Validate pipelines against business needs, data governance policies, security policies, reliability, and performance standards.
- Harmonize data from disparate systems and create ready-to-use datasets for reporting, advanced analytics, and decision-making.
- Partner with product managers, analysts, data scientists, data visualization teams, and business stakeholders to deliver data products.
- Contribute to team ownership, accountability, collaboration, and continuous improvement.
- Explore AI-driven approaches to data engineering, data quality, metadata management, and analytics workflows.
Requirements
- Bachelor’s or master’s degree in Computer Science, Data Science, Business Analytics, or a related field; advanced degrees are a plus.
- At least 5 years of experience in analytics engineering, data engineering, or a 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 television production and distribution datasets, including title metadata, audience measurement, ratings, content performance, talent, production, licensing, and distribution data.
- Experience with industry data providers such as IMDb, Gracenote, Luminate, Nielsen, or similar sources is highly desirable.
- Advanced SQL and Python skills.
- Experience building transformation pipelines in dbt is strongly preferred.
- Proficiency with modern cloud data platforms such as Snowflake, GCP/BigQuery, or AWS/Redshift, and with pipeline orchestration tools.
- Familiarity with version control, CI/CD workflows, automated testing frameworks, data quality standards, and data governance.
- Exposure to generative AI technologies and practical interest in applying AI to data engineering, data quality, metadata management, and analytics workflows.
- Strong problem-solving, attention to detail, and communication skills with technical and non-technical stakeholders.
Benefits
- The role may qualify for an annual incentive and comprehensive benefits.
Tech Stack
Categories
Data Engineering
About Sony Pictures Entertainment
Sony Pictures Entertainment produces and distributes motion pictures and television series, manages digital content and home entertainment, and operates studio facilities for creators and global platforms. A subsidiary of Sony Group Corporation based in Culver City, it distributes content in more than 130 countries and runs a studio lot with 18 sound stages. Revenue comes from theatrical and TV distribution, licensing, networks, and related services.