Snowflake developer

Role: Snowflake Senior Technical LeadSection Title: Job SummaryJob SummaryResponsibilities 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 infrastructureSection Title: Key ResponsibilitiesKey ResponsibilitiesMust 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, ServiceNow, 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.Section Title: Skill RequirementsSkill RequirementsNice To Haves (see above):Familiarity with Generative AI tools such as Snowflake Cortex AIKnowledge and experience working with Technology Business Management (TBM) framework and methodologyStrong understanding of corporate finance accounting processesSKILL section. 4 of 6.Section Title: Must Have SkillsMust Have SkillsClick Enter to show the proficiency description of PythonPythonClick Enter to show the proficiency description of SnowflakeSnowflakeClick Enter to show the proficiency description of Data Build Tool (DBT)Data Build Tool (DBT)Click Enter to show the proficiency description of MS SQLMS SQL