Senior Data Engineer

Summary

Join NBCUniversal's Data & Analytics team as a Senior Data Engineer. You will build data pipelines, develop analytical tools, and collaborate with business partners to support strategic decision-making. This role requires expertise in AWS technologies, data modeling, and ETL processes. The position offers a fully remote work arrangement and a competitive salary range of $115,000 - $145,000. You will leverage prototyping methodologies to propose and design creative business solutions. The ideal candidate will have strong analytical skills and experience working in a fast-paced, agile environment.

Requirements

• Bachelor’s degree in Engineering, Computer Science, Information Systems or related field with 5+ years of relevant experience
• 1+ Experience in Data Modeling, Data architecture, Data Quality, Metadata, ETL and Data Warehouse methodologies and technologies
• Demonstrated experience as an engineering lead in implementing scalable, distributed, and highly available systems using cloud technologies, specifically Amazon Web Services
• Experience in any combination of the following: SQL, AWS EMR/Lambda, Iceberg, Linux, Python, Web technologies, APIs, Spark, Scala
• 2+ years’ experience with AWS tech stack
• Basic understanding of relational data modeling and be able to clearly articulate the reasons to use non-relational systems in our architecture

Responsibilities

• Build data pipelines to land, profile, and store multiple internal & external datasets
• Build applications that surface this data to support our business partners’ strategic decision making for analytics solution in media industry
• 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
• Leverage prototyping methodologies to propose and design creative business solutions that exploit our broad toolset of technologies (AWS tech stack, data lake, Python, Spark, Scala, Iceberg, EMR Serverless, SNS, SQS, AWS Lambda, Step Functions, Event Triggers etc.)
• 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 easily understood documentation and architecture diagrams and keeping them up to date as code and frameworks change over time

Preferred Qualifications

• Experience in Media industry with various linear & digital platforms such as Operative One, Google Ad Manager, Freewheel, WO Traffic etc
• Experience in Snowflake is desired but relevant experience in any of the following is acceptable: Redshift, SingleStore, Athena, MSSQL Server, Oracle
• Decent understanding for the media ad sales business and ad serving technologies with experience working with ad serving transactional data logs
• Experience in any BI tool is desired with a preference for MicroStrategy but is not required
• Experience with Python and Pandas in an AWS Lambda framework
• Candidate will have strong analytical focus, results-oriented and execution driven with strong problem-solving skills
• 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. Promotes an open flow of information so that all stakeholders are well informed
• Committed and solution focused with the ability to perform under pressure and meeting deadlines

Benefits

• Fully Remote
• Company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks