Data Warehouse Engineer - Playfirst

Data Warehouse Engineer

Data Warehouse Engineer

At PlayFirst, we believe you can have fun anywhere, any time and at any age. That’s why we’re committed to creating mobile games for everyone to enjoy, including the fan-favorite DASH® and Stars series of games like Diner Dash®, SpongeBob Diner Dash® and Mall Stars™. Whether you’re in line at the store, on your lunch break or lounging at home, you only need a minute to dive into a PlayFirst game—but you’ll find a lifetime of entertainment. PlayFirst games are played by tens of millions of fans worldwide, and we’re just getting started. To find out more about our talented team and our awesome games, please visit www.playfirst.com.

PlayFirst is funded by Doll Capital, Mayfield Fund, Trinity Ventures, and Rustic Canyon Partners. PlayFirst, Inc. is headquartered in downtown San Francisco.

Job Description

The candidate of choice for this role will be able to assess current data needs, explore options, and implement solutions in a highly dynamic and competitive industry. We’re looking for someone that has strong data warehouse experience working with SQL and NoSQL databases, is able to develop processes, build and tune SQL queries, and design schemas. Experience with ETL, big data (Hadoop cluster), OLAP, BI reporting and analysis tools are all pluses. The perfect candidate is a sharp, motivated, yet patient mind that can architect scalable solutions, accommodate changing priorities, and support key business analysis. That person will enjoy working in an agile environment where everyone's opinion is considered and we are all working together to make our company successful.

Primary Responsibilities

  • Involvement in all aspects of Data Warehouse database development and administration, including schema design, ETL process, monitoring, performance, query/database tuning and backup strategy.
  • Design, develop and maintain the Business Intelligence platform that includes all BI server management and development of new reports to support ongoing business needs.
  • Monitor and maintain data quality by implementing a strategy for correcting data errors, devising an alerting and triage system for ETL and data quality failures and developing automation for continuous validation of data quality and availability.

Minimum Requirements

  • Bachelor's degree (or higher) in Computer Science.
  • 5+ years experience working extensively with SQL in a *nix environment.
  • Strong knowledge and experience with one or more relational databases: PostgreSQL, MySQL, Oracle.
  • 3+ years of experience as a Data Warehouse/Business Intelligence developer with solid knowledge of data warehousing fundamentals: star schema, denormalization, etc. and relational database design concepts (modeling, design, metadata management).
  • 3+ years using ETL tools in a DW environment and custom ETL scripting
  • Experience with Kimball or Inmon methodologies and designing dimensional data models.
  • Proficiency in scripting languages (Bash, Ruby, Python, etc.) and Linux environments.
  • Ability to analyze source data for potential data quality issues and address these issues in the ETL procedures.
  • Experience in designing complex reports and ad hoc reporting.
  • Strong general SQL knowledge for utilization in query optimization and tuning in a DW/BI environment.
  • Strong technical understanding of data modeling, design and architecture principles and techniques across master data and derived/analytic data.
  • Experience developing applications in a startup environment emphasizing collaborative design and individual responsibility.
  • Strong verbal and written communication skills with ability to communicate complex technical concepts.
  • Must have current US work authorization.

Desired Qualifications

  • Experience and familiarity with the mobile games industry is a plus.
  • Familiarity and professional experience with AWS Redshift is a plus.
  • Recent experience with suite of tools such as Pentaho, Jaspersoft, Tableau is a plus.
  • Familiarity with Hadoop (HDFS/Hive/Pig/Hbase/Sqoop) or other MapReduce paradigms is a plus.
  • Experience and familiarity with Amazon Web Services is a plus.
  • Exposure to a statistical package (R, Weka, SAS, SPSS) is a plus

Benefits:

Core benefits include: health, dental, vision, life/disability insurance, flexible spending accounts, 401(k) and stock options. PlayFirst is located downtown in SOMA right by the financial district (2 blocks from the Embarcadero BART/Muni station and Ferry Building) and offers great fringe benefits, including generous paid time off & company holidays, weekly chair massages, daily catered breakfasts, free snacks and refreshments, and company-wide game jam and idea creation sessions to innovate the future of mobile gaming.

Salary and level to be determined by experience and education

To apply for this position, please email your resume in a standard Word or PDF document to jobs@playfirst.com and please include the exact job title in the subject line as above.

We are proud to be an equal opportunity employer