About the position
As part of the global Operations & Technology organization, the Data & Analytics team is focused on data and analytics strategies for the future. We support NBCU’s vast portfolio of brands - from broadcast, cable, news, and sports networks to film studios, world-renowned theme parks and a diverse suite of digital properties. We take pride in providing NBCUniversal with data to advise and shape strategic business decisions. The Data & Analytics team at is looking for a passionate Sr Staff Data Engineer who’s looking to build the next generation of data solutions while working with internal stakeholders, other data engineers, data scientists, and other technologists across one or more of our main subject areas. The Sr Staff Data Engineer role is right for you if you’re a subject matter expert in designing and developing great data models and can maintain the fine balance of business acumen and deep technical knowledge. Here you can create the extraordinary. Join us!
Responsibilities
- Lead the process of building and designing data models that derived from multiple sources.
- Manipulate data, flat files, and raw information into cohesive data sets for stakeholders.
- Incorporate results into actionable insights.
- Implement appropriate design patterns while optimizing performance, cost, security, and scale.
- Collaborate with business leaders, engineers, and product managers to understand data needs.
- Interface with other technology teams to extract, load, and transform data from a variety of data sources.
- Become a subject matter expert for data engineering related technologies and designs.
- Coach and guide others within the D&A organization to build scalable pipelines and semantic data models.
- Participate in development sprints, demos, and retrospectives.
- Build and manage relationships with supporting IT teams to effectively deliver work products to production.
- Transform large volumes of complex data into digestible bits for technical/non-technical end users.
- Act as a subject matter expert in the design and recommendation of data modeling methodologies.
- Remain up to date with latest data standards, systems and future forward tools and languages.
Requirements
- 12+ years of progressive experience in data engineering, warehousing, data modeling and development building of data and analytics products.
- 10+ years of experience with SQL, data modeling, ETL/ELT development principles, cloud development, and data warehousing concepts.
- 8+ years of experience in a business-facing analytical role and proven track record of related success.
- 8+ years of experience with data visualization tools (Power BI, Tableau, MicrosStrategy, and/or related).
- 8+ years working with data modelling and semantic/virtualization layer tools (DBT, AtScale, etc).
- Knowledge of cloud technologies such as AWS, GCP, and/or Azure.
- Knowledge of data modeling, management fundamentals and data storage principles.
- Experience in building data pipelines using Python/SQL or similar programming languages.
- Demonstrated experience in Airflow, Luigi or similar orchestration engines.
Nice-to-haves
- Powerful Storytelling with large, complex datasets.
- Strong experience in SQL, DB and ELT tools such as Snowflake, Redshift.
- Experience or previous exposure to federated query engines (Trino / Starburst).
- Familiarity with cloud solutions and cloud storage (AWS S3, GCS, Azure Data Lake Storage).
- Media-focused - Strong working knowledge of media including broadcast TV, digital, and mobile.
- Excellent verbal and written communication skills.
- Strong understanding of Agile principles and best practices.
Benefits
- Medical, dental and vision insurance.
- 401(k).
- Paid leave.
- Tuition reimbursement.
- Variety of other discounts and perks.
