Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Engineer, Digital Data & Analytics Team

The Data Sherpas

Data Engineer, Digital Data & Analytics Team

New York, NY
Full Time
Paid
  • Responsibilities

    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

    • Bachelor’s degree in Engineering, Computer Science, Information Systems or related field with 2+ years of relevant experience. 
    • Strong Computer Science/Engineering/Information Systems background 
    • 1+ years in Digital Media Publisher Industry with a solid understanding of Digital Research (optional but ideal)
    • 1+ Experience in Data Modeling, Data architecture, Data Quality, Metadata, ETL and Data Warehouse methodologies and technologies. 
    • Experience in any combination of the following: SQL, Big Data (HIVE), Linux, MicroStrategy, Tableau, Python, React.js, APIs, Spark, Scala
    • 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:

    • Experience with various digital platforms such as Omniture (Site Catalyst), Rentrak, comScore, Operative One, Google DoubleClick, Freewheel, Ad-Juster, Nielsen, Facebook, Twitter, etc
    • Ability to design concise and visually appealing reports, user interfaces, mockups and documentation
    • Ability to read external API documentation and write pipelines to extract data from our partners’ systems
    • Ability to write and stand up internal API endpoints to share data with other internal teams.
    • Strong analytical focus, results-oriented and execution driven. 
    • Ability and desire to work within a cross-functional team environment with people from multiple business units, vendors, countries and cultures. 
    • Self-driven/self-initiator and resourceful to achieve goals independently as well as in teams and promotes an open flow of information so that all stakeholders are well informed. 
    • Flexibility to adjust to changing requirements, schedules and priorities. 
    • Ability to work independently under minimum supervision and proactive in solving issues 
    • Energetic, committed and solution focused with the ability to perform under pressure and meeting targets