Reporting Analyst

  • Irvine, CA
  • Full-time

Company Description

Headquartered in Irvine, California, JetSuite’s vision to provide the freedom and exhilaration of private air travel to more people than ever is realized through efficient operations, acute attention to detail, acclaimed customer service, and industry-leading safety practices. And JetSuite continues to be the only jet charter company to guarantee its instant, online quotes for its fleet of WiFi-equipped JetSuite Edition CJ3 and Phenom 100 aircraft. 
 
The fastest growing jet charter company in the nation, JetSuite is backed by some of the strongest names in aviation and customer service, including David Neeleman (Founder, JetBlue Airways & CEO, Azul Brazilian Airlines); Tony Hsieh (CEO, Zappos.com); and Art Samberg (Founder, Pequot Partners). Its executive team includes CEO Alex Wilcox (Co-Founder, JetBlue Airways), President Keith Rabin, VP of Operations Brian Coulter and VP of Sales Dave Myrick. 
 
JetSuite offers one-off charter as well as SuiteKey Membership, through which perks such as discounted hourly rates, more flexible change policies, and a dedicated Guest Services team are accessed.  For further information visit www.jetsuite.com, and become a fan atwww.facebook.com/jetsuiteair to view the company's last minute daily SuiteDeals.

Job Description

Position Summary:

JetSuite’s Reporting Analyst understands and helps define JetSuite’s data sources and systems and can generate useful business reports from a variety of JetSuite systems and applications including Salesforce, Astro (JetSuite’s operations management software) and Google Analytics.

 

The role performs complex analytics using software and various reporting tools to analyze operational and customer data in a consistent and organized fashion. This information will be used to make marketing and other business decisions across all departments including marketing, sales, guest services, and operations.

 

One of the many responsibilities of this role will be providing upper management with valuable analysis and reporting using Microsoft SQL, Tableau and other tools (as required) to effectively generate reports from JetSuite’s other systems.

 

JetSuite’s Reporting Analyst has an appetite for analytics, software, business and managing various technologies, and also a passion and understanding of JetSuite’s customer service standards and unique operational challenges.

Primary Responsibilities include, but are not limited to:

  • Maintain a thorough understanding of JetSuite’s existing technologies, setbacks and goals across all departments
  • Be engaged in JetSuite products, culture, and customer service promise.
  • Reporting and Analysis Responsibilities:
    • Evaluate data across multiple platforms and offer meaningful analytical insight to department managers
    • Understand JetSuite’s databases, systems, and software development
    • Utilize Tableau and SQL to design and maintain various management reports
    • Develop management dashboards, automated reports, and report templates that monitor business metrics and enabling deeper understanding of business trends
    • Provide strong analysis to upper management to support business decisions
    • Build custom datasets using SQL for reporting and analysis
    • Fulfill reporting requests from managers

Qualifications

Education & Experience

  • Bachelor’s Degree in Computer Science, Information Systems, Engineering, Math, or similar preferred
  • Tableau Developer or similar data visualization tool
  • Demonstrated project discipline and experience
  • Experience with and understand of Database design
  • Understanding of data warehouse architecture and large data storage
  • Analytical aptitude with an ability to translate data into everyday language
  • Business intelligence to research and select appropriate technology-based tools to help increase sales

Knowledge & Skills

  • In depth knowledge of Microsoft SQL Server and Microsoft SQL Server Reporting Service
  • Proficient in Microsoft Excel, Word, and PowerPoint
  • Effective verbal and written communication skills
  • Must be fluent in SQL and must posses development, trouble-shooting and performance tuning skills
  • Salesforce Certification not required, but highly desired
  • Ability to work independently in a small office environment, solve problems and make decisions with minimal supervision.
  • Proactive; consistently takes initiative and always closes the loop
  • Analytical aptitude with an ability to translate data into everyday language

Physical Demands/Working Conditions:

  • Intermittent physical activity including bending, reaching and prolonged periods of sitting.
  • Ability to occasionally lift 5-20 pounds.