Sr Analyst, Report Engineering

About the Role & Team
Job Description
At Disney, we're storytellers. We make the impossible, possible! We do this through using and developing innovative technology and opening up the boundaries to bring stories to life. Now is your chance to join our versatile team that delivers unparalleled creative content to audiences around the world.
As a Reporting Engineer for People Insights, you will be responsible for designing, developing, and maintaining objects within Snowflake to support end users through reports, dashboards, and other solutions. People Insights is a Center of Excellence (CoE) that enables TWDC Human Resource leadership to attract, engage, and retain talent through compelling and actionable People Analytics. We transform organizational, HR, and Talent Acquisition data into a unified BI portfolio that empowers clients to create compelling stories about our most valuable resource: people.
What You Will Do
This Reporting Engineer role requires a solid understanding of Snowflake architecture, SQL, and BI tools.
Data Structures and Modeling

• Design, develop, and maintain Snowflake objects such as tables, views, stored procedures, and user-defined functions to support reporting requirements
• Use programming languages to compile complex data into a format that reporting tools can efficiently handle
• Apply advanced knowledge of data warehouse structures/models and design principles to optimize data extraction and transformation

Reporting Development and Optimization:

• Translate report requirements into technical specifications for data model builds and report construction
• Identify opportunities to improve query performance, data loading processes, and overall system efficiency within Snowflake
• Continuous optimization and fine-tuning of reports and reporting processes for improved performance
• Explore new tools, technologies and standard processes to improve efficiency and provide innovative solutions

Automation:

• Build data pipelines that cleanse and combine information from disparate sources
• Consult with cross-functional teams, including data engineers, to deliver data pipelines that efficiently render in reporting tools

Collaboration:

• Collaborate with collaborators to gather reporting requirements and deeply understand the business needs & outcomes
• Work closely with cross-functional teams including data engineers, business analysts, and data scientists to deliver impactful reporting solutions

Documentation and Training :

• Create and maintain comprehensive documentation of report specifications, data models/design decisions, and reporting use cases to ensure knowledge transfer and support continuity
• Provide training and support to end users on accessing and interpreting solutions to ensure successful adoption and utilization of tools

Required Qualifications & Skills

• 2+ years of proven experience in report engineering, data analytics, data engineering, or similar
• Bachelor's degree in Computer Science, Information Systems, Data Analytics or similar discipline
• Expertise in scripting languages such as SQL and Python, and experience with database technologies such as Snowflake
• Experience developing reports and dashboards using tools such as Tableau, Power BI, or Cognos
• Strong critical thinking and problem-solving skills and attention to detail
• Strong collaboration and communication skills with the ability to collaborate effectively with cross-functional teams
• Ability to work effectively in a fast-paced environment and manage multiple priorities
• Effectively handle and maintain confidential information

Preferred Qualifications:

• Experience with HR data, systems, and processes (e.g. Workday, SAP)
• Knowledge of data warehousing concepts and methodologies
• Experience with AI or machine learning concepts

Disability accommodation for employment applications
The Walt Disney Company and its Affiliated Companies are Equal Employment Opportunity employers and welcome all job seekers including individuals with disabilities and veterans with disabilities. If you have a disability and believe you need a reasonable accommodation in order to search for a job opening or apply for a position, email [email protected] with your request. This email address is not for general employment inquiries or correspondence. We will only respond to those requests that are related to the accessibility of the online application system due to a disability.
The Walt Disney Company is an equal opportunity employer. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Disney champions a business environment where ideas and decisions from all people help us grow, innovate, create the best stories and be relevant in a constantly evolving world.
The hiring range for this position in Burbank is $111,900-$136,700 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.