{bc}
Apply
workday

Data Engineer II - Insights, Strategy & Analytics

Sony Pictures Entertainment
Culver City, USA
Full-time
Mid · 5+ years experience
Hybrid
Discovered 3 weeks ago
awsbigquerydbtgcppythonredshift

Full Job Posting

Key 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.

Qualifications:

  • Bachelor’s or Master’s degree in Computer Science, Data Science, Business Analytics, or related fields; advanced degrees are a plus.
  • 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. Experience working 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 (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.
  • The anticipated base salary for this position is $125K to $145K. This role may also qualify for annual incentive and/or comprehensive benefits. The actual base salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location of the position.
  • Sony Pictures Entertainment is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, age, sexual orientation, gender identity, or other protected characteristics.
  • SPE will consider qualified applicants with arrest or conviction records in accordance with applicable law.
  • Sony Pictures does not allow audio recording, video recording or use of AI note-taking tools during interviews. Please be aware these tools may be enabled as a default and can be difficult to disable once the interview has started, so we recommend you check your device and disable these tools prior to the start of your interview. If recording or the use of the tools occurs during the interview and cannot be promptly turned off or disabled, the interviewer may end the interview.
  • To request an accommodation for purposes of participating in the hiring process, you may contact us at [email protected].

Preferred Qualifications

  • Bachelor’s or Master’s degree in Computer Science, Data Science, Business Analytics, or related fields; advanced degrees are a plus.
  • Advanced SQL and Python skills. Experience building transformation pipelines in dbt is strongly preferred.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Sony Pictures Entertainment

Senior Systems Engineer

Culver City, USA

Discovered 2 days agoFull-time

Senior Vice President, Production - Sony Pictures Television | Nonfiction

Culver City, USA

Discovered 2 days agoFull-time

Franchise Management Trainee - Recent MBA Graduate

Culver City, USA

Discovered 2 days agoFull-time

Senior Systems Engineer

Culver City, USA

Discovered 2 days agoFull-time

Franchise Management Trainee - Recent MBA Graduate

Culver City, USA

Discovered 2 days agoFull-time

Manager, Media Strategy & Marketing Analytics

Mumbai, IND

Discovered 3 days agoFull-time

Technical Specialist, Facilities Architecture

Culver City, USA

Discovered 3 days agoFull-time

Analyst, Global Security Operations Center

Culver City, USA

Discovered 3 days agoFull-time