Data Engineer, Data Products

Company Description
NBCUniversal is one of the world's leading media and entertainment companies. We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our global theme park destinations, consumer products, and experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, NBC Sports, Telemundo, NBC Local Stations, Bravo, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through our powerhouse film and television studios, including Universal Pictures, DreamWorks Animation, and Focus Features, and the four global television studios under the Universal Studio Group banner, and operate industry-leading theme parks and experiences around the world through Universal Destinations & Experiences, including Universal Orlando Resort, home to Universal Epic Universe, and Universal Studios Hollywood. NBCUniversal is a subsidiary of Comcast Corporation. Visit www.nbcuniversal.com for more information.
Our impact is rooted in improving the communities where our employees, customers, and audiences live and work. We have a rich tradition of giving back and ensuring our employees have the opportunity to serve their communities. We champion an inclusive culture and strive to attract and develop a talented workforce to create and deliver a wide range of content reflecting our world.
Job Description
NBCUniversal's Data & Analytics - Ad Sales organization is seeking a Data Engineer that will be focused on Data Products. This Data Engineer will be responsible for delivering analytics products by consolidating/normalizing various data sets, designing advanced KPIs and presenting insights through an intuitive self-service data product. They will be a contributor to the overall Data Product roadmap by working closely with our business partners to understand their challenges and develop analytical tools to help drive business decisions.
Responsibilities:

• Leverage prototyping methodologies to propose and design creative business solutions that exploit our broad toolset of technologies (Big Data, MicroStrategy, Tableau, Python, Spark etc.)
• Work in Spark Scala, Python and Pandas in an AWS Infrastructure
• Educate and inform business partners on architecture, capabilities, best practices and solutions to build out future enhancements
• Assist in analyzing business requirements, source systems, understand underlying data sources, transformation requirements, data mapping, data model and metadata for reporting solutions
• Write clear documentation and architecture diagrams ,and keep them up to date as code and frameworks change over time.

Qualifications

• Bachelor's degree in Engineering, Computer Science, Information Systems or related field with 3+ years of relevant experience.
• Strong Computer Science/Engineering/Information Systems background
• 3+ Years Experience in Data Modeling, Data architecture, Data Quality, Metadata, ETL and Data Warehouse methodologies and technologies.
• Experience in any combination of the following: SQL, Linux, MicroStrategy, Tableau, Python, APIs, Spark, Scala, Python, Pandas
• Experience using EMR Serverless, EC2, Lambda or the ability to read EMR code and translate it into Lambdas.
• Must understand the basics of relational data modeling and be able to clearly articulate the reasons to use non-relational systems in our architecture.
• Experience in Snowflake is desired but relevant experience in any of the following is acceptable: MySQL, Redshift, Athena, MSSQL Server, Oracle.
• Decent understanding for the digital media ad sales business and ad serving technologies with experience working with ad serving transactional data logs or Nielsen demographic data.
• Strong problem-solving skills.
• Strong oral and written communication and influencing skills, with the ability to communicate new concepts and drive change in processes and behaviors and to communicate complex technical topics to management and non-technical audiences.

Desired Characteristics:

• Understanding of the media and entertainment field
• Familiarity with Operative, FreeWheel, Google Ad Manager, Omniture and other similar ad tech data sets
• Ability to design concise and visually appealing reports, user interfaces, mockups and documentation
• Strong analytical focus, results-oriented and execution driven, with the ability to align technology developments with the generation of potential competitive business advantage.
• Self-motivated, well organized and has strong innovation and facilitation skills, especially in driving consensus among senior technical resources.
• Ability and desire to work within a cross-functional team environment with people from multiple business units, vendors, countries and cultures.
• Flexibility to adjust to changing requirements, schedules and priorities.
• Experience in Application Development, including User Interface / User Experience Design
• Demonstrates good personal time management skills, including punctuality, time reporting and completion of assigned tasks within agreed time frames
• Ability to work independently under minimum supervision and proactive in solving issues
• Committed and solution focused with the ability to perform under pressure and meeting targets

Additional Requirements:

• Fully Remote: This position has been designated as fully remote, meaning that the position is expected to contribute from a non-NBCUniversal worksite, most commonly an employee's residence.

This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks. Learn more about the benefits offered by NBCUniversal by visiting the Benefits page of the Careers website. Salary range: $100,000 - $135,000
We are accepting applications for this position on an ongoing basis.
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].
For LA County and City Residents Only: NBCUniversal will consider for employment qualified applicants with criminal histories, or arrest or conviction records, in a manner consistent with relevant legal requirements, including the City of Los Angeles' Fair Chance Initiative For Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.