Director of Analytics at opentable

DIRECTOR OF ANALYTICS

JOB TYPE: Full-Time
LOCATION: Los Angeles, CA
DEPARTMENT: Engineering

At OPENTABLE, we take pleasure in Software Design. We believe that velocity comes from a commitment to clean code and solid engineering principles. We deliver innovative products through rapid, continuous development. We are passionate about building small, independent product development teams – product managers, designers and engineers working together empowered to make their own decisions.

JOB DESCRIPTION:

You will be part of a small and talented Data Analytics team. As OpenTable moves toward an event based architecture for all our application services, you will have the opportunity to work on new Analytics infrastructure. You will be communicating with Business Users directly to perform Business Analysis. You’ll also work on building a data pipeline from the new event based services to consume and store events and make them easily accessible for Analytics. Use Python or Scala to utilize Spark engine to process Events data stored in Amazon S3. And help in implement data feeds that go to our data warehouse and other systems.

RESPONSIBILITIES:

• Provide technical leadership for the entire MicroStrategy environment including Architecture, best practices, processes and development standards
• Architect MicroStrategy projects from end to end
• Analyzes requirements, designs and develops business intelligence applications to meet business needs.
• Support business users on answering complex business questions via MicroStrategy and ad-hoc SQL queries.
• Participate in requirements gathering sessions; works together with users to find the best possible solution to a given business problem
• Troubleshoot technical issues at all levels.
• Well conversant with current MicroStrategy products and tools and have means to solve any issues by reaching out to MicroStrategy Support and Forums.
• Relationship building with key business stakeholder
• Contribute to data aggregation strategy for reporting, dashboards, and self-service analytics

MINIMUM QUALIFICATIONS:

• Extensive experience in MicroStrategy Architecture and Development
• Hands-on expertise in data modeling, Icube, schema object design
• Experience on metadata creation, creating report specifications, integration, test planning, testing and implementation support
• Expert level experience in Report and Dashboard design and development
• Experience building highly customized reports and developing creative solutions to apply business logic
• Must have extensively worked on MicroStrategy Administration, Desktop, Web, Report Services Document, Distribution Services
• Must have good experience on Visual Insights
• Must have strong performance tuning and troubleshooting experience
• Must be able to debug and fix production/existing issues
• Strong experience reading and writing SQL
• Experience with Netezza and SQL Server databases preferred
• Must be able to work on one or more assignments simultaneously with minimal supervision
• Must be able to interact with business for requirement gathering and support
• Excellent verbal and communication skills

ABOUT OPENTABLE:

OpenTable, part of Booking Holdings (NASDAQ: BKNG), is the world's leading provider of online restaurant reservations, seating more than 16 million diners per month via online bookings across approximately 36,000 restaurants. Since its inception in 1998, OpenTable has seated more than 830 million diners around the world. The Company is headquartered in San Francisco, California, and the OpenTable service is available throughout the United States, as well as in Canada, Germany, Japan, Mexico, Australia and the UK.