Remote Snowflake Data Engineer | SQL & AI-Driven Pipelines

Carmatec; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Remote work

Competitive compensation

Job summary

Carmatec seeks a data engineer to design and optimize Snowflake data models, pipelines, and analytics for a remote engagement lasting at least six months. You will apply advanced SQL, performance tuning, and AI-assisted tooling to deliver scalable data solutions for business and client use cases.

Collaborate with internal teams and clients to translate business rules into robust data architectures, monitor warehouse performance, and optimize query efficiency using Snowflake, Alteryx, and Power

Qualifications

• Four years of data engineering experience including data warehousing, schema design, and enterprise pipelines.
• Advanced knowledge of Snowflake architecture, stored procedures, views, functions, and performance optimization.
• Strong SQL skills with ability to write, debug, and tune analytical queries and database scripts.
• Hands-on experience using generative AI platforms to support development or process automation.
• Excellent written and spoken English for remote, client-facing collaboration.

Responsibilities

• Design and optimize Snowflake data models, database objects, and pipeline workflows.
• Write, debug, and tune complex SQL queries, views, stored procedures, and custom functions.
• Use generative AI tools to assist with code improvements, query refactoring, script creation, and workflow automation.
• Monitor virtual warehouse performance and improve query execution and micro-partition efficiency.
• Translate business rules into data solutions in collaboration with clients and internal stakeholders.

Skills

SQL

Data engineering

English communication

Tools

Snowflake

Alteryx

Power BI

Generative AI platforms

Job description

Carmatec seeks a data engineer to design and optimize Snowflake data models, pipelines, and analytics for a remote engagement lasting at least six months. You will apply advanced SQL, performance tuning, and AI-assisted tooling to deliver scalable data solutions for business and client use cases.

Collaborate with internal teams and clients to translate business rules into robust data architectures, monitor warehouse performance, and optimize query efficiency using Snowflake, Alteryx, and Power