Snowflake ETL Engineer

MACHINE LEARNING TECHNOLOGIES LLC; Dallas (TX); On-site; USD 8,266,000 - 12,398,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in Dallas, TX seeks a Snowflake ETL Engineer to design and optimize data pipelines and Snowflake environments for scalable analytics.

You will manage ETL/ELT workflows (DBT/ADF), tune performance, ensure security/compliance, and collaborate with cross-functional teams.

This 24-month+ extension role offers an hourly DOE rate and requires strong SQL, cloud experience (Azure/AWS).

Qualifications

• Bachelor's in CS or related field.
• 3+5 years DBA/Data Engineering experience; 2+ years Snowflake.
• Strong SQL, performance tuning, data modeling.
• Experience with cloud platforms (Azure/AWS) and ETL tools (DBT, ADF).
• Preferred: SnowPro certification, scripting (Python), CI/CD (Terraform), BI tools (Tableau, Power BI).

Responsibilities

• Administration: Manage Snowflake databases, schemas, roles, and warehouses; optimize compute resources; monitor performance; automate tasks using SQL/Python; enforce security policies.
• Data Integration: Support ETL/ELT pipelines (DBT/ADF), data ingestion from cloud/APIs/databases, and efficient transformation strategies.
• Performance Tuning: Optimize queries, implement clustering/partitioning, and manage warehouse sizing for cost/performance balance.
• Security & Compliance: Ensure encryption, masking, backups, disaster recovery, and compliance with standards.
• Collaboration: Partner with engineers/analysts, troubleshoot issues, provide best practices, and stay current with Snowflake updates.

Skills

SQL

Performance tuning

Data modeling

Education

Bachelor's in CS or related field

Tools

Snowflake

DBT

ADF

Azure

AWS

Terraform

Tableau

Power BI

Job description

Job Description

• Job ID: J52698
• Job Title: Snowflake ETL Engineer
• Location: Dallas, TX
• Duration: 24 Months + Extension
• Hourly Rate: Depending on Experience (DOE)
• Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD
• Client: To Be Discussed Later
• Employment Type: W-2, 1099, C2C

Key Responsibilities

• Administration: Manage Snowflake databases, schemas, roles, and warehouses; optimize compute resources; monitor performance; automate tasks using SQL/Python; enforce security policies.
• Data Integration: Support ETL/ELT pipelines (DBT/ADF), data ingestion from cloud/APIs/databases, and efficient transformation strategies.
• Performance Tuning: Optimize queries, implement clustering/partitioning, and manage warehouse sizing for cost/performance balance.
• Security & Compliance: Ensure encryption, masking, backups, disaster recovery, and compliance with standards.
• Collaboration: Partner with engineers/analysts, troubleshoot issues, provide best practices, and stay current with Snowflake updates.

Requirements

• Bachelor's in CS or related field
• 3 5+ years DBA/Data Engineering experience; 2+ years Snowflake
• Strong SQL, performance tuning, data modeling
• Experience with cloud platforms (Azure/AWS) and ETL tools (DBT, ADF)

Preferred: SnowPro certification, scripting (Python), CI/CD (Terraform), BI tools (Tableau, Power BI).

MACHINE LEARNING TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. MACHINE LEARNING TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will MACHINE LEARNING TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract