26 days old

Data Modeler - Data Architecture

Walt Disney Studios
San Francisco, CA 94102

Data Modeler - Data Architecture

Job ID 724739BR Location San Francisco, California, United States; New York, New York, United States Business Disney Streaming Services Date posted Nov. 19, 2019

Job Summary:

We are seeking a Data Modeler who will partner with business, analytics and engineering teams to design, build and maintain ease for use data structures to facilitate reporting and monitoring key performance indicators. Collaborating across disciplines, you will identify internal/external data sources to design table structure, define ETL strategy & automated QA checks and implement scalable ETL solutions.

Responsibilities:

  • Partner with technical and non-technical colleagues to understand data and reporting requirements.
  • Work with Engineering teams to collect required data from internal and external systems.
  • Design table structures and define ETL strategy to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
  • Develop Data Quality checks for source and target data sets. Develop UAT plans and conduct QA.
  • Develop and maintain ETL routines using ETL and orchestration tools such as Airflow, Luigi and Jenkins.
  • Document and publish Metadata and table designs to facilitate data adoption.
  • Perform ad hoc analysis as necessary.
  • Perform SQL and ETL tuning as necessary.
  • Develop and maintain Dashboards/reports using Tableau and Looker

Basic Qualifications:

  • 2+ years of relevant Professional experience.
  • 1+ years work experience implementing and reporting on business key performance indicators in data warehousing environments. Strong understanding of data modeling principles including Dimensional modeling, data normalization principles etc.
  • 1 + years experience using analytic SQL, working with traditional relational databases and/or distributed systems such as Hadoop / Hive, BigQuery, Redshift.
  • Experience programming languages (e.g. Python, R, bash) preferred.
  • 1+ years of experience with workflow management tools (Airflow, Oozie, Azkaban, UC4)
  • Good understanding of SQL Engines and able to conduct advanced performance tuning
  • Experience with Hadoop (or similar) Ecosystem (MapReduce, Yarn, HDFS, Hive, Spark, Presto, Pig, HBase)
  • Familiarity with data exploration / data visualization tools like Tableau, Looker, Chartio, etc.
  • Ability to think strategically, analyze and interpret market and consumer information.
  • Strong communication skills written and verbal presentations.
  • Excellent conceptual and analytical reasoning competencies.
  • Degree in an analytical field such as economics, mathematics, or computer science is desired.
  • Comfortable working in a fast-paced and highly collaborative environment.

About Disney Streaming Services:

Disney Streaming Services is responsible for developing and operating The Walt Disney Companys direct-to-consumer video businesses globally, including the ESPN+ premium sports streaming service; the upcoming Disney subscription video service; and BAMTECH Media, a global leader in direct-to-consumer video streaming products and solutions. Our core mission is to deliver global audiences the freedom to access content on their terms across any connected device, time or location. We serve consumers by bringing the worlds most beloved characters, timeless stories, legendary athletes, and epic sporting events to global audiences through best-in-class direct-to-consumer video services. We strive daily to imaginatively challenge convention with innovative technology that gives consumers the freedom to access content on their terms across any connected device, time or location.

About The Walt Disney Company:

The Walt Disney Company, together with its subsidiaries and affiliates, is a leading diversified international family entertainment and media enterprise with the following business segments: media networks, parks and resorts, studio entertainment, consumer products and interactive media. From humble beginnings as a cartoon studio in the 1920s to its preeminent name in the entertainment industry today, Disney proudly continues its legacy of creating world-class stories and experiences for every member of the family. Disneys stories, characters and experiences reach consumers and guests from every corner of the globe. With operations in more than 40 countries, our employees and cast members work together to create entertainment experiences that are both universally and locally cherished.

This position is with Disney Streaming Services LLC, which is part of a business segment we call Disney Streaming Services.

Disney Streaming Services LLC is an equal opportunity employer. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Disney fosters a business culture where ideas and decisions from all people help us grow, innovate, create the best stories and be relevant in a rapidly changing world.

Categories

Posted: 2019-11-19 Expires: 2020-01-12

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Modeler - Data Architecture

Walt Disney Studios
San Francisco, CA 94102

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast