The Role
Designs and optimizes Snowflake-based data pipelines, warehouses, and ETL/ELT workflows. Develops complex SQL, Python, and PySpark transformations; integrates cloud, database, and API data sources; implements data modeling, quality checks, monitoring, security, governance, and access controls. Collaborates with architects, analysts, and stakeholders while optimizing query performance, warehouse utilization, and cloud compute costs.
Summary Generated by Built In
Key Responsibilities
- Design, develop, and optimize data pipelines using Snowflake and ETL/ELT frameworks.
- Write complex SQL queries, stored procedures, and performance-optimized transformations.
- Build and maintain scalable data ingestion and transformation workflows.
- Implement data warehouse solutions, data modeling, and data integration processes.
- Work with Python and PySpark for data processing and transformation.
- Optimize Snowflake query performance, warehouse utilization, and compute costs.
- Integrate data from multiple sources, including cloud storage, databases, and APIs.
- Implement data quality checks, error handling, and monitoring.
- Collaborate with data architects, analysts, and business stakeholders.
- Follow best practices for data security, governance, and access management.
- Snowflake: Hands-on experience with Snowflake data warehouse, SQL, and query optimization.
- SQL: Strong experience writing complex queries, joins, CTEs, window functions, and performance tuning.
- ETL/ELT: Experience developing and maintaining data pipelines.
- Python: Data processing, transformation, and automation.
- Data Modeling: Experience with dimensional modeling, schema design, and data warehouse concepts.
- Cloud Data Platforms: Experience with AWS, Azure, or GCP.
- PySpark / Apache Spark
- Databricks and Delta Lake
- Apache Airflow or other workflow orchestration tools
- Snowflake Streams, Tasks, Snowpipe, and Dynamic Tables
- Snowflake performance tuning and cost optimization
- CI/CD, Git, and automated testing
- Cloud storage and data lake integration
Skills Required
- Hands-on experience with Snowflake, SQL, and query optimization
- Strong experience writing complex SQL queries, joins, CTEs, window functions, and performance tuning
- Experience developing and maintaining ETL/ELT data pipelines
- Python experience for data processing, transformation, and automation
- Experience with dimensional modeling, schema design, and data warehouse concepts
- Experience with AWS, Azure, or GCP
- Experience with PySpark or Apache Spark
- Experience with Databricks and Delta Lake
- Experience with Apache Airflow or other workflow orchestration tools
- Experience with Snowflake Streams, Tasks, Snowpipe, and Dynamic Tables
- Snowflake performance tuning and cost optimization experience
- Experience with CI/CD, Git, and automated testing
- Cloud storage and data lake integration experience
eClerx LLC Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about eClerx LLC and has not been reviewed or approved by eClerx LLC.
-
Healthcare Strength — Feedback suggests U.S. employees have access to medical, dental, and vision coverage, with HSA/FSA options and life insurance included. An Employee Assistance Program also appears in the public benefits profile supporting wellbeing.
-
Retirement Support — Feedback suggests a 401(k) is part of the U.S. package, with some mentions of an employer match. Retirement provision is consistently cited across company profiles and listings.
-
Leave & Time Off Breadth — Feedback suggests paid holidays, sick leave, and PTO are part of the offering, alongside parental leave. Parental leave is also highlighted in public benefits profiles.
eClerx LLC Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
eClerx provides business process management, automation and analytics services to a number of Fortune 2000 enterprises, including some of the world's leading financial services, communications, retail, fashion, media & entertainment, manufacturing, travel & leisure, and technology companies. Incorporated in 2000, eClerx is today traded on both the Bombay and National Stock Exchanges of India. The firm employs 16,000+ people across Australia, Canada, Germany, India, Italy, Netherlands, Philippines, Singapore, Thailand, UK, and the USA.
