Sony PicturesCulver City, CA
Full Time Job
What will be your mission?
At Sony Pictures, our mission is to connect relevant movie and TV series content to consumers and audiences across transactional, subscription and linear viewing platforms. We're building data products, visualization tools and insights platforms that will predict audience preferences and behavior for library and new releases to drive growth of engagement and consumption of Sony produced content. You will be reporting to the Executive Director of Data Management. Sony produces franchise brands, such as Spiderman, Men in Black and Jumanji, through to TV franchises such as Breaking Bad, Blacklist and Better Call Saul.
Our Data team is responsible for aggregating millions of consumer data points to build best in class predictive models, consumer trends systems, recommendation engines and more!
This position is responsible for developing and supporting new and existing datasets and partnering with IT to deliver ETL scripts to support operational reporting, management decision support, and advanced analytics.
Who are you?
You have a strong commercial analytical background and technical skills in data querying and transformation. You believe that data profiling, quality management, data integration across disparate data sets are foundational in enabling and driving a culture where data is democratized, accessible and easily interpreted for Sony Pictures to be a consumer-centric data driven organization.
You will work in the Data Management team within the business and leverage your analytical skills (across sales, consumer) to profile, UAT, develop and manage usage of Sony data licenses in cloud-based data platforms and sandboxes.
You care about data quality, consistency, integration, connectivity across big data sets. You will work with our data science team, our IT team, our strategic analysts and our diverse users in the business. You will co-manage data sets spanning from data ingestion to end-user lifecycle: Profile, ingest, connect, features engineering, prepare, store and disseminate data.
You are data curious and business savvy with a strong background and demonstrated ability to navigate and analyze large and diverse data sets and be able to structure data so that it is meaningful and compelling.
What will you be doing?
o Work closely with consumer / audience analytics teams and technology partners as part of a complete data and analytics lifecycle.
o Conduct data lifecycle activities: problem identification, hypothesis definition, data integration, data profiling, prototyping and experimentation, data schema design, development, testing and deployment
o Conduct a broad range of analytics data management and optimization functions including development, scheduling, job optimization, version control management, data quality management, and issue resolution.
o Develop and deliver attributes and deploying data preparation processes to be utilized for data warehouses/repositories/big data platforms, self-service reporting solutions, scorecards and dashboards on user-level audience and consumer data using analytical and visualization tools.
o Work with teams to understand business requirements - translate and use complex data sources that needs to be blended, cleaned, structured and enriched into a desired output for analysis and utilized to deliver efficient and quality reports/ dashboards using various BI tools
o Partner with analysts to optimize and improve data operational processes
o Support User Acceptance Testing to ingest new data sets and migrate data sets to cloud platforms for data sandboxes
o Promote and evaluate use of software development best practices (including automated unit testing, Continuous Integration, Continuous Deployment, Dev Ops)
o Execute version control, change management and continuous improvement protocols
o Collect and refine data from disparate data sources to support business requirements
o Partner with IT to schedule and optimize various ETL scripts
o Access and create various data sources to supplement existing data
o Troubleshoot and resolve data discrepancies, nuances and issues. Perform quality audits, identify data gaps / anomalies; conduct root cause analysis with recommended solutions, and track error resolution through completion
o Collaborate with strategic analysts and data scientists to use expanded data sets and query techniques
o Develop custom datasets and execute data extract queries to support ad hoc analyses and data science initiatives
o Conduct ad hoc data mining and data profiling activities on new data
o Create documentation and logs for new and existing data sources including: drafting data dictionaries, providing data field definitions, developing common business data language, data nuances, data summaries and tracking aggregate tables and features engineering calculations
o Maintain data catalog with additions, changes and deletions to ensure most up-to-date information is available to other team members
o Present and communicate data summaries and presentations with the goal of data education
o Minimum 2 years working as a Business Analyst or Data Analyst for a medium to large scale company
o Experience in at least one of the following business disciplines: Retail, sales or consumer Analytics
o Advanced SQL, and/or Python scripting experience (Nice to have but not necessary)
o Understanding of data engineering (data building blocks)
o Strong background: ETL and/or SQL coding experience. Ability to read and interpret data models and entity relationship diagrams, as well as to read, write, and analyze complex SQL statements and their output
o Hands-on experience with Teradata and Oracle database platforms and tools to analyze them (SQL Assistant, SQL Developer, etc.)
o Understanding of API – working and connecting with APIs
o Understand file constructs such Json, xml, flat files (CSV text files)
o Experience in trouble shooting and resolving issues data systems
o Experience designing high performing database queries / indexes and troubleshooting database performance issues
o Excellent written and verbal communication skills
o Ability to deliver in a fast-paced and goals-based environment with time-bound deliverables
o Skilled in collaboration, enjoys working with others and achieving results as a team
o Passion and demonstrated experience in delivering results and meeting business goals in a matrix and cross functional environment
o Prior experience working with centralized infrastructure teams for data architecture and database platform support
o Strong proficiency with Microsoft data analysis tools such as Excel and Access
o Bachelor's degree in Information Technology, Computer Science, or Computer-related degree
o 2-3 years of experience with data warehousing and business intelligence
o 2-3 years of experience with all phases of a software development lifecycle
*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.
USA - Culver City - Akio Morita Building