Data Engineer II - Insights, Strategy & Analytics

Sony Pictures Entertainment is seeking a Data Engineer II to join its Insights, Strategy and Analytics organization, which enhances analytical capabilities and infrastructure for internal stakeholders across television production, distribution, and marketing. The role designs and builds reliable, scalable ELT pipelines, data models, semantic layers, and ready-to-use datasets that support analytics, reporting, AI/ML applications, and strategic decision-making.

Responsibilities

• **Analytics Engineering:** Translate complex business requests into robust data models, business metrics, and semantic layers using dbt and SQL. Apply analytics engineering best practices to ensure maintainability, reliability, and performance
• **Data Engineering:** Support the ingestion of new sources into SPE’s Snowflake data platform, working closely with central IT and cloud operations teams to define ingestion requirements and validate that pipelines meet business needs and adhere to SPE’s data governance and security policies
• **Cross-Functional Product Delivery:** Partner closely with product managers, strategic analysts, data scientists, data visualization teams, and business stakeholders to deliver impactful tools. Collaborate across disciplines to understand business requirements, harmonize data from disparate systems, and create ready-to-use datasets that enable reporting, advanced analytics, and decision-making
• **“One Team” Mindset:** Contribute to a high-performance team, collaborating openly with peers to create a team culture of ownership, accountability, and continuous improvement

Preferred

• advanced degrees are a plus
• Experience working with industry data providers such as IMDb, Gracenote, Luminate, Nielsen, or similar sources is highly desirable
• Experience building transformation pipelines in dbt is strongly preferred
• Advanced Degree
• Industry Data Provider Experience
• IMDb
• Gracenote
• Luminate
• Nielsen
• dbt
• Data Transformation Pipelines

Benefits

• Annual incentive
• Comprehensive benefits
• Hybrid work arrangement

Company

• Motion picture and television production and distribution
• Culver City, California, USA
• http://sonypictures.com/
• Founded in 1987
• 5001-10000 employees

Qualifications

• Bachelor's or Master's degree in Computer Science, Data Science, Business Analytics, or related fields
• 5+ years in analytics engineering, data engineering, or a related technical role in a production environment
• Experience working with data supporting television, film, streaming, advertising-supported video (AVOD), FAST channels, content distribution, audience analytics, or media strategy
• Familiarity with business entities, metrics, and datasets common to a television production and distribution studio, including content and title metadata, audience measurement, ratings, and content performance data, talent, production, licensing, and distribution datasets
• Advanced SQL and Python skills
• Proficiency with modern cloud data platforms (e.g., Snowflake, GCP/BigQuery, AWS/Redshift) and with pipeline orchestration tools
• Familiarity with CI/CD workflows, 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
• Advanced degrees are a plus
• Experience working with industry data providers such as IMDb, Gracenote, Luminate, Nielsen, or similar sources is highly desirable
• Experience building transformation pipelines in dbt is strongly preferred
• 5+ years in analytics engineering, data engineering, or a related technical role in a production environment.

Required skills

• SQL, Python, dbt, Snowflake, Google BigQuery, Amazon Redshift, Data Engineering, Analytics Engineering, ELT Pipeline Development, Data Modeling, Data Governance, Data Quality Testing

Preferred skills

• advanced degrees are a plus

Experience

• 5+ years