Senior Data Engineer-Snowflake+DBT

Tiger Analytics; Chennai District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tiger Analytics seeks an experienced data engineering leader to design and deliver end-to-end Snowflake-based data solutions. You will translate business needs into scalable architectures, drive data strategy, and work with cross-functional teams to ensure secure, compliant data pipelines.

Ideal candidates have strong Snowflake capabilities, experience migrating from on-prem to cloud, and proficiency in Python/PySpark, SQL, and data modeling.

Qualifications

• 6-15 years of relevant experience.
• Work from Chennai office all 5 days a week to handle sensitive data.
• Experience in Snowpro/Python/PySpark.
• Migration projects: On-prem to Snowflake.
• Snowflake capabilities (Snow pipe, SnowSQL, Streams, architecture).
• Data migration from RDBMS to Snowflake cloud data warehouse.
• Incremental extraction loads - batched and streaming.
• Experience with Azure, AWS, or GCP.
• Architect data architecture solutions aligned with tech roadmap.
• Strong Data Modeling, Data Access Patterns, and SQL.
• Cost Management, Infrastructure Planning & Disaster Recovery.
• Data Governance and DevOps practices.
• Data Virtualization understanding.
• Big Data Platform experience.
• Cross-functional collaboration.
• Excellent communication skills.

Responsibilities

• Collaborate with clients to understand requirements.
• Create an extensible architecture to meet requirements.
• Translate business requirements into technical artifacts.
• Identify the right technology stack and tools.
• Design end-to-end data strategy including standards and security policies.
• Collaborate with data engineers and scientists to execute the data strategy.
• Perform data analysis to understand datasets.
• Design and develop data models for requirements.
• Identify and implement the right orchestration tool.
• Define data distribution patterns for downstream systems.
• Perform code reviews to ensure quality deliverables.
• Work with DevOps to establish CI/CD processes.
• Own end-to-end delivery of the project.
• Engage with clients during UAT and resolve issues.
• Identify bottlenecks and propose corrective actions.
• Design reusable frameworks.
• Prioritize work with project managers to meet milestones.
• Monitor progress and report milestones and impediments.
• Mentor team members and create technical artifacts.
• Demonstrate thought leadership.

Skills

Snowflake

Python

PySpark

SQL

Data Modeling

Data Architecture

Cloud Platforms

Data Governance

DevOps

Data Migration

Security & Access

Architecture Design

Tools

Snowpipe

SnowSQL

Streams

Job description

Role & responsibilities

On a typical day, you might

• Collaborate with the clients to understand the overall requirements
• Create a robust, extensible architecture to meet the client/business requirements
• Translate the Business requirements into technical artifacts
• Identify the right technology stack and tools that best meet the client requirements
• Design end to end solutions along with data strategy, including standards, principles, data sources, storage, pipelines, data flow, and data security policies
• Collaborate with data engineers, data scientists, and other stakeholders to execute the data strategy
• Perform data analysis to understand the relevant data sets
• Design and create Data Models to cater to all the requirements
• Identify and implement the right orchestration tool
• Define the right security and access policies
• Implement the Snowflake best practices
• Define the right data distribution/consumption pattern for downstream systems and consumers
• Perform the code reviews and ensure quality deliverables
• Work with DevOps team to define and establish CI/CD process
• Own end-to-end delivery of the project
• Work closely with the clients during UAT Testing and ensure all client issues/concerns are addressed
• Proactively identify the performance bottlenecks and propose corrective actions
• Design and Develop reusable frameworks
• Work with the Project Managers to prioritize work for each sprint to meet project milestones and deadlines
• Closely monitor the Project progress and provide regular updates to the leadership teams on the milestones, impediments etc
• Guide /mentor team members, and create the technical artifacts
• Demonstrate thought leadership.

Preferred candidate profile

• 6-15 years of relevant experience.
• Work from our Chennai (white space) office all 5 days a week to handle sensitive data
• Experience in Snowpro/ Python/ Pyspark
• Decent experience in migration projects, migrating from On-prem to Snowflake
• Comprehensive knowledge of the Snowflake capabilities such as Snow pipe, SnowSQL, Streams, and Snowflake architecture and awareness of Snowflake roles and user security.
• In-depth knowledge and experience in data migration from RDBMS to Snowflake cloud data warehouse
• Well-versed with Incremental extraction loads - batched and streaming
• Experience with Azure, AWS, or GCP
• Ability to architect data architecture solutions that are in alignment with the strategic technology roadmap and emerging industry trends
• Strong exposure to Data Modelling, Data Access Patterns, and SQL
• Knowledge of Cost Management, Infrastructure Planning & Disaster Recovery
• Good experience in Data Governance and a good understanding of DevOps practices
• Understanding of Data Virtualization
• Experience in working in Big Data Platform
• Ability to work closely with cross-functional teams
• Excellent communication (verbal and written) and excellent interpersonal skills