Permanent | Full Time
Principal Data Warehouse Engineer, Ads - Activision Blizzard Media
Activision Blizzard Media is a rapidly growing business built to connect brands with our 350M + global player base across Activision, Blizzard and King.We create premium, innovative advertising experiences for world-class casual mobile games like King's Candy Crush Saga. Looking ahead, we plan to launch advertising across the Activision Blizzard portfolio, including high growth areas like eSports. This is an exciting time to join this growing business.We are seeking a Principal Data Warehouse Engineer in our Ads Engineering team, empowering cutting edge mobile advertising technologies to create the next generation of our Ads Platform.
Your role within Activision Blizzard Media
If you want to create amazing user experiences using the latest technologies, then this is the right job for you. You're an excellent communicator, happy to work with people from several different business units. You can translate business needs into technical requirements and implementation. We are problem solvers, constantly reviewing how and why we do things and learning from each other. We are experimental, trying out new tech and ideas and willing to take risks to drive the entire industry forward. We are sociable and fun, and we like to hang out together. We are passionate, some might even say quirky, and while we love what we do, our lives are about more than work. We love games, and are obsessed with creating the best player experience.Responsibilities
Design and build cloud-based data lakes and data warehouses.
Design and build Data Pipelines to collect, transform, store, analyze, explore and visualize.
Work with the product team to understand data sources, use cases and data models.
Choose the right technology stack to align with the use cases and scalability.
Collaborate with the other team members across different teams.
Develop alert & monitoring system and procedures for faster disaster recovery.
Provide technical directions and mentor other engineers
Skills to create thrills
BA/BS degree in Computer Science, similar technical field of study or equivalent practical experience.
Should be able to communicate and articulate his/her thought process effectively with the other team members.
Experience with developing extract-transform-load (ETL).
Experience in relational and dimensional data modeling.
Expert level SQL skills and database performance concepts.
2+ years of experience in NoSQL databases like Bigtable, Cassandra, HBase etc.
5+ years of experience in working with relational databases such as MySQL, Postgres etc.
Working experience in building data warehouse and data lake.
Experience building data warehouse, data lake and data pipeline using Google Cloud Platform (GCP)
Experience with large scale distributed system with large datasets.
Experience in distributed computing framework - Hadoop, Spark, Flink or StormExperience with messaging systems like Kafka and RabbitMQ
Basic understanding of machine learning concepts and lifecycle.
Knowledge of advertising platform.
Keep Calm and waka waka...