Snowflake developer - HCLTech (Fredericton)

Role: Snowflake Senior Technical Lead

Responsibilities

• 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, versatile 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.

Qualifications

• 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, spend, cost allocation recovery).
• Familiarity with workflow orchestration tools (DBT, Airflow).
• Knowledge of financial, accounting, or technology operations systems and data such as SAP, Clarity, ServiceNow, Cognos Planning.
• Demonstrated ability to work collaboratively in cross‑functional teams.
• Strong communication skills; experience writing documentation and partnering with non‑technical partners.

Nice-to-Have

• 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.

Skill Requirements

• Python
• Snowflake
• Data Build Tool (DBT)
• MS SQL