تخطي إلى المحتوى

Senior Analyst

Overview
eClerxeclerx.comPosted 2 weeks ago
Pune, Maharashtra, INمن مقر العمل
Quick apply
مستوى الخبرة
Senior
نوع الوظيفة
دوام كامل
التخصص
Data & AI

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.

Requirements

  1. Snowflake: Hands-on experience with Snowflake data warehouse, SQL, and query optimization.
  2. SQL: Strong experience writing complex queries, joins, CTEs, window functions, and performance tuning.
  3. ETL/ELT: Experience developing and maintaining data pipelines.
  4. Python: Data processing, transformation, and automation.
  5. Data Modeling: Experience with dimensional modeling, schema design, and data warehouse concepts.
  6. 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

Key skills

  • Snowflake
  • ETL
  • SQL
  • Data Warehousing
  • Data Modeling
  • Python
  • Apache Spark
  • AWS
  • Azure
  • Google Cloud
  • Databricks
  • Airflow
  • CI/CD
  • Git
  • Test Automation