Data Engineer

Company Description
As one of the world's premier entertainment portfolios, NBCUniversal International Networks & Direct-to-Consumer delivers quality content and compelling brands to over 160 territories across Europe, the Middle East, Africa, Latin America and Asia Pacific. Delivering a full range of entertainment experiences to local audiences across the globe, the unique brands include UNIVERSAL TV, USA, SYFY, E!, 13TH STREET, DIVA, Studio Universal, Telemundo, Bravo, CNBC, NBC News and DreamWorks. Universal+ (a hybrid linear and non-linear service) aggregates the group's brands on affiliate platforms, offering subscribers both live programming and an extensive range of compelling VOD content, including territory premieres and full boxsets, available all in one place. NBCU's direct-to-consumer activity outside the US includes hayu, the all-reality SVOD service available in 27 territories - including the UK, Canada and across Europe and Asia Pacific - as well as the upcoming launch of Peacock on Sky in late 2021.
NBCUniversal is one of the world's leading media and entertainment companies in the development, production, and marketing of entertainment, news and information to a global audience. NBCUniversal owns and operates a valuable portfolio of news and entertainment television networks, a premier motion picture company, significant television production operations, a leading television stations group, world-renowned theme parks, and a premium ad-supported streaming service. NBCUniversal is a subsidiary of Comcast Corporation.
Job Description
NBCU is seeking a lead data engineering guru that will apply his/her database expertise to build systems that collect, manage, store, and convert raw data into readable formats that the Analytics/Data Science team members can use to for developing their reporting tools. The role will form part of the Strategy and Insights team but will have cross-functional responsibilities.
The ideal candidate would have a solid background in database management, data automation, and data modeling.
Responsibilities

• 4 to 5 years of experience working in Datawarehouse environments developing ETL process using automation tools as Alteryx, Databases as Snowflake and programming languages as Python.
• Taking the lead on defining how to automate data gathering multiple data sources, transforming data into relational databases, and manage the housing of such data on cross-functional projects that will help in having better access information for decision-making
• Main priority will revolve around ensuring we are receiving, storing, and structuring data appropriately pertaining to our STB VOD, Affiliate VOD, and TVE VOD audience metrics as well as app performance for Universal+
• The individual will also collaborate on other data-driven projects such as unification of the audience and ad inventory data for our digital products, CRM, content inventory, and others
• Key functions include, but are not limited to:
  • Build robust data pipelines at scale.
  • Data validation scripting in SQL in Snowflake.
  • Design and implement data schemas.
  • Data QA.
  • Create, define, and document processes & Help in data governance initiatives.
  • Design, creates and run ETL processes in Alteryx.
• Serve as an internal consultant to the NBCUniversal Latin American Networks division as it relates to data needs
• Collaborate closely with our Analytics/Data Science team members to ensure all data is being structured and housed in a manner that can fulfill the business needs
• Work closely with our third-party data vendors and our digital product team to ensure data can be collected
• Leverage knowledge in multiple technologies, Cloud platforms, ETL tools and programming languages (e.g. Alteryx, AWS, Snowflake, Azure, SQL, Python, R, C+, PostgreSQL, Teradata, Java, Hadoop)

Qualifications

• Fully fluent in English and Spanish is a must, Portuguese is a plus
• 5+ years of relevant data experience is a must
• Experience working on cloud platforms
• Advanced knowledge of programming languages especially SQL and Python
• Advanced knowledge of relational databases and SQL programming language
• Advanced knowledge of data warehouses and data lakes
• Previous experience supporting a TV network or OTT platform preferred
• Intermediate knowledge of data visualization tools
• Strong quantitative skills, including both analytical abilities as well as math proficiency
• Previous experience working with Latin America is a plus
• Degree in Data Science, Engineering, Mathematics, or related field

Additional Information
As part of our selection process, external candidates may be required to attend an in-person interview with an NBCUniversal employee at one of our locations prior to a hiring decision.
NBCUniversal's policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law.
If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access nbcunicareers.com as a result of your disability. You can request reasonable accommodations by emailing [email protected].