Build and optimize ETL/ELT pipelines for loading and transforming large datasets.
Develop and maintain data models, schemas, and database objects.
Implement data integration processes from multiple on-premises and cloud sources.
Optimize Snowflake performance through query tuning, clustering, partitioning, and warehouse management.
Develop data transformation logic using SQL, Snowflake Stored Procedures, and Snowpark.
Collaborate with Data Engineers, Analysts, and Business Teams to understand data requirements.
Monitor, troubleshoot, and resolve data-related issues.
Ensure data quality, governance, security, and compliance standards are maintained.
Support production deployments and perform root cause analysis for data issues.
Automate data workflows and orchestration processes.
Contribute to data architecture and best practice initiatives.
Required Skills & Qualifications Snowflake
Strong hands-on experience with Snowflake Data Cloud.
Expertise in Snowflake Architecture, Virtual Warehouses, Databases, Schemas, and Stages.
Experience with Snowflake Features such as
Snowpipe
Streams & Tasks
Time Travel
Zero Copy Cloning
Secure Data Sharing
Materialized Views
Snowpark
SQL & Data Warehousing
Strong proficiency in SQL and query optimization.
Experience designing and implementing Data Warehouse solutions.
Strong knowledge of Data Modeling concepts
Star Schema
Snowflake Schema
Dimension Modeling
Fact Tables
ETL/ELT Development
Experience building ETL/ELT pipelines.
Hands-on experience with data ingestion and transformation frameworks.
Experience handling structured and semi-structured data (JSON, XML, Parquet, Avro).
Cloud Platforms
Experience working with one or more cloud platforms
AWS
Azure
Google Cloud Platform (GCP)
Programming
Experience with Python or Java for data processing and automation.
Familiarity with Snowpark development using Python or Java.
Data Integration Tools
Experience with one or more of the following
Informatica
Matillion
Talend
Azure Data Factory (ADF)
Airflow
dbt
Preferred Qualifications
Bachelor's degree in Computer Science, Information Technology, or related field.
4+ years of experience in Data Engineering.
2+ years of hands-on Snowflake development experience.
Experience working in Agile/Scrum environments.
Knowledge of CI/CD practices and DevOps methodologies.
Nice to Have
Snowflake Certification.
Experience with Databricks.
Apache Spark.
Kafka/Event Streaming.
Data Lake Architecture.
Terraform or Infrastructure as Code (IaC).
Machine Learning data preparation workloads.
Key Competencies
Strong Analytical and Problem-Solving Skills
Data Modeling Expertise
Database Performance Tuning
Stakeholder Communication
Attention to Detail
Collaboration and Teamwork
Agile Mindset
Experience
4 to 8 Years
Employment Type
Full-Time
Mandatory Skills
Snowflake
SQL
Data Warehousing
ETL/ELT Development
Cloud Platform (AWS/Azure/GCP)
Data Modeling
Performance Optimization
Good to Have
Python
Snowpark
dbt
Airflow
Databricks
CI/CD Pipeline Experience
Compensation, Benefits and Duration
Minimum Compensation: USD 37,000
Maximum Compensation: USD 132,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is not available for independent contractors
No applications will be considered if received more than 120 days after the date of this post
