Data Integration Analyst

About the Role & Team

"We create happiness.” That’s our motto at Walt Disney Parks and Resorts, and it permeates everything we do. At Disney, you’ll help encourage that magic by enabling our company to push the limits and build the never-before-seen! Are you ready to join this team and make an impact?

Disney Experiences (DX) brings stories, characters and franchises to life through Parks & Resorts, toys, apps, apparel, books, and stores. As Walt said, “You can dream, create, and design the most wonderful place in the world…but it takes people to make the dream a reality.” Walt Disney Parks & Resorts is an industry leader in labor management, empowering best-in-class Cast Members to deliver Disney’s legendary Guest service.

What You Will Do

This position is part of the Labor System team which provides holistic system and data strategy, optimization, and support for all labor and workforce management systems across domestic sites. In this role you will work on the integration, design, implementation and maintenance of data solutions across multiple systems, sites, and different environments – including a strategic transition from on-premise to cloud infrastructure.

The role reports to the Manager-Data Integration.

Responsibilities

• Design and develop data architecture, data modeling, and ETL mapping solutions
• Follow best practices for data creating and managing the data extraction, transformation and loading (ETL) framework
• Maintain an up-to-date knowledge of IT technologies and developments. This may involve attending seminars, training events and reading relevant journals and technical documentation
• Break large complex problems into small and testable tasks
• Understand, recommend and support robust reporting and analytic architectures
• Maintain user connectivity and provide adequate security for data warehouse
• Monitor the data warehouse and business intelligence system performance and integrity and provide corrective and preventative maintenance as required
• Develop unique, well documented solutions to meet the immediate and long-term needs of information customers and stakeholders
• Collect, process, and analyze large data sets
• Perform ad hoc analysis as necessary
• Manage and prioritize multiple tasks independently in a fast paced environment
• Participate in an on-call rotation and cross functional sustainment duties with the team

Required Qualifications & Skills

• Proven experience with data analysis and data profiling using SQL and other tools
• Demonstrated ability with the Microsoft Data Warehousing and Business Intelligence stack (SQL Server, SSIS, SSRS)
• SQL, databases, and data Warehouse experience
• Strong written, oral communication, presentation, and interpersonal skills
• Ability to think strategically, analyze data
• Strong work ethics with phenomenal attention to detail and quest for quality

Preferred Qualifications

• Experience with Snowflake
• Python knowledge

Additional Information

The base pay actually offered will take into account internal equity and also may vary depending on the candidate’s geographic region, job-related knowledge, skills, and experience among other factors. A bonus and/or long-term incentive units may be provided as part of the compensation package, in addition to the full range of medical, financial, and/or other benefits, dependent on the level and position offered.

Disney offers a rewards package to help you live your best life. This includes health and savings benefits, educational opportunities, and special extras that only Disney can provide. Learn more at https://jobs.disneycareers.com/benefits.

#DXOpsleadership