Data Engineer

Shift: 2 pm 11 pm

Key Responsibilities
- Design, configure, and maintain the Snowflake platform, including databases, schemas, warehouses, roles, security policies, and environment setup across development, test, and production.
- Implement and manage cloud-based ingestion using Fivetran for legacy, operational, and SaaS source systems, including full-load, incremental, and CDC-based patterns.
- Build and optimize the target data architecture across raw, staging, curated, and reporting-ready layers, aligned to medallion-style or equivalent modular design patterns.
- Develop, test, and maintain dbt models that replace legacy SSIS transformation logic and support curated business-ready data assets for reporting, reconciliation, and analytics.
- Translate legacy constructs such as SCD Type 2 handling, lookup logic, conditional branching, and other ETL patterns into contemporary Snowflake and dbt implementations.
- Configure AWS integrations required for the data platform, including S3 stages, IAM roles, storage integrations, encryption support,



and secure connectivity patterns.
- Establish and support source-to-target mappings, metadata consistency, schema evolution handling, and documentation of field-level lineage across ingestion and transformation layers.
- Implement automated data quality checks, freshness checks, reconciliation controls, and exception handling to improve trust in the data before it reaches reporting layers.
- Monitor ingestion pipelines, connector health, transformation runs, and Snowflake workloads; troubleshoot failures, schema drift, performance issues, and data incidents.
- Optimize Snowflake cost and performance through workload isolation, warehouse sizing, clustering, query tuning, and platform monitoring.
- Support downstream analytics and reporting teams by delivering trusted, well-documented, analytics-ready data structures compatible with Sigma and other governed reporting tools.
- Contribute to CI/CD, release automation, and

📌 Data Engineer (Delhi)
🏢 Xebia IT Architects
📍 Delhi