The Walt Disney Company is looking to enhance the success of its employees and cast members by delivering compelling and actionable people analytics, transforming organizational, HR, and Talent Acquisition data into a unified portfolio of business intelligence.
Requirements
- Advanced proficiency in SQL and Python, and hands-on experience working with Snowflake or similar cloud data warehouse platforms.
- Experience designing and developing ETL/ELT processes using tools such as Informatica, Snowflake, or Python, and familiarity with agile development tools (Jira, Confluence, Git).
- Familiarity with artificial intelligence or machine learning concepts.
- Experience working with HR data, systems, and processes (e.g., Workday, SAP).
- Knowledge and practical experience with data processing and analysis tools such as Streamlit
- In-depth understanding of data warehousing concepts and best practices.
- Hands-on experience with Snowflake or similar cloud data warehouse platforms.
Responsibilities
- Design, develop, and maintain robust Snowflake objects, including tables, views, stored procedures, and user-defined functions, to enable efficient reporting and analytics.
- Build and automate scalable data pipelines to cleanse, integrate, and transform data from diverse sources.
- Leverage SQL, Python, and other programming languages to prepare complex datasets for visualization and reporting tools.
- Apply advanced data warehouse modeling principles to optimize data extraction, transformation, and loading processes.
- Translate business requirements into technical specifications for data modeling and report building.
- Identify and implement opportunities to enhance query performance, data load efficiency, and overall system optimization within Snowflake.
- Create and maintain thorough documentation for data specifications, models, design decisions, and key reporting use cases.
Other
- 5+ years of proven experience in data management, data engineering, business intelligence, or a related field.
- Bachelor’s degree in Computer Science, Engineering, Mathematics, Information Systems, or a related field, or 7+ years of relevant work experience.
- Excellent collaboration and communication skills; able to work effectively with cross-functional teams.
- Ability to thrive in a fast-paced environment while managing multiple priorities.
- High degree of professionalism, including handling and maintaining confidential information.
