Haystack
← Back to Jobs
Technology
MU

ETL/Snowflake Architect -St. Louis, MO (on-site)- Only Locals

Momento USA LLCSt. Louis, MO🇺🇸United StatesPosted 15 Sept 2026

Why This Role Stands Out

This long-term contract role offers a fantastic opportunity to architect and implement cutting-edge ETL/ELT pipelines using PySpark and Databricks, while leveraging Terraform for infrastructure as code. You'll thrive here if you are a seasoned ETL/Snowflake Architect with a passion for optimizing performance, ensuring data quality, and building robust cloud solutions. Apply today to make a significant impact in a dynamic on-site role!

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
St. Louis, MO, United States
Posted
Yesterday
SQLAWSETLSnowflakeAgileAzureComplianceDatabricksEMRJenkinsPythonSchedulingTerraformUnityVault

Job Description

ETL/Snowflake Architect  
Location: St. Louis, MO (on-site)- Only Locals
Long-term contract
 
Key Responsibilities
 
• Design, develop, and maintain ETL/ELT pipelines using PySpark and Python in Databricks (including notebooks, jobs, Delta Lake tables, and Unity Catalog for governance).
• Implement medallion architecture (bronze/silver/gold layers) and optimize Spark jobs for performance, cost, scalability, and reliability (handling partitioning, skew, caching, adaptive query execution, etc.).
• Write efficient SQL queries for data transformation, validation, and analytics within Databricks.
• Provision and manage cloud infrastructure using Terraform (IaC) for Databricks workspaces, clusters, jobs, storage (ADLS/S3), networking, IAM roles/permissions, and related resources on Azure and/or AWS.
• Implement and maintain CI/CD pipelines using Jenkins, GitHub (Actions/Repositories), and branching strategies for automated testing, deployment of notebooks, jobs, Delta Live Tables, and Terraform configurations.
• Integrate data from diverse sources (databases, APIs, streaming, files) into cloud storage and processing layers.
• Ensure data quality, lineage, security, and compliance (including Delta Lake ACID transactions, schema evolution, time travel, and access controls).
• Monitor pipeline performance, troubleshoot failures, and implement alerting/observability (using Databricks tools, cloud monitoring services, or third-party solutions).
• Optimize cloud costs through auto-scaling clusters, spot instances, job scheduling, and efficient resource usage.
• Collaborate in agile teams, participate in code reviews, and contribute to best practices for data engineering.
 
Required Skills & Experience
 
• Strong proficiency in Python and PySpark for distributed data processing and ETL.
• Advanced SQL skills with experience in complex querying, window functions, and optimization.
• Hands-on experience with Databricks (clusters, notebooks, Delta Lake, Unity Catalog, Delta Live Tables, workflows/jobs).
• Proficiency in Terraform for infrastructure provisioning and management (Databricks resources, cloud storage, IAM, networking).
• Experience with GitHub for version control and collaboration (branching, pull requests, code reviews).
• Solid knowledge of CI/CD practices and tools, particularly Jenkins (pipelines, plugins for Databricks/GitHub/Terraform).
• Working experience on Azure (Data Lake, Data Factory, Synapse, Key Vault, etc.) and/or AWS (S3, Glue, EMR, IAM, Lambda, etc.).
• Understanding of big data concepts, data modeling (star/snowflake, dimensional), and lakehouse principles.
• Familiarity with performance tuning in Spark/Databricks environments.

Regards
Naveen Sagar

 

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Similar jobs

Browse related jobs

Apply now