Snowflake Senior Technical Lead

Job Summary

Responsibilities of Role (List in order of priority, first few bullets should be the most important):

• Design and Build Data Pipelines: Develop, automate, and maintain scalable data pipelines to bring together financial and operational data (GL, vendor invoices, headcount, budgets) from multiple enterprise sources into Snowflake.

• Model and Structure Data: Partner with architects to develop robust data models and create semantic layers, enabling user-friendly, flexible reporting and analysis.

• Implement Cost Allocation Logic: Write performant SQL and/or Python code that automates multi-layer allocation engines, cost pool processing, and service-level analytics.

• Collaborate Across Borders: Work closely with product managers, finance teams, AI/ML engineers, and QA to deliver governed, high-quality solutions on schedule.

• Automate and Optimize: Leverage workflow/orchestration tools (such as Snowflake Tasks, DBT, or Airflow) and adopt CI/CD/code versioning best practices for reliability and speed.

• Ensure Data Quality & Auditability: Implement and maintain reconciliation processes, checks, and IT controls to meet Disney’s high standards for trust, compliance, and transparency.

Support and Evolve: Provide operational and incident support, performance tuning, and assist with continuous improvement of Enterprise Data & Analytics infrastructure

Key Responsibilities

Must Haves (Years of Experience, languages, programs, tools, etc.):

• 5+ years of experience as a Data Engineer, with emphasis on cloud data platforms (Snowflake strongly preferred).

• Expertise in advanced SQL for data transformation & modeling (e.g., window functions, CTEs).

• Working experience with Python for ETL/ELT, automation, or analytics.

• Hands-on experience delivering robust, maintainable data pipelines for complex enterprise environments.

• Prior experience developing financial cost models (Financial planning, financial spend, cost allocation & recovery, etc.)

• Familiarity with workflow orchestration tools (DBT, Airflow, etc.).

• Knowledge of financial, accounting, or technology operations systems and data such as SAP, Clarity, Service Now, Cognos Planning and other similar systems.

• Demonstrated ability to work collaboratively in cross-functional teams.

• Strong communication skills; experience writing documentation and partnering with non-technical partners.

Skill Requirements

Nice To Haves (see above):

• Familiarity with Generative AI tools such as Snowflake Cortex AI

• Knowledge and experience working with Technology Business Management (TBM) framework and methodology

• Strong understanding of corporate finance & accounting processes

Other Requirements

null