Company Info
Careers
Makena Technologies - Data Warehouse Engineer
Makena Technologies is an exciting new entertainment and communications company focused on online interaction. We are known for our groundbreaking consumer service called "There" (www.there.com), the first online destination where members can meet people, hang out with friends, play games, explore, have fun and even help build their own world - all in a spectacular 3D graphical environment.

Two years after it's public launch, There has a highly engaged and loyal member base. "There" offers a rich array of community-oriented activities, many of which have been initiated by the members themselves. There is a society in itself; complete with its own economy in which many members have created their own enterprises. Recent advancements in our unique` technology platform will allow for even more innovative ways for members to interact, create their own spaces, and even earn in-world currency.

Given our strong position, the explosion of online interaction in the marketplace and abundant opportunities for enhancing our 3D world, our company is poised for dramatic growth. New investment and hiring have lead to many improvements in the product, which are leading to significant increases in membership, revenue, and excitement about the product and the company.

From its inception, the There platform was designed with the data warehouse in mind. It is continually gathering information the operation of the There world, how our customers use the product, how visitors experience the product, the site; literally everything about our product and the World. As a data warehouse engineer, you’ll be a key part of helping us understand our customers and business and making There and Makena technologies a successful company.

This position is located in either Makena's Southern California office, which is in Laguna Beach, or our Northern California office, which is in San Mateo.
Responsibilities:
Develop scripts, programs, and schemas to load There’s extensive array of facts into our data warehouse.
Develop scripts, programs, and schemas to facilitate ETL (extract, transform, and load) for our data warehouse.
Maintain and monitor the data warehouse’s MySQL instance(s) to ensure it’s proper operation and availability. This will include DBA-level work to maintain table spaces, monitor performance, etc.
Maintain and monitor the data warehouse’s backup processes and scripts to ensure their correct operation.
Work with other groups to define, produce, and refine periodic reports about There’s business. These reports may include information about web traffic, membership, member activities in the world, commerce, etc. and may be developed in SQL, scripting languages, or Excel.
Ensure that periodic (daily flash, weekly, and monthly) reports are delivered in a timely and accurate fashion.
Work with other groups to define, deliver, and refine and execute ad-hoc reports as requested.
Research, propose, plan, and implement a Datamart strategy for ad-hoc reporting needs in There.
Requirements:
2+ years of experience with MySQL, Oracle, or other relational RDBMS software.
2+ years of experience with scripting languages such as Perl, Python, etc
2+ years of experience with data warehouse, ETL, or data mart applications.
Linux or other Unix platform experience a must.
Experience with Excel a plus.
Experience with C++ a plus.
To apply, please send a cover letter with your resume to careers@thereinc.com. Include the words Data Warehouse Engineer in the subject line of your e-mail.
©2008 Makena Technologies, Inc. All rights reserved.