Senior Engineer

Job Description

Snowflake dbt Engineer

Must Have Technical/Functional Skills

Mandatory Technical skills - Snowflake, dbt, SQL, Python, Data Engineering, Data Modeling

• 5+ years of overall Data Engineering experience.
• 3+ years of hands-on Snowflake development experience in production environments.
• 2+ years of hands-on dbt Core or dbt Cloud development experience.
• Strong hands-on experience with Advanced SQL, ELT/ETL pipelines, data modeling, performance tuning, and production support.
• Recent coding and development experience is mandatory. Profiles that are mainly architecture-focused should not be considered.

Roles & Responsibilities

• Design, develop, test, deploy, and support ELT pipelines using Snowflake and dbt.
• Build dbt models across staging, intermediate, and mart layers using reusable and maintainable development standards.
• Create and manage dbt incremental models, snapshots, tests, documentation, sources, seeds, macros, and packages.
• Develop Snowflake objects including databases, schemas, tables, views, secure views, streams, tasks, and Snowpipe pipelines.
• Write and optimize complex SQL queries, stored procedures, and transformation logic.
• Perform source-to-target mapping and implement transformation rules based on business and technical requirements.
• Build dimensional data models, data marts, facts, dimensions, and analytics-ready datasets.
• Implement data quality checks, reconciliation controls, exception handling, and monitoring mechanisms.
• Troubleshoot production data issues, pipeline failures, performance bottlenecks, and data discrepancies.
• Optimize Snowflake warehouse usage, query performance, clustering, and cost efficiency.
• Work with business analysts, data architects, application teams, and reporting teams to deliver trusted data products.
• Support CI/CD and DataOps practices for Snowflake and dbt deployments Education: Bachelor’s degree

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Fin ancial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $100000 - 120000 a year

Qualifications: BACHELOR OF COMPUTER SCIENCE