Job Description

About Persistent

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

Our disruptor’s mindset, commitment to client success, and agility to thrive in the dynamic setting have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We reported $1,654.4M FY26 revenue with 17.4% Y-o-Y growth. We have delivered 24 sequential quarters of growth with $436.0M in Q4 FY26 revenue, up 3.2% Q-o-Q and 16.2% Y-o-Y growth. Our 27,500+ global team members, located in 18 countries, have been instrumental in helping the market leaders transform their industries. We have been recognized as the Fastest Growing IT Services Brand Globally in the 2026 Brand Finance IT Services 25 Report. We named a Leader in the Everest Group Private Equity (PE) Services PEAK Matrix® Assessment 2026 and Software Product Engineering PEAK Matrix® Assessment 2026.

About Position:

We are looking for a Senior Engineering Lead with strong expertise in Snowflake, dbt, and Data Warehousing to lead the design, development, and optimization of scalable data platforms. The ideal candidate will be responsible for building robust ELT pipelines, implementing data transformation frameworks, ensuring data quality, and driving best practices across modern cloud-based analytics ecosystems. This role requires a strong blend of technical leadership, hands-on development, and collaboration with cross-functional teams to deliver high-quality data solutions.

-
Role: Senior Engineering Lead
- Location: Any PSL Location
- Experience: Between 5 to 8 Years
- Job Type: Full Time Employment

What You'll Do:

- Design, build, and maintain scalable data models and transformation pipelines using dbt (Data Build Tool) on Snowflake.
- Develop and optimize complex SQL queries, views, and stored procedures for analytics and reporting use cases.
- Build and manage ELT pipelines within Snowflake leveraging dbt models (staging, intermediate, marts layers).
- Implement incremental data processing, snapshots, and slowly changing dimensions using dbt best practices.




- Perform data ingestion and integration from multiple sources (APIs, flat files, legacy systems) into Snowflake.
- Design and maintain data warehouse architecture (star/snowflake schema) for analytical workloads.
- Ensure data quality by implementing validation tests, data profiling, and monitoring using dbt tests and frameworks.
- Optimize Snowflake performance through clustering, partitioning, query tuning, and warehouse management.
- Implement role-based access control (RBAC), data security, and governance within Snowflake environment.
- Collaborate with analytics, BI, and data science teams to deliver curated datasets and business insights.
- Maintain technical documentation including data models, lineage, and transformation logic.
- Participate in architecture discussions, performance tuning, and cost optimization initiatives.
- Design, build, and maintain scalable data models and transformation pipelines using dbt (Data Build Tool) on Snowflake.
- Develop and optimize complex SQL queries, views, and stored procedures for analytics and reporting use cases.
- Build and manage ELT pipelines within Snowflake leveraging dbt models (staging, intermediate, marts layers).
- Implement incremental data processing, snapshots, and slowly changing dimensions using dbt best practices.
- Perform data ingestion and integration from multiple sources (APIs, flat files, legacy systems) into Snowflake.
- Design and maintain data warehouse architecture (star/snowflake schema) for analytical workloads.
- Ensure data quality by implementing validation tests, data profiling, and monitoring using dbt tests and frameworks.
- Optimize Snowflake performance through clustering, partitioning, query tuning, and warehouse management.
- Implement role-based access control (RBAC), data security, and governance within Snowflake environment.
- Collaborate with analytics, BI, and data science teams to deliver curated datasets and business insights.
- Maintain technical documentation including data models, lineage, and transformation logic.
- Participate in architecture discussions, performance tuning, and cost optimization initiatives.

Expertise You'll Bring:





- 5 to 8 years of experience in SQL development / Data Engineering / Data Warehousing roles.
- Strong hands-on expertise in SQL (writing complex queries, joins, CTEs, window functions, performance tuning).
- Hands-on experience with dbt (models, macros, snapshots, tests, documentation).
- Strong experience working on Snowflake cloud data platform (data loading, transformations, performance optimization).
- Solid understanding of data modeling concepts (dimensional modeling, star/snowflake schema).
- Experience with ELT pipelines and modern data stack architecture.
- Knowledge of incremental loading, CDC, and data versioning techniques.
- Experience with data quality, validation frameworks, and testing methodologies in dbt.
- Familiarity with cloud platforms such as Azure/AWS/GCP and data orchestration tools (Airflow, ADF preferred).
- Good understanding of data governance, access control, and security practices in Snowflake.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent written and verbal communication skills.

Benefits:

- Competitive salary and benefits package
- Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
- Opportunity to work on legacy modernization and large-scale enterprise data systems
- Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
- Annual health check-ups
- Insurance coverage: group term life, personal accident, and Mediclaim for self and family

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

- We support hybrid work and flexible hours to fit diverse lifestyles.
- Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
- If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Let’s unleash your full potential at Persistent - persistent.com/careers

“Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”

1

Open Positions

Database,SQL,Data Engineering

Skills Required

PUNE

Location

Database,SQL,Data Engineering,Data Bricks,ETL

Desirable Skills

180326

Job Code

📌 Senior Engineering Lead (India)
🏢 Persistent
📍 India