This job listing expired on Nov 21, 2020
Tweet

Job Title

Data Warehouse Developer

Requisition ID

R001410

Job Description

Job Title: Data Warehouse Developer

Reporting To: BI Architect, Enterprise Applications

Department: Enterprise Applications

Location: Santa Monica, CA

Your Platform

Activision Blizzard plays a centralized role in the creation of epic entertainment by supporting our interactive gaming brands and studios with a diverse range of career opportunities across corporate functions such as Marketing, Communications, Legal, Human Resources, Finance and Supply Chain. Located in our global headquarters in Santa Monica, we encompass equal parts agility, creativity and rigor to enhance the employee and player experience. To learn more, check us out at www.activisionblizzard.com or on Twitter at @ATVI_AB.

Your Mission

As a Data Warehouse Developer you will join the IT Business Intelligence team. The Data Warehouse Developer will be responsible for designing, developing, and maintaining enterprise data warehouse and analytics architecture for successful delivery of business intelligence information. The Data Warehouse Developer must have a solid understanding of BI best practices and advanced knowledge of relational structures, dimensional data modeling, structured query language (SQL), data warehouse and reporting techniques. He/she works with architects and business partners to build out a technical vision to import data from external cloud and internal application sources, utilizing industry standards to cleanse, integrate, transform, and load this data into the data warehouse. Individual will also work collaboratively with cross-functional partners to identify and design data requirements and use roadmap to support and drive organizational strategies and objectives. The ideal candidate for this position will have a very strong Business Intelligence background, deep analytical skills, and experience working with end users. ETL knowledge is required. The ability to do work with Visualization tools, ad-hoc SQL to research data questions, identify root causes, and interact closely with peers and the business data analysts is essential.

Responsibilities

Priorities can often change in a fast-paced environment like ours, so this role includes, but is not limited to, the following responsibilities

  • Develop and support the entire data warehouse lifecycle, including requirements gathering, data profiling, design, development, testing, ongoing support and enhancements for analytics and management teams.
  • Design implement & maintain ETL procedures for intake of data from both internal and cloud sources; ensure data is verified and quality is checked.
  • Create complex queries, data transformation & aggregations to support analytics.
  • Consult with business partners such as HR Analytics teams, management, and other business analysts to clarify program objectives, determine scope, identify problems and recommend solutions
  • Collaborate with business and technology stakeholders to ensure quality data warehouse architecture development and utilization.
  • Uses comprehensive knowledge and understanding of relational data base concepts, including data architecture, operational data stores, ETL processes, interface processes, multidimensional modeling, data warehouse concepts, master data management, and data manipulation.
  • Build metrics and rules to standardize the data.
  • User API’s to integrate third party data sources to the data warehouse
  • Support implemented BI solutions by working with the analytics and DBA teams to carry out monitoring, tuning, and database performance analysis, addressing user questions regarding data integrity, and communicating functional and technical issues.
  • Participate in administering, maintenance, patching and upgrade of ETL and visualization tools.
  • Assist analytics teams with report development as needed

Player Profile

Minimum Requirements

  • At least 4 years of deep experience working with Oracle SQL in a data warehouse environment.
  • At least 4 years’ experience working with an ETL tool like SAP Data Services, Informatica, ODI etc.
  • At least 2 years’ experience in using API’s to integrate with third party applications
  • At least 2 years’ experience working with unix scripting
  • At least 2 years’ experience working with Visualization tools like Tableau/Looker/Qlik etc.
  • Experience with data warehouse design and participated in at least 1 end to end data warehouse implementation
  • Experience implementing data warehouse data segregation and security policies
  • Highly organized team player with the ability to innovate, multi-task and set priorities effectively
  • Self-starter with strong verbal and written communication skills
  • Ability to interface effectively and decisively with all levels of management, departments and outside vendors.

Extra Points

  • Experience working with HR data warehouses
  • Experience with SAP Data Services ETL tool
  • Experience working with and administering Tableau Server.
  • Experience working with cloud platforms GCP or Amazon
  • Experience working with Python & Java
  • Experience working in the entertainment or video game industries

Our World

Activision Blizzard, Inc. (NASDAQ: ATVI), is one of the world's largest and most successful interactive entertainment companies and is at the intersection of media, technology and entertainment. We are home to some of the most beloved entertainment franchises including

Call of Duty®, 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!

Our ability to build immersive and innovate worlds is only enhanced by diverse teams working in an inclusive environment. We aspire to have a culture where everyone can thrive in order to connect and engage the world through epic entertainment. We provide a suite of benefits that promote physical, emotional and financial well-being for ‘Every World’ - we’ve got our employees covered!

The videogame 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.

Activision is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, or any other basis protected by applicable law and will not be discriminated against on the basis of disability.