Pluto TV, a ViacomCBS company, is the leading free streaming television service in America, delivering 250+ live and original channels and thousands of on-demand movies in partnership with major TV networks, movie studios, publishers, and digital media companies.
Pluto TV is available on all mobile, web and connected TV streaming devices and millions of viewers tune in each month to watch premium news, TV shows, movies, sports, lifestyle, and trending digital series.
Headquartered in West Hollywood, Pluto TV has offices in New York, Silicon Valley, Chicago and Berlin.
Overview & Responsibilities:
PlutoTV is looking for a Lead Data Architect to define, refine and operate our large scale analytics processes.
PlutoTV is a free ad-supported over-the-top television service with over 100 linear channels and 1000s of VOD movies and TV shows.
The ideal candidate will have developed database schemas and services to collect and process billions of data elements every day, 24/7/365, and know how to build, orchestrate and manage highly-performing data pipelines and schemas
Responsibilities:
This is a critical role with a wide range of responsibilities, including:
- Collaborating cross-functionally to perform data discovery and develop various objectives for data architecture and strategy
- Leading data modeling and data warehouse analysis, architecture, design, and development, which includes but is not limited to, setting up data ingestion pipelines, data/dimensional modeling including star/snowflake schemas, and ETL/ELT processes
- Developing data strategies that define how the data will be stored, consumed, integrated and managed
- Collaborating with new and existing data vendors to understand data sourcing strategy, identify and collect required data, and more
- Providing guidance on dimensional modeling and database design standard methodologies
- Data wrangling of heterogeneous data and explore and discover new insights
- Lead and support mappings of data sources, transformations, and data movement
- Implement procedures in place to validate data to ensure that data integrity and quality standards are met
- Provides mentorship to support team members
Basic Qualifications:
- 5+ years designing large-scale data architectures
- 2+ years of experience with Snowflake
- 7+ years writing and executing advanced SQL queries
- 3+ years configuring multi-staged jobs/DAGs in relevant orchestration engines such as Airflow
- 3+ years of hands-on experience with object-oriented programming and distributed computing/parallelization in languages such as Python/PySpark, JavaScript or Scala
- Experience developing data models from technical and functional requirements including:crafting logical and physical data models for current and proposed states; turning application designs into data model specifications; understanding data storage requirements and estimating database growth; designing OLAP and reporting tool data model requirements; creating intuitive data models in business end user terminology; constructing database normalization; understanding of 1NF to 5NF; utilizing data modeling tools to record, update, reverse engineer and generate DDL.
Additional Qualifications:
- 3+ years with highly-performing data pipes such as Kafka, or Kinesis
- Strong analytical problem solving and decision making
- Good interpersonal skills, written and verbal
- Strong technical writer with experience creating and maintaining informative content and documentation using software such as LaTeX or alternatives
- Experience serving in a data modeling and data architect role for enterprise data modeling across multi-domain, multi-subject areas using Inmon and/or Kimball methodologies
#LI-MM1
ViacomCBS is an equal opportunity employer (EOE) including disability/vet.
At ViacomCBS, the spirit of inclusion feeds into everything that we do, on-screen and off.
From the programming and movies we create to employee benefits/programs and social impact outreach initiatives, we believe that opportunity, access, resources and rewards should be available to and for the benefit of all.
ViacomCBS is proud to be an equal opportunity workplace and is an affirmative action employer.
We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, creed, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, and Veteran status.
If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access.
as a result of your disability.
You can request reasonable accommodations by calling 212.846.5500 or by sending an email to [email protected] Only messages left for this purpose will be returned.