NBC Universal Analyst, Business Intelligence in Orlando, Florida

Analyst, Business Intelligence

Job ID: 244817

Business Development

Orlando,FL

Universal Parks & Resorts is comprised of Universal Orlando Resort, Universal Studios Hollywood, Universal Studios Japan, Universal Studios Singapore, as well as a new destination coming in Beijing, China. We are a universe of opportunities for people who have a lot to offer. It takes a special kind of person to work at all of our destinations. An individual who knows how to be part of a team. Someone with a sense of fun who’s serious about their work. A person who knows it doesn’t take magic to put a smile on a guest’s face… it takes hard work, dedication, knowledge and just the right amount of Universal attitude. Universal’s theme parks offer exactly the kind of vacation families crave – bringing together popular culture’s most compelling stories, characters and adventures to create some of the world’s most innovative and entertaining attraction experiences. These are immersive, next-level, adventures such as The Wizarding World of Harry Potter™, outrageously fun attractions such as Despicable Me Minion Mayhem and highly themed, authentic experiences based on cutting-edge television, such as Race Through New York Starring Jimmy Fallon. We embrace the power of cultural diversity and inclusion and continuously strive to maintain a team that is a reflection of our global audience. Universal Parks & Resorts adheres to ‘The Universal Way’ by not just meeting guest expectations, but exceeding them, every time. Join us if you want to collaborate, innovate, develop, and deliver the most compelling entertainment experiences imaginable that drive growth for the Universal brand around the world. Universal Parks & Resorts provides world-class entertainment destinations with signature theme parks that create unparalleled entertainment.

JOB SUMMARY : The Business Intelligence Analyst will be focused on designing, developing and delivering critical reports, dashboards and analytic solutions for our core business groups in support of revenue management and pricing decisions. This is an opportunity to leverage your passion for analytics and business intelligence to add considerable business impact through delivery of critical BI solutions. You will team with diverse stakeholders across Express Pass, Food & Beverage, Merchandise and IT teams and work closely with them to determine reporting requirements and translate them into appropriate reporting tools. The IT team will serve as a close partner as you assure the flow of valid data from Universal Studios’ data lake to reporting tools and ensure accuracy and quality to BI reports. On an ongoing basis you will maintain, enhance and proactively design reports based on clients’ needs and changing environment.

MAJOR RESPONSIBILITIES:

BUSINESS INTELLIGENCE ARCHITECTURE

  • Design and develop business intelligence dashboards, analytic reports and data visualizations using Tableau as well as other reporting tools.

  • Gather report requirements from clients across the business to make sure they satisfy their needs and help them make strategic decisions.

  • Ability to document user requirements into a well-structured specification.

  • Critically evaluate information gathered from multiple sources.

  • Translate high-level information into insights and details.

  • Distinguish user requests from the underlying true needs.

  • Provide creative solutions to problems.

  • Responsible for QA of reports and dashboards to ensure accuracy.

  • Convert several current Legacy Excel reports into the Tableau environment.

DATA QUALITY ASSURANCE

  • Responsible for QA of reports and dashboards to ensure accuracy.

  • Team across departments to navigate and solve data problems if / as they occur.

AD-HOC BUSINESS INTELLIGENCE REPORTING

  • Build additional reports and dashboards as needed by the business.

PROJECT MANAGEMENT & COMMUNICATIONS

  • Manage incoming reporting requests and prioritize accordingly.

  • Excellent verbal and written communication skills and the ability to interact professionally with a diverse group that includes clinicians, management, and subject matter experts.

  • Successfully engage in multiple initiatives simultaneously.

  • Participate in and help lead weekly business intelligence status meetings

OTHER DUTIES

  • Assist in the performance of other special duties and projects as needed in support of organizational goals

  • Seek opportunities to help other team members expand their knowledge and capabilities in business intelligence

SCOPE: Key business intelligence expert and influencer of Revenue Management Graphical Interface and business intelligence development needs throughout the department.

QUALIFICATIONS:

  • Experience with Microsoft Excel (advanced);

  • Experience with Reporting Tools, preferably Tableau;

  • Experience with Planning Analytics preferred;

  • Experience with SQL and Relational Databases (advanced);

  • Must have thorough understanding of database structure;

  • Experience creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drill-down reports, analysis reports, etc.;

  • Working knowledge of databases including writing SQL queries required.

  • Excellent analytical skills required including advanced statistical and data mining techniques;

  • Ability to work independently in a deadline oriented environment;

  • Experience in troubleshooting and resolving problems;

  • Ability to work directly with internal departments towards issue resolution/project release;

  • Ability to evaluate quantitative data sets and determine ‘big picture’ implications required;

  • Ability to handle multiple projects required;

  • Desire to work in a fast paced environment required;

  • Proficiency communicating research results in written, visual and verbal form required.

EDUCATION: Bachelor’s degree required, preferably in Engineering, Computer Science or Math.

EXPERIENCE: 3+ years of experience with database queries and report and dashboard creation preferably in the consumer entertainment, travel or amusement park industry.

  • Strong background in all aspects of database technology, with an emphasis on the use of analytical and reporting tools.

  • Proficient in SQL Programming and reporting tools such as Tableau, COGNOS, Business Objects

  • Excellent written and oral communication skills

Experience/Knowledge in the following areas preferred/beneficial:

  • Travel & Resort Industry, Entertainment &/or Theme Park experience

  • CRM Analytics

  • Adobe Analytics

; or equivalent combination of education and experience

Your talent, skills and experience will be rewarded with a competitive compensation package.

Universal is not accepting unsolicited assistance from search firms for this employment opportunity. All resumes submitted by search firms to any employee at Universal Parks & Resorts via-email, the Internet or in any form and/or method without a valid written Statement of Work in place for this position from Universal Parks & Resorts HR/Recruitment will be deemed the sole property of Universal Parks & Resorts. No fee will be paid in the event the candidate is hired by Universal Parks & Resorts as a result of the referral or through other means.

IT’S A BIG UNIVERSE. WHERE DO YOU FIT IN?

Universal elements and all related indicia TM & © 2018 Universal Studios. All rights reserved. EOE