OpenX is looking for a talented and highly motivated Business Intelligence guru to help in building out the Business Intelligence system that is used throughout the company. You will be working on solving big problems with elegant solutions while working with large data sets. This is serious big -data implementations (think of building dashboards / reporting against trillions of records) if you enjoy solving complex problems in a fast-paced environment, this is a great role for you.
Conduct complex SQL queries on data warehouse and work with other data extraction, reporting and analytic tools to develop management reporting.
Work with Business Users to define explicit business requirements for MicroStrategy Reports in support of strategic and/or tactical projects.
Design and create front-end dashboard / reports and queries to provide data access to business users through MicroStrategy / Tableau.
Convert the existing ad-hoc user requests / manual queries into Microstrategy dashboards / reportings and schedule Email Reportings / Proactive Alerts based on the needs of different groups.
5 + years experience as a Data Analyst, preferably in a data-intensive online advertising company.
Advanced SQL coding skills.
5+ years experience with using MicroStrategy to build reports.
Experience working in a multi-terabyte data volume environment.
Experience working on Data Warehouse platforms like Vertica and/or Hadoop/Hive.
Experience with developing business case scenarios and models.
Able to communicate clearly and professionally with all levels of an organization.
Strong interpersonal, written and verbal communication skills with demonstrated ability to work in a team environment.
Advanced degree in Business Administration, Finance, Mathematics, Statistics or Economics, a plus.
OpenX is a global leader in digital advertising technology and services, enabling digital media companies to manage and maximize their ad revenue. Our unique platform combines ad serving, a real-time bidding (RTB) exchange, yield optimization, and content valuation to deliver the highest revenue across every desktop, tablet, and mobile screen.
OpenX is backed by leading investors including Accel Partners, Index Ventures, SAP Ventures, Samsung Venture Investment Corporation, Mitsui & Co., Global Investment, Inc., and Presidio Ventures.
With 100% YOY growth the past 2 years, $153M in revenue and 275 employees ending 2012, OpenX is ranked #7 on Forbes' 2013 list of the Top 100 America's Most Promising Companies