Xebia is a global consulting company with over 20 years of experience in delivering cutting-edge technology solutions. They are seeking a results-driven Data Engineer/Senior Data Engineer with expertise in Snowflake and modern data architecture to build high-performance data pipelines and manage data quality across multiple environments.
Responsibilities:
- Design, build, and maintain end-to-end data pipelines leveraging Snowflake and Amazon S3 for ingestion, transformation, and storage
- Develop and enforce data quality frameworks (validation, anomaly detection, alerts) across ingestion and transformation layers
- Set up and manage multiple Snowflake environments (Dev, Test, QA, Prod) with proper environment isolation, RBAC, and CI/CD practices
- Lead and execute data migration initiatives from legacy/on-prem databases to Snowflake
- Optimize Snowflake performance via clustering, materialized views, query profiling, and result caching
- Develop and manage Snowflake Streams, Tasks, External Tables, File Formats, Stages, and Pipes for near real-time and batch processing
- Implement Snowflake Snowpipe for continuous and automated data ingestion from S3
- Manage and optimize virtual warehouses for performance and cost efficiency
- Build reusable dbt models, implement modular transformations, and integrate into orchestration tools like Airflow or Dagster
- Integrate Snowflake with BI tools and downstream applications securely using OAuth/JWT, Service Accounts, and External Functions
- Apply data governance practices, including row-level security, column masking, and tag-based access control
Requirements:
- 4+ years of experience in data engineering with at least 2+ years focused on Snowflake
- Strong command of SQL (ANSI, Snowflake SQL dialect) and Python for scripting and transformation
- Expertise in managing Snowflake features such as: Warehouses, Databases, Schemas, Roles
- Snowpipe, Streams & Tasks, External Tables
- Data Sharing, Secure Views, Clustering Keys
- Experience with Snowflake Connector for Python, Snowflake REST API, and Snowflake's Native Apps or UDFs
- Proficiency with CI/CD pipelines for Snowflake using tools like GitHub Actions
- Certified SnowPro Core and/or SnowPro Advanced: Data Engineer
- Experience working with semi-structured data (JSON, Avro, Parquet) in Snowflake
- Knowledge of data privacy & governance (e.g., PII handling, GDPR, HIPAA)