Key Responsibilities Data Pipeline Development Design, develop, and maintain efficient, reliable, and reusable ETL/ELT pipelines using DBT, Snowflake Data Modeling

Build and optimize data models (star, snowflake schemas) to support analytical and reporting use cases, ensuring data quality, accuracy, and performance.

Performance Optimization

Tune SQL queries, manage compute resources, and optimize Snowflake performance for scalability and cost efficiency.

Implement data validation, testing, and monitoring processes to ensure high data quality and consistency across environments.

Collaboration

Partner with data analysts, data scientists, and business teams to understand requirements, define transformations, and deliver high-quality datasets.

Maintain version control and deployment best practices using Git, CI/CD pipelines, and DBT Cloud (or similar).

Documentation

Maintain explicit,



comprehensive documentation for pipelines, data models, and workflows.

Required Skills & Qualifications

Education

Bachelor’s degree in computer science, Information Technology, Engineering, or related field.

Experience

0–6 months in data engineering.

Technical Expertise

Strong SQL skills and experience in building complex transformations. Proficiency in Snowflake architecture (warehouses, micro-partitioning, clustering, query optimization, etc.).

understanding of DBT (models, macros, testing, documentation, version control).

Understanding of cloud platforms and services like S3, role, SQS on AWS Understanding of data warehousing concepts and data lake architectures. Familiarity with BI tools such as Power BI, or Tableau

📌 Associate (Chennai)
🏢 Virtusa
📍 Chennai