Data Analyst, Interactive Insights & Analytics

Universal Orlando Resort -- home of the world's two most amazing theme parks, Universal Studios and Universal's Islands of Adventure, the extraordinary Universal CityWalk entertainment center and our three fabulous hotels, PORTOFINO BAY, HARD ROCK and ROYAL PACIFIC -- is currently seeking the following professional to join our team.



Data Analyst, Interactive Insights & Analytics




Create, manage and distribute critical marketing- and research-related reports. Develop, maintain and troubleshoot integrated systems for collecting, managing and reporting on key research, analysis, and online sales metrics using SQL-based database and reporting technologies including (but not limited to) SAS, Crystal Reports, SQL, Excel, Access, and our online analytic tools including Omniture SiteCatalyst, Omniture Discover, Opinionlab, ResponSys, and others. As a member of the marketing team, partner with the Information Services team to ensure best-of-class data management, analytics and reporting.





Job Responsibilities:


Create, manage and regularly distribute critical marketing- and research-related production and ad-hoc reports. Develop, maintain and troubleshoot integrated systems for collecting, managing, and reporting on key research, analysis and online sales metrics using SQL-based database and reporting technologies such as SAS, Crystal Reports, SQL, Excel, Access, and our online analytic tools. Document all systems and processes as appropriate.
Work closely with the Information Services team to develop and maintain a data mart to manage, track and report on marketing information using appropriate technologies and tools.
Serve as the primary technical liaison with our web analytics vendors/systems. Develop, run and distribute reports and dashboards as required in Omniture, Opinionlab, and other relevant web analytic tools used to track and understand customer behavior as it relates to our web sites, online advertising, and interactive programs.
Identify system problems, communicate details and provide solutions on a pro-active, self-directed basis. Work with the website technical development team and project management team to ensure pages are optimized for data collection.
Perform other duties as assigned.





Job Requirements:


Bachelor’s degree from a four year college or university in Computer Science or related required.
1-3 years with data collection methodologies and reporting required (advanced knowledge of SQL); 1-3 years prior experience developing reports using SAS and/or Crystal Reports is a plus; experience working with SQL Server databases also a plus
Experience with Microsoft Excel (advanced):
• Must be able to develop and understand advanced Microsoft Excel spreadsheets with the capability to program in VBA as necessary to accomplish necessary ends.
Experience with Microsoft Access (advanced):
• Should be able to create queries and data analysis applications using Microsoft Access.
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.
• Prefer experience with SAS and/or Crystal Reports XI
Experience administering web analytics packages:
• Omniture, Opinionlab dashboard creation, report creation experience a plus;
Experience programming with web languages including HTML, JavaScript and Flash a big plus
• Strong command of Internet technologies and database software;
• Demonstrated ability to install, configure, learn, use and explain enterprise software products.
• Self-starter and able to work on own initiative with minimal supervision.
Desire to work in a fast paced environment





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



We regret, due to the volume of responses, only applicants of interest will be contacted.


To go directly to this position cut and paste the Job Posting number: UO128634



Universal

It's a big universe. Where do you fit in?

To Apply for this position, please CLICK HERE