Data Warehouse Developer

Job Description

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.

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

Jobcode: Reference SBJ-rbx68x-13-59-236-219-42 in your application.