Senior SQL Developer

| Greater LA Area
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

About The Brand

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 and Responsibilities

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.

 

  • 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

Basic 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
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Location

750 N. San Vicente Blvd. , Los Angeles, CA 90069

What are Pluto TV Perks + Benefits

Culture
Friends outside of work
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Stocked Kitchen
Happy Hours
Parking
Pet Friendly
Professional Development Benefits
Lunch and learns
Promote from within
More Jobs at Pluto TV74 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Marketing
new
Los Angeles
Product
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Project Mgmt
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Content
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Data + Analytics
new
Los Angeles
Sales
new
Los Angeles
Product
new
Los Angeles
Product
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Project Mgmt
new
Los Angeles
Design + UX
new
Los Angeles
Developer
new
Los Angeles
Product
new
Los Angeles
Developer
new
Los Angeles
Design + UX
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Finance
new
Los Angeles
Content
new
Los Angeles
HR + Recruiting
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Pluto TV's full profileSee more Pluto TV jobs