Sr. Data Engineer (Snowpark, Python, SQL, Azure)- No H1B or C2C

TechLink Resources, Inc; Los Angeles (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

A technology consulting firm is seeking a Senior Data Engineer in Los Angeles to build and modernize enterprise data pipelines. You will migrate pipelines from Azure Data Factory to Snowflake while implementing scalable data solutions and using AI tools for optimal coding practices. The ideal candidate has strong experience in Python and SQL, with a proven track record in Snowflake and data engineering. Join us to work on cutting-edge cloud transformations in an Agile environment.

Qualifications

• 3–5+ years in Data Engineering / Data Integration.
• Advanced experience with Python and SQL.
• Strong experience with Snowflake.

Responsibilities

• Build, refactor, and maintain scalable data pipelines.
• Migrate existing ADF pipelines into Snowflake solutions.
• Design and implement data transformations for reporting.

Skills

Python

SQL

Data Engineering

Data Integration

Snowflake

Azure Data Factory

Agile/Scrum

AI coding tools

Job description

About the Role

We’re looking for a Senior Data Engineer to help build and modernize enterprise data pipelines in a cloud-based environment. This role is highly hands‑on and focused on execution and delivery, working closely with architects and team leads to implement scalable data solutions.

You’ll play a key role in migrating existing data pipelines from Azure Data Factory into Snowflake (Snowpark) while leveraging modern AI‑assisted development tools (like Cursor and Copilot) to improve speed, quality, and efficiency.

What You’ll Be Doing

• Build, refactor, and maintain scalable data pipelines for enterprise data systems
• Migrate existing ADF pipelines into Snowflake Snowpark solutions
• Design and implement data transformations for reporting, analytics, and KPIs
• Work heavily with Snowflake (SQL + Snowpark) for data processing and storage
• Develop and optimize Python‑based data workflows
• Integrate data from multiple sources and ensure high data quality
• Collaborate with engineering leadership to execute on defined requirements
• Leverage AI tools (Cursor, Copilot, etc.) for coding, debugging, and optimization
• Ensure solutions meet performance, security, and data governance standards

What We are Looking For

• Strong hands‑on coder (not just design/architecture)
• Deep experience with Python + SQL for data engineering
• Proven experience working with Snowflake in production
• Experience with Azure Data Factory and translating pipelines into code
• Someone who has done cloud data migrations (Azure → Snowflake preferred)
• Comfortable working in Agile/Scrum environments
• Familiar with using AI coding tools to move faster and write better code

Basic Qualifications

• 3–5+ years in Data Engineering / Data Integration
• Advanced experience with Python and SQL (complex transformations + tuning)
• Strong experience with Snowflake
• Experience with Azure Data Factory (ADF)
• Experience working in Agile teams

Nice to Have

• Experience with Snowflake Snowpark, Tasks, and Streams
• Exposure to AWS or Azure cloud environments
• Experience with CI/CD pipelines for data engineering
• Background in large‑scale data migration projects

Why This Role Stands Out

• Exposure to cutting‑edge AI‑assisted development practices
• Strong engineering culture focused on delivery and quality
• Opportunity to work on large‑scale cloud data transformations