Analytics Technical Lead / Business Intelligence Engineer
We are a venture- backed creator and publisher of games exclusively for the iPhone & iPod Touch. We think the iPhone is the next great gaming platform, and it’s the first of a class of devices that will radically reshape the landscape for mobile games. We are committed to developing the very best of those games and entertainment experiences for the iPhone. We are seeking individuals who will participate and contribute to our growth, and who will enjoy our fun, dynamic and focused business environment.
The position
We need a talented, passionate individual to manage our analytics and data warehouse function. You will be expected to take ownership of the existing data warehouse infrastructure, implement optimizations and monitor ongoing data processing and reporting functions. Additionally, you will work with business leaders to identify critical metrics then implement and maintain business intelligence reporting tools. Importantly, the applicant is expected to possess superior technical and analytical skills, have excellent communicative abilities with an upbeat attitude and a tremendous work ethic.
Responsibilities
Primary responsibility is to build and maintain the data warehouse and metrics reporting infrastructure as well as the integration elements necessary to tie key systems together with common, timely, and accurate data
Provide proactive investigation, review, assessment, design and implementation of methods to improve existing processes, performance, security and data access
Evaluate end-user business needs and translate them into technical requirements, then develop and implement the appropriate technical solutions
Document the technical architecture diagram as well as the specific hardware / software and critical analytic solutions
Create insightful reports that help monitor business performance
Assess existing and available data warehousing technologies and methods to ensure our BI architecture meets our needs and allows for business growth. Provide recommendations on evolution of the architecture.
Responsible for installing professional and efficient processes that allow for proper governance
Technical Skills Required
Linux, MySQL, Ruby on Rails, PHP, business intelligence solutions
Scripting experience with Ruby. Python a plus
Working knowledge of SQL DB structures and queries
Additional – J FreeCharts, Quartz
Skills Required
Bachelors degree
5 years, minimum, work experience in data warehousing and analytics
Working knowledge of BI architectures, relational and dimensional data modeling
Experience delivering data warehouse solutions including data extraction (ETL), reporting and ad hoc analysis tools
Understanding of database objects (tables, views, keys, indexes, stored procedures, principles and securables)
Project management skills and understanding of systems analysis concepts
Strong analytical and problem solving skills
Strong communication (oral and written), interpersonal, presentation, and organizational skills required
Ability to successfully interact effectively with all levels in the organization
High level of initiative and critical thinking to formulate business issues into analytical problems and devise actionable solutions
Highly detail oriented and organized in work
Ability to act and operate independently with minimal daily direction from manager to accomplish objectives
Skills Desired:
Experience in the video game / online industry preferred
Working experience in large Data Warehouse / Business Intelligence environments.
Applications are now closed.

Ruby on Rails jobs in San Francisco Feed