Jav Full Stack Engineer

Job Details

• Role:
  Snowflake Lead
• Location:
  
  Glasgow, UK
• Experience:
  
  15+ years
• Job Type: Full Time Employment
• Mandatory
  
  Skills:
  
  Snowflake, Data Migration, Teradata

We are seeking an experienced Development Lead with strong expertise in Teradata, Snowflake, and CI/CD automation to lead enterprise‑scale data platform initiatives, including legacy Teradata modernization and Snowflake cloud migrations. The role requires hands‑on technical leadership, architectural thinking, and the ability to mentor teams while working closely with stakeholders.

• Lead design and development of data solutions using Teradata and Snowflake.
• Own end‑to‑end modernization initiatives from Teradata to Snowflake.
• Lead development of data models, ETL processes, and data integration strategies.
• Define data modeling, performance tuning, and SQL optimization standards.
• Ensure scalable, secure, and cost‑efficient Snowflake usage.
• Evaluate and recommend tools and technologies to enhance data management and analytics capabilities.

• Assess existing Teradata BTEQ, Fast Load, Multiload, TPT jobs.
• Redesign and implement equivalent solutions in Snowflake (SQL, Streams, Tasks, MERGE).
• Drive data hydration, CDC, and incremental load patterns.
• Implement efficient, robust ETL code and adhere to best practices and coding standards.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using Apache Airflow, Spark, SQL, Python, and ETL tools.

• Design and implement CI/CD pipelines for data platforms.
• Automate code deployment, environment promotion (Dev, QA, Prod), rollbacks, and validations.
• Integrate CI/CD with Git, Jenkins, Azure Dev Ops, or Git Hub Actions.
• Enforce version control, code reviews, and branching strategies.
• Design and develop ETL workflows and data integration strategies.

• Mentor developers and reviewers on best practices.
• Coordinate with architects, QA, Dev Ops, and business teams.
• Provide technical guidance during design and production issues.
• Participate in client discussions and solution reviews.

• Teradata – strong SQL, performance tuning, BTEQ scripting, experience with Fast Load, Multi Load, TPT.
• Snowflake – architecture (virtual warehouses, storage, micro‑partitioning), SQL optimization, cost governance, Streams, Tasks, MERGE, roles, RBAC, security & data sharing.
• Payments and BFSI experience.

• Competitive salary and benefits package.
• Culture focused on talent development with quarterly growth opportunities and company‑sponsored higher education and certifications.
• Opportunity to work with cutting‑edge technologies.
• 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 hospitalization for self, spouse, two children, and parents.

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