Data Engineer

Shift: 2 pm 11 pm

Key Responsibilities
Design, configure, and maintain the Snowflake platform, including databases, schemas, warehouses, roles, security policies, and workplace 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