[Remote] Senior Snowflake Data Engineer Modern Data Platforms & AI Exposure

Note: The job is a remote job and is open to candidates in USA. Dice is seeking a highly skilled and motivated Senior Snowflake Data Engineer with 8-10 years of experience in designing, developing, and maintaining modern enterprise data platforms and scalable data solutions. The ideal candidate will possess strong expertise in data warehousing, ETL/ELT processes, cloud data engineering, and Snowflake ecosystem technologies, along with foundational exposure to modern AI and AI-enabled data platform concepts.

Responsibilities

• Design, develop, and maintain scalable enterprise data pipelines and modern cloud-based data platforms
• Build robust ETL/ELT workflows for ingesting and transforming data from APIs, databases, flat files, and streaming sources
• Develop and optimize Snowflake-based solutions including stored procedures, tasks, streams, dynamic tables, Snowpark, and performance tuning
• Implement enterprise-scale transformation frameworks using dbt Core and dbt Cloud
• Work with ETL/ELT tools such as Matillion, Informatica, and Openflow (nice to have)
• Design and maintain scalable and maintainable data models supporting business intelligence, analytics, and operational reporting
• Develop API-based integrations and data services for enterprise applications and downstream systems
• Ensure data quality, governance, scalability, observability, operational reliability, and cost optimization across the data platform
• Proactively monitor, troubleshoot, and resolve data pipeline and platform issues in production environments
• Collaborate with cross-functional teams including architects, analysts, business stakeholders, and AI/data science teams to deliver enterprise data solutions
• Participate in architecture discussions and contribute to modern data engineering best practices and standards
• Support AI/LLM-enabled initiatives by enabling structured, scalable, and vector-ready data pipelines
• Drive technical ownership of data pipelines and platform reliability across development, deployment, and production support activities

Skills

• 8 10 years of experience in Data Engineering, Data Warehousing, or related roles
• Strong understanding of enterprise data warehousing concepts, dimensional modeling, and scalable data architecture
• Deep understanding and strong hands-on experience with Snowflake architecture, performance optimization, data modeling, security, cost optimization, Snowpark, stored procedures, streams/tasks, dynamic tables, and enterprise-scale data platform implementation
• Strong expertise in SQL and Python programming
• Deep understanding and strong hands-on experience with dbt Core and dbt Cloud including modular transformations, incremental models, testing, documentation, lineage, dependency management, performance optimization, and enterprise-scale ELT best practices
• Hands-on experience with ETL/ELT tools: Matillion, Informatica
• Openflow exposure
• Azure cloud understanding
• AWS concepts understanding
• Snowflake Cortex / Snowflake Intelligence exposure
• AI / LLM / chatbot / RAG / MCP / Agent concepts exposure

Company Overview