Sr. Analyst, Data Engineering (PH)

The mission of The Walt Disney Company is to entertain, inform and inspire people around the globe through the power of unparalleled storytelling, and we can only achieve that through enhancing the success of the phenomenal Employees and Cast Members that make up The Walt Disney Company.

People Insights is a Center of Excellence (CoE) within Disney’s HR organization. We empower Human Resources leadership by delivering compelling and actionable people analytics—transforming organizational, HR, and Talent Acquisition data into a unified portfolio of business intelligence that helps our partners attract, engage, and retain the very best talent. At People Insights, we help tell the story of Disney’s most valuable asset: our people.

In this role, you’ll architect, implement, and optimize Snowflake data solutions to integrate data sourcing from a new Talent Acquisition application into Snowflake, including developing mappings and business logic to merge data into the current data model allowing secure, user-friendly data access to current and historical data for reporting and analytics. You will collaborate with cross-functional partners and leverage the latest cloud and data technologies to empower business teams with reliable, accessible insights.

Key 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.

- Work closely with stakeholders to gather data and reporting requirements, ensuring deep understanding of business needs and outcomes.

- Collaborate with report engineers, business analysts, and data scientists to deliver impactful data solutions.

- Create and maintain thorough documentation for data specifications, models, design decisions, and key reporting use cases.

- Train and support end users to facilitate adoption and successful utilization of data-driven tools and solutions.

Basic Qualifications:

- 5+ years of proven experience in data management, data engineering, business intelligence, or a related field.

- 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).

- Strong critical thinking, analytical, and problem-solving abilities with meticulous attention to detail.

- 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.

- Familiarity with artificial intelligence or machine learning concepts.

- Bachelor’s degree in Computer Science, Engineering, Mathematics, Information Systems, or a related field, or 7+ years of relevant work experience.

Preferred Qualifications:

- 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.

The hiring range for this position in Burbank, Glendale, Anaheim, and Bristol is $133,800 to $154,800 per year and in NYC and Seattle is $140,200 to $162,200 per year. 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. This position can be located near any Disney Hub (Burbank, Anaheim, Glendale, Orlando, Bristol, New York, or Seattle) with potential opportunities for remote work.