Lead Data Engineer

Senior Data Modernization Expert

Overview

Key Responsibilities

Modernization & Migration

• Lead end-to-end migration of legacy data warehouses (e.g., Teradata, Netezza, Oracle, SQL Server) to Snowflake.
• Reverse-engineer complex ETL pipelines built in Talend or Informatica, documenting logic and rebuilding using modern frameworks (e.g., DBT, Snowflake Tasks, Streams, Snowpark).
• Build scalable ELT pipelines using Snowflake-native patterns, improving cost, performance, and maintainability.
• Design and validate data mapping, transformation logic, and ensure parity between source and target systems.
• Implement automation wherever possible (e.g., code converters, metadata extractors, migration playbooks).

Architecture & Cloud Integration

• Architect modern data platforms leveraging Snowflake’s full capabilities: Snowpipe, Streams, Tasks, Materialized Views, Snowpark, and Cortex AI.
• Integrate with cloud platforms (AWS, Azure, GCP) and orchestrate data workflows with Airflow, Cloud Functions, or Snowflake Tasks.
• Implement secure, compliant architectures with proper use of RBAC, masking, Unity Catalog, SSO, and external integrations.

Communication & Leadership

• Act as a trusted advisor to internal teams and client stakeholders.
• Present modernization plans, risks, and ROI to both executive and technical audiences.
• Collaborate with delivery teams, pre-sales teams, and cloud architects to accelerate migration initiatives.
• Mentor junior engineers and promote standardization, reuse, and COE asset development.

Required Experience

• 6+ years in data engineering or BI/DW architecture.
• 3+ years of deep, hands-on Snowflake implementation experience.
• 2+ years of migration experience from Talend and/or Informatica to Snowflake.
• Strong command of SQL, data modeling, ELT pipeline design, and performance tuning.
• Practical knowledge of modern orchestration tools (e.g., Airflow, DBT Cloud, Snowflake Tasks).
• Familiarity with legacy metadata parsing, parameterized job execution, and parallel processing logic in ETL tools.
• Good knowledge of cloud data security, data governance, and compliance standards.
• Strong written and verbal communication skills; capable of explaining technical concepts to CXOs or developers alike.

Bonus / Preferred

• Snowflake certifications: SnowPro Advanced Architect, SnowPro Core.
• Experience building custom migration tools or accelerators.
• Hands-on with LLM-assisted code conversion tools.
• Experience in key verticals like retail, healthcare, or manufacturing.

Why Join This Team?

• Opportunity to be part of a founding core team defining modernization standards.
• Exposure to cutting-edge Snowflake features and migration accelerators.
• High-impact role with visibility across sales, delivery, and leadership.
• Career acceleration through complex problem-solving and ownership.