Data Engineer

Job Description

The Team

45 years ago we changed the face of television, and we continue that today by building and delivering next-generation entertainment and technology solutions across the globe. Our innovations impact advertising, data management, information security, content creation and delivery, business operations, broadcasting and ultimately, the fan experience.

As a technologist at WarnerMedia, you will work at the intersection of art and science. You'll work for brands that inform and entertain the world including [adult swim], Bleacher Report, Boomerang, Cartoon Network, CNN, ELEAGUE, Great Big Story, HLN, iStreamPlanet, TBS, Turner Classic Movies (TCM), TNT, truTV and Turner Sports- which includes the NBA, NCAA March Madness, Major League Baseball and the UEFA Champions League. You'll be part of a company that enables community and belonging by creating content that connects with fans when, how and where they want it.

The job

Working under direction of Data Architects and Technical Managers, this position is responsible for building data pipelines into and out of a data lake using state of the art technologies. This includes the ingestion and transformation of data that provides critical information to the enterprise and business partners. This position can be in the Atlanta or New York City office.

The Daily
• Be at the cutting edge of utilizing data about consumers in the media industry to improve audience experience
• Create solutions to transform data from various sources and load it into Snowflake to create a data lake
• Create and maintain transformations to summarize/aggregate data enabling users to perform analyses using various BI and Analytics tools
• Work closely with Customer Analytics team members to better understand user requirements
• Contribute to the project planning process by estimating tasks and deliverables
• Develop and maintain standards for administration and operation including the scheduling, running, monitoring, logging, management of errors, recovery from failures, and validation of outputs
• Contribute to the project planning process by estimating tasks and deliverables
• The position will mostly be involved with onboarding new and changed data sources including, for example, API's for all the major social networks, to the Data Cloud. The successful candidate will be spending their time approx. 35% python3 analysis, design & development; 35% database process design & development, 20% testing and performance enhancement and 10% research and development

The Essentials
• Minimum 3-4 years solid experience writing Object-oriented programs in Python
• Minimum 2-3 years solid experience writing SQL
• Experience in working with Linux environments and Unix Shell Scripting
• Understanding of ETL processes and design
• Basic understanding of statistics
• BS or higher in Computer Science, Mathematics, MIS, business, or equivalent education / training / experience

The Extra Credit
• Experience with Apache Airflow or similar job scheduling application.
• Knowledge and working experience with AWS such as S3, Lambda, EC2, Kinesis, etc…
• Knowledge of Luigi, AWS Glue, AWS Athena, and Apache Spark.
• Experience with ''big data'' platforms such as Snowflake, Hadoop, Hive, Presto or cloud-based tools such as Amazon Redshift, Google BigQuery
• Experience working with REST and SOAP APIs
• Specific application experience with media, Web Analytics and consumer data systems a plus
• Experience with BI tools such as Looker and Tableau

Jobcode: Reference SBJ-ro3806-3-15-6-77-42 in your application.