Job Directory Principal Data Warehouse Engineer

Principal Data Warehouse Engineer
San Francisco, CA

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About

Job Description

Job Title: Principal Data Warehouse Engineer, Ads - Activision Blizzard Media

Reporting To: Director of Engineering

Department: Engineering

Location: San Francisco, CA

Your Mission

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.

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 of cases and scalability.


* Collaborate with the other team members across different teams.


* Develop an alert & monitoring system and procedures for faster disaster recovery.


* Provide technical directions and mentor other engineers



Player Profile

* BA/BS degree in Computer Science, similar technical field of study or equivalent practical experience.


* Working experience in building data warehouse and data lake.


* 5+ years of experience in working with relational databases such as MySQL, Postgres, etc.


* 2+ years of experience in NoSQL databases like Bigtable, Cassandra, HBase, etc.


* Expert level SQL skills and database performance concepts.


* Experience in relational and dimensional data modeling.


* Experience with developing extract-transform-load (ETL).


* Understanding of distributed computing framework like Apache Spark and Flink.


* Experience in Software Development in Java or Python


* Should be able to communicate and articulate his/her thought process effectively with the other team members.



Bonus Points

* Strong in Java


* 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 Storm


* Experience with messaging systems like Kafka and RabbitMQ


* Basic understanding of machine learning concepts and lifecycle.


* Knowledge of advertising platform.



Your Platform

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.

Our World

Activision Blizzard, Inc. is the world's largest interactive entertainment company, with operations across North America, Europe, and Asia. We are home to some of the most beloved entertainment franchises including Call of Duty®, Skylanders®, World of Warcraft®, Overwatch®, Diablo®, Candy Crush™, and Bubble Witch™. Our combined entertainment network delights hundreds of millions of monthly active users in 196 countries, making us the largest gaming network on the planet!

We're proud to be recognized as one of FORTUNE's "100 Best Companies To Work For®" for four consecutive years and have earned a spot on FORTUNE's "Most Admired Companies," and "Future 50" lists. Our 10,000+ global employees are some of the best and brightest talents across entertainment, media, and technology.

The video game industry and therefore our business is fast-paced and will continue to evolve. As such, the duties and responsibilities of this role may be changed as directed by the Company at any time to promote and support our business and relationships with industry partners.

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.