Senior Engineering Lead

Persistent

5–8 yrs Pune Full Time Hybrid (office + remote)
Persistent logo
Posted : today
Actively hiring

Job description

Join our innovative team as a Senior Engineering Lead, driving the future of data platforms. This role focuses on designing, developing, and optimizing scalable data solutions using Snowflake and dbt. You will be instrumental in building robust ELT pipelines, ensuring data quality, and fostering best practices within modern cloud analytics environments. We seek a technical leader with hands-on development skills and a collaborative spirit to deliver exceptional data outcomes.

Responsibilities

Lead the design and implementation of scalable data models and transformation pipelines with dbt on Snowflake. Develop and refine complex SQL queries, views, and stored procedures for advanced analytics. Construct and manage ELT pipelines, incorporating dbt models for staging, intermediate, and mart layers. Implement incremental data processing, snapshots, and slowly changing dimensions using dbt best practices. Oversee data ingestion from diverse sources into Snowflake. Maintain data warehouse architecture, including star/snowflake schemas, for analytical workloads. Ensure data integrity through validation tests, profiling, and monitoring with dbt. Optimize Snowflake performance via clustering, partitioning, query tuning, and warehouse management. Implement robust RBAC, data security, and governance protocols within Snowflake. Collaborate with analytics, BI, and data science teams to deliver valuable datasets and insights. Create and maintain comprehensive technical documentation, including data models and lineage. Contribute to architecture discussions, performance tuning, and cost optimization initiatives.

Qualifications

Possess 5 to 8 years of experience in SQL development, Data Engineering, or Data Warehousing. Demonstrate strong hands-on expertise in SQL, including complex queries, CTEs, window functions, and performance tuning. Exhibit practical experience with dbt, covering models, macros, snapshots, tests, and documentation. Showcase significant experience working with the Snowflake cloud data platform for loading, transformation, and performance optimization. Possess a solid understanding of data modeling concepts, such as dimensional modeling and star/snowflake schemas. Have experience with ELT pipelines and modern data stack architectures. Familiarity with cloud platforms like Azure, AWS, or GCP, and data orchestration tools such as Airflow or ADF is advantageous. Exhibit a good grasp of data governance, access control, and security practices within Snowflake. Apply strong analytical, troubleshooting, and problem-solving capabilities. Communicate effectively in both written and verbal formats.

Essential Skills

SnowflakedbtSQLData WarehousingELTData ModelingETLCloud Data PlatformsData QualityPerformance TuningData SecurityData Governance

Good to Have

AzureAWSGCPAirflowADF

Highlights

  • Actively hiring

More Details

RoleSenior Engineering Lead
DepartmentData Engineering, Software Development
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Persistent Systems logo

Persistent Systems

IT Consulting

Senior Engineering Lead at Persistent | SkillMX | SkillMX