Data Engineer

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)