Snowflake developer - HCLTech (Mercier)

Role: 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, ServiceNow, Cognos Planning and other similar systems. Demonstrated ability to work collaboratively in cross-functional teams. Solid communication skills; experience writing documentation and partnering with non-technical partners. Skill Requirements

Nice To Haves

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. Must Have Skills

Python Snowflake Data Build Tool (DBT) MS SQL

#J-18808-Ljbffr