Senior SQL Developer

Job Locations
US-CA-WEST HOLLYWOOD
Brand
Pluto TV
Function
Business Intelligence & Data
Job Type
Full-Time Staff
iCIMS ID
2021-15547

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

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed