30 Aug 2011

Full-Time Senior ETL Engineer

Riot Games – Posted by nosqljobsLos Angeles, California, United States

NOTE: This job listing has expired and may no longer be relevant!

Job Description

With League of Legends, one of the most played and critically acclaimed PC games today; Riot Games is a leading innovator in its mission to be the most player-focused game company in the world. At Riot you will work among the most gifted and passionate people in the industry as we hire only the most talented and collaborative people in their discipline. We believe the core reason for Riot’s success is people and we are committed to helping employees grow their abilities and careers, as we all continually focus on improvement.  We are serious professionals who don’t take ourselves too seriously. Named a Top 30 Developer by Game Developer Magazine, Riot Games is aggressively expanding, growing the company five-fold over the past two years, and still continuing the search for top talent.

We love BIG Data and we’ve got lots of it!  We are looking for a Sr. ETL Engineer that will be responsible the design and development of custom ETL systems for complex, multi-source data warehouse application, as well as for the configuration and implementation of analysis systems that include event logging and Hadoop clusters.  This position will work closely with the data technology and technical operations teams to manage our expanding analytics clusters.

Responsibilities:

  • Design table structures optimized for reporting and ad hoc analysis
  • Maintain data dictionary of tables, their relationships, column meanings
  • Support the database tuning/optimization operations
  • Create/test/maintain batch/near-time ETL process using extensible and modular code
  • Ensure quality and integrity of data. Define and implement data quality KPIs
  • Merge and clean multiple sources into data warehouse
  • Design optimal table structures for reporting and ad-hoc analysis
  • Interact with software engineers, data modelers, and other staff to ensure optimal ETL processes

Requirements:

  • SQL and analytic SQL functions skills
  • UNIX/Linux proficiency, hands on programming with some of Java, C/C++, Python, Perl, BASH
  • ETL experience:
    • Create/optimize queries against high-volume, high-availability OLTP/OLAP systems
    • Extended library of ETL functions using typical OO and abstraction principles
  • Strong understanding of systems administration and/or coding principles and concepts
  • Relational and/or data warehouse experience and strong data modeling (relational, multi-dimensional)
  • Experience with Hadoop, HBase, and Java is a strong plus
  • Experience on business intelligence tools, reporting and data mining in data warehouse environment is a plus
  • Ability to work in team environment
  • BS/MS degree in Computer Science or 5+ years of database engineering experience

How to Apply

To apply, please send your resume and cover letter with Sr. ETL Engineer | Name in the subject line to: platformjobs@riotgames.com

Job Categories: Engineering. Job Types: Full-Time. Job Tags: bash, c++, etl, hadoop, hbase, java, perl, python, and sql.

Apply for this Job

Loading...
Subscribe to Free, Weekly NoSQL E-mail Newsletter