Senior SQL Developer
Los Angeles, CA, US, 90069
Information Technology
Los Angeles
Full-Time
Pluto TV, a ViacomCBS company, is the leading free streaming television service in America, delivering 100+ 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.
ViacomCBS creates entertainment experiences that drive conversation and culture around the world. Through television, film, digital media, live events, merchandise and solutions, our brands connect with diverse, young and the young at heart audiences in more than 180 countries.
The Sr. SQL Developer will collaborate with BI Developers, Data Architects and Data Engineering teams to build, maintain and optimize large scale SQL based solutions in our Snowflake Data Warehouse. Solid experience designing and developing high performance queries is required. The right candidate will need to have professional knowledge of developing writing SQL queries in Snowflake.
Primary Responsibilities:
Design, develop and maintenance of high-performance Snowflake SQL and Data Warehouse certified queries
Design, develop and maintain complex query logic and Snowflake implementations such as virtual warehouses, semantic layers, etc.
Participate in various requirements sessions with internal and external partners and convert business / functional requirements into technical solutions, along with supporting materials such as use cases, designs, flowcharts, models, specifications, and reports
Provide technical support to requirements, development, testing, and training teams
Work directly with project management, Business Intelligence and Data Engineering to develop end-user training and reference materials
Collaborate with the BI Analysts to ensure data integrity and optimize custom queries develop for BI Insights and Reporting and support formulating queries and understanding the data contained in the data warehouse
Follow the corporate data compliance guidelines, as well as adhere to industry regulations (CCPA, COPPA, GDPR, LGPD, etc.)
Draft standards and procedures affecting data analysis and process modeling, as well as database design, maintenance, and management
Support database initiatives related to security, capacity, scalability, performance, platform upgrades, service agreements, and disaster recovery
Conduct performance tuning reviews for improvements and prepare written reports of findings, including recommendations and cost justification analysis
Required Qualifications:
8+ years writing SQL in an enterprise Data Warehouse
2+ years working in a Snowflake Data Warehouse
10+ years of proficiency with advanced SQL programming
Hands-on experience with Snowflake utilities such as SnowSQL, Snowpipe, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures is a plus
5+ years practical experience implementing enterprise data warehouse query solutions, including development of physical, logical and conceptual modeling, writing ETL scripts, supporting BI reporting, and validating query results
Advanced knowledge of decision and intelligence systems concepts, and database structures such as ETL, normalization, datamarts, fact tables, dimensions, views, and star schemas
Experience with performance tuning and optimization in a Snowflake Data Warehouse
Ability to analyze project requirements and develop detailed specifications and designs for new BI capabilities, while balancing cost, performance, quality and schedule demands
Ability to standardize, harmonize, cleanse, prepare and use data for developing datasets, reports and analytics
Confident and proactive self-starter, skilled in taking initiative, assessing requirements, coming up with plans, and taking the lead in making plans reality
Demonstrate a high degree of adaptability, comfortable in establishing new directions, managing rapid change, and trying different approaches to deal with uncharted territories
Proactive self-starter, skilled in taking initiative, assessing requirements, coming up with plans, and taking the lead in making plans reality
Proven track record with successful implementation of Data Management disciplines such as Data Governance, Data Warehousing, Data Quality, Metadata Management and Master Data Management
Bachelor's degree preferably in engineering, computer science, mathematics, statistics or equivalent
Citizenship
Citizens of Pluto TV have the privilege of entertaining millions of people. We are entrepreneurs looking to revolutionize the future of TV. While our planet is small, our ambition is boundless. The stakes don’t get much higher.
Becoming a Citizen is hard work. We need self-starters that thrive in changing environments, who treat company resources like their own, and who deliver seemingly impossible outcomes at warp speed. It’s the only way we stay ahead of the giants looking to take the opportunity we have earned. We are selective but once chosen, you’re in.
Why You Should Become a Citizen of Pluto TV
As stated, becoming a Citizen is hard work but the rewards of citizenship are plentiful. Work with the smartest people on some of the most complex projects of your life, while profoundly impacting both Pluto TV and the broader world of entertainment. Share in the epic quest to define the future of television as we know it. Big commitment, huge impact, lasting change.
As a Citizen, you will enjoy generously-sponsored medical benefits, a generous vacation policy, 401K retirement plan, social and team events, and more!
We’re an equal opportunity employer (EOE)
At Pluto TV and Viacom, 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. Viacom 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.