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.
#LI-AB1