Senior Analyst, Data Engineering
The Walt Disney Company
full-time
Posted on:
Location Type: Hybrid
Location: Celebration • California, Florida • 🇺🇸 United States
Visit company websiteSalary
💰 $133,800 - $154,800 per year
Job Level
Senior
Tech Stack
CloudETLInformaticaPythonSQL
About the role
- 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
Requirements
- 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
Benefits
- A bonus and/or long-term incentive units may be provided as part of the compensation package
- full range of medical, financial, and/or other benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythonSnowflakeETLELTdata modelingdata warehousingdata transformationdata integrationdata cleansing
Soft skills
critical thinkinganalytical skillsproblem-solvingattention to detailcollaborationcommunicationtime managementprofessionalismadaptabilitystakeholder engagement