Data Warehouse Engineer - Second Life // Games industry jobs

Jobs

Games industry jobs Data Warehouse Engineer - Second Life

Job Title	Data Warehouse Engineer - Second Life
Job Category	Programmers
Job Description	Second Life – Where Worlds are Born. Second Life is a 3D virtual world entirely created by its Residents (people like you) that's bursting with entertainment, experiences, and opportunity. The company behind it, Linden Lab, was founded in 1999 to create a revolutionary new form of shared experience. The Second Life Grid provides the platform where Second Life resides and offers the tools for business, educators, nonprofits, and entrepreneurs to develop a virtual presence. Headquartered in San Francisco, Linden Lab has over 200 employees spread across the globe and are now growing its European Studio based in Brighton, UK. Overview: We are looking for a brilliant data warehousing professional to build and maintain the critical warehouse infrastructure that support our team in making smart business decisions. This software engineering role at Linden Lab contributes to the organization's success through expertise in data warehouse design and ETL (Extraction, Transformation & Loading of data). Qualified individuals will have a solid background in the fundamentals of Data Warehousing as well as mastery of SQL and relational database design. Responsibilities: Warehouse Design - Work with the Operations team and the reporting business analyst to implement a solid, extensible warehouse design that supports the new analytics requirements. Warehouse ETL - Build and maintain code to populate the data warehouse with data loaded from production databases. Perform all necessary data transformations to populate data into a warehouse table structure that is optimized for reporting. On-going Warehouse Maintenance - Quickly assess the impact of production system changes to existing analytics and implement changes to the warehouse ETL and reporting code to ensure consistent and accurate reporting. Qualifications: - 3+ years experience working extensively with SQL. (Mastery of SQL and relational concepts). - Experience with the design and implementation of scripts that populate large relational data warehouse environments (with tables that contain millions of rows). - Solid understanding of rational index design and SQL statement optimization techniques. - Ability to work in a collaborative, entrepreneurial environment on really interesting problems - Must be able to use sound judgment to develop effective solutions from loosely stated requirements. - Intense attention to detail - Should be able to effectively QA own work product to make sure that warehouse data is complete and accurate. - Exceptional problem solving and communication skills. - Authorized to work in the US. - Proficiency with Perl a plus. - Entrepreneurial or start-up experience. Apply: This job is being exclusively managed by our retained recruitment partner Day One Search. Therefore, if you feel you are a good fit for the role, please send your CV to secondlife@dayonesearch.com for immediate consideration. For any enquires please call on 01273 863622. Your application will be treated as confidential.
Location	UK & Europe, England, South East, Brighton
Salary	Based on Experience
Date posted	06/05/2008
Recruiter	This job is advertised on behalf of Second Life using their internal reference LL/DataW001.