The Walt Disney Company is looking to enhance the success of its Employees and Cast Members through data-driven insights, by integrating data sourcing from a new Talent Acquisition application into Snowflake and delivering compelling and actionable people analytics.
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 and Talent Acquisition data, systems, and processes (e.g., Workday, BrassRing, Phenom).
- Knowledge and practical experience with data processing and analysis tools such as Streamlit or Dataiku.
- In-depth understanding of data warehousing concepts and best practices.
- Experience with cloud and data technologies
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.
