ABOUT US:
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, and world-renowned
theme parks. 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.
RESPONSIBILITIES:
Data Engineer for the Digital Data & Analytics Team. Our team builds data pipelines to
land, profile and store multiple internal & external datasets and build applications that
surface this data to support our business partners’ strategic decision making. We are an
AWS shop that uses open source technologies including Python, Pandas, Spark, Hive,
Postgres, Redis MongoDB, Flask, as well as BI tools such as Tableau and MicroStrategy.
We work in a very agile environment, where product specifications are flexible and often
change rapidly over time. We are seeking people who are comfortable with ambiguity
and figuring out an execute. While the key focus for this role is on backend engineering,
engineers who have full stack expertise and can write front-end code will be especially
considered.
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
Leverage prototyping methodologies to propose and design creative business solutions that exploit our broad toolset of technologies (Big Data, MicroStrategy, Tableau, Python, Spark etc)
2+ years experience with AWS technologies. Strong experience using Python and Pandas in an AWS Lambda framework is highly desired. Experience using EMR and/or DataBricks 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
MemSQL is desired but relevant experience in any of the following is acceptable: SnowFlake, MySQL, Redshift, Athena, MSSQL Server, Oracle. Experience in non- relational systems such as Redis, Cassandra, and MongoDB is useful for supporting legacy applications.
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.
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
Writing easily understood documentation and architecture diagrams and keeping them up to date as code and frameworks change over time.
QUALIFICATIONS /REQUIREMENTS
DESIRED CHARACTERISTICS: