Analyst, Data Integration- Consumer Insights

Universal Orlando Resort believes in-person collaboration is key to our success. Many of our Team Members work in a hybrid capacity, contributing from the workplace a minimum of three days per week. There are also roles that require being on-site full time. Limited remote opportunities may be available within specific departments. You’ll learn more about this during the recruitment process.

JOB SUMMARY: The Consumer Insights team within Universal Parks & Resorts (UPR) conducts research among guests and future visitors to learn about them and their experience, using survey research as well as other approaches. The Data Integration Analyst with the Systems Team within UPR Consumer Insights provides insight for leaders across the division by using the Alteryx data platform to transform research data for use in reports, dashboards, and further analysis. This position requires a person who is comfortable with databases, SQL (Structured Query Language), and ETL (Extract, Transform, Load) processes, as the Data Integration Analyst will be responsible for managing separate survey data sources, standardizing, and storing them appropriately in servers and databases that they oversee. To be successful in this position, candidates will need a high degree of conscientiousness and take ownership of the cleanliness and quality of the data. Workflows that are designed by the CI Data Integration Analyst will be used widely to move and transform data, preparing it for reporting and further consumption by partners within Universal Parks and Resorts.

MAJOR RESPONSIBILITIES

Modifies and blends data collected from surveys and other systems for use in reporting by designing workflows in the Alteryx application to move data, validate data, standardize data, and create derived data. Creates and manages new database structures (fields, tables, views, etc.) and validates collected data using other sources to assist the reporting and analysis of survey data. Helps maintain databases and data connections used with survey data. Works on self-directed special projects to enhance professional abilities, department initiatives, or efficiencies. Configures APIs used to connect data sources. Maintains familiarity on all systems and processes utilized by the CI Systems team. Understands and actively participates in Environmental, Health & Safety responsibilities by following established UO policy, procedures, training and team member involvement activities. Performs other duties as assigned.

SCOPE

The Consumer Insights Systems team provides critical technical infrastructure support for both Universal Orlando Resort and Universal Studios Hollywood. The Data Integration Analyst is integral to further developing, aligning, automating, and maintaining systems to allow for the delivery of key data to senior leadership with a focus on reliability, security, and efficiency.

EDUCATION: Bachelor’s degree is required.

EXPERIENCE: 3+ years of exemplary performance as a CI Associate Data Integration Analyst, or equivalent experience in data management, data transformation, and database development, or an 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 Orlando 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 Orlando HR/Recruitment will be deemed the sole property of Universal Orlando. No fee will be paid in the event the candidate is hired by Universal Orlando as a result of the referral or through other means.

Universal Orlando Resort. Here you can.

Universal Orlando is an equal opportunity employer. Universal elements and all related indicia TM & © 2024 Universal Studios. All rights reserved. EOE