Staff Data Platform Engineer (GCP/BigQuery)

Company Description

We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our theme parks and consumer experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through Universal Filmed Entertainment Group and Universal Studio Group, and have world-renowned theme parks and attractions through Universal Destinations & Experiences. NBCUniversal is a subsidiary of Comcast Corporation.

Here you can be your authentic self. As a company uniquely positioned to educate, entertain and empower through our platforms, Comcast NBCUniversal stands for including everyone. Our Diversity, Equity and Inclusion initiatives, coupled with our Corporate Social Responsibility work, is informed by our employees, audiences, park guests and the communities in which we live. We strive to foster a diverse, equitable and inclusive culture where our employees feel supported, embraced and heard. Together, we’ll continue to create and deliver content that reflects the current and ever-changing face of the world.

Job Description

As part of the Operations & Technology Engineering organization, the Data & Analytics team (D&A) supports NBCU’s vast portfolio of brands - from broadcast, cable, news, streaming service, and sports networks to film studios, world-renowned theme parks and a diverse suite of digital properties.  We take pride in supplying our business groups with data to advise and shape strategic business decisions related to our content. 

As the Staff Data Platform Engineer, you’ll have the opportunity to work with internal stakeholders, data engineers, visualization experts, data scientists, and other technologists across the business to ensure the delivery of data across major platforms at scale. If you’re someone with expertise in cloud, dev/data ops, and operational processes and can maintain the fine balance of business acumen and deep technical knowledge, you’ve come to the right place. Here you can create the extraordinary. Join us!

• Build Cloud Tagging frameworks, and work with engineering teams on implementing & monitoring it.
• Responsible for developing a robust program for Snowflake Cloud and BigQuery management frameworks that includes but is not limited to monitoring, alerting, and governance model, budgets and change management, cost optimization lifecycle, show-backs, and charge-backs
• Work on Cloud Usage reporting to measure cloud cost related insights, metrics and KPIs
• Work on automation solutions for Cloud usage using GCP, AWS and Python as needed
• Work on BigQuery optimizations at warehouse and database level
• Coordinate cloud issue resolution with Operation teams
• Setup and monitor data share-in capabilities within GCP and cross cloud technologies
• Communicate with leadership on Cloud usage trends, issues, and optimization techniques
• Collaborate with the D&A team to help with Cloud IAM & Role Management
• Ability to write complex SQL to analyze and troubleshoot data anomalies
• Coordinate with Cybersecurity to adhere to NBCU security guidelines
• Coordinate VPC Networking, IP Whitelisting etc
• Participate in the forecasting process; build and improve forecasts and explore trends in cloud spend using internal and external tools
• Work on building Cloud Governance policies, standards, and documentation
• Provide guidance and support to internal and federated Solution Architects to ensure compliance to expected technical and quality standards.

Qualifications

• 8+ years hands-on data platform experience with at least 1+ years working in the Google Cloud environment
• Experience across GCP and Cloud-based databases on IAM & Role Management
• Experience in Data Sharing, Cloning, Data Exchange, DR replication features in Snowflake and BigQuery
• Experience with GCP, AWS and Python
• Experience with GIT development, deployment, and support of data processes and procedures 
• Detailed understanding of AWS, GCP, Azure, Snowflake resources (e.g. S3, Glue, Blob, EC2, Containers, etc.)
• Experience with Linux & Windows environments
• Proven experience and expertise in Cloud operational monitoring and administration
• Experience with high volume data processing using Snowflake, Redshift, Databricks, BigQuery and other relevant cloud technologies and designing solutions for reliability and performance at scale.
• Experience with BI tools