Data Engineer – Snowflake, DBT & AWS

Code1 Tech Systems; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Code1 Tech Systems in Bengaluru, India, is seeking a skilled Data Engineer to design, build, and optimize scalable data solutions. You will develop robust data pipelines, modernize legacy warehouses, and deliver analytics-ready data for BI reporting.

The role emphasizes Snowflake, dbt, and cloud integrations with AWS, focusing on governance, lineage, and quality checks for enterprise data assets.

Qualifications

• Strong hands-on Snowflake experience in enterprise environments.
• Deep SQL knowledge, query optimization, and warehouse design.
• Experience migrating from legacy EDW platforms (SQL Server, SSIS, SSAS).
• Familiarity with dbt, Fivetran, AWS, and BI/reporting integrations.

Responsibilities

• Design, configure, and maintain Snowflake databases, schemas, warehouses, roles, and security across environments.
• Implement cloud-based ingestion using Fivetran for legacy, operational, and SaaS sources.
• Build and optimize target data architecture across raw, staging, curated, and reporting layers.
• Develop, test, and maintain dbt models to replace legacy ETL logic for curated data assets.
• Translate legacy constructs like SCD Type 2 into modern Snowflake/dbt implementations.
• Configure AWS integrations including S3 stages, IAM roles, and storage integrations.
• Document field-level lineage, metadata, and schema evolution across layers.
• Implement automated data quality, freshness checks, and reconciliation controls.
• Monitor pipelines and Snowflake workloads; troubleshoot issues and performance.

Skills

Snowflake

SQL

dbt

Fivetran

AWS basics

Data modeling

CDC concepts

Performance tuning

Tools

Snowflake

dbt

Fivetran

S3/IAM

Job description

We Are

At Code1 Tech, we drive innovations that shape the future of enterprise technology. Our expertise spans Data Engineering, AI/ML, Cloud Solutions, and Full-Stack Development. We empower businesses with cutting‑edge technology solutions, enabling digital transformation at scale. Join us to build impactful products with a passionate team of engineers and innovators.

About The Role

We are seeking a highly skilled Data Engineer with strong expertise in Snowflake, DBT, AWS, and modern cloud data platforms to design, build, and optimize scalable data solutions. In this role, you will be responsible for developing robust data pipelines, modernizing legacy data warehouse environments, and delivering high‑quality, analytics‑ready data for enterprise reporting and business intelligence.

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 modern 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 Git‑based engineering workflows for dbt, Snowflake, and data pipeline changes.
• Produce operational documentation, configuration standards, runbooks, and handover materials for ongoing support and client operations teams.
• Work closely with architects, analysts, reporting teams, and client stakeholders to ensure the solution improves automation, reduces manual dependency, and supports a more scalable operating model.

Required Skills and Experience:

• Strong hands‑on experience implementing Snowflake in enterprise environments.
• Deep knowledge of SQL, query optimization, performance tuning, and warehouse design.
• Experience migrating from legacy EDW platforms such as SQL Server, SSIS, and SSAS.
• Familiarity with dbt, Fivetran, AWS, and BI/reporting integrations.
• Hands‑on experience with Fivetran or comparable cloud ingestion tools.
• Strong AWS fundamentals: S3, IAM, KMS, VPC, PrivateLink for Snowflake connectivity
• Strong understanding of source‑to‑target mapping, CDC concepts, and incremental loading.
• Experience working with Snowflake and cloud‑based data platforms.
• Ability to write SQL for data validation and reconciliation between source and Bronze landing tables

Nice To Have:

• Snowflake SnowPro Core or Advanced: Data Engineer certification
• Experience with Snowflake cost optimization on large‑scale financial data workloads
• Familiarity with dbt project structure and Snowflake‑specific dbt materializations (dynamic tables)

Ready to make an impact?