Data Services Engineering - Assistant Manager

State Street; Hyderabad; On-site; INR 4,500,000 - 6,500,000; Full time

Job summary

State Street Data Services Engineering is seeking an experienced Snowflake Developer with 8+ years of IT experience to design, develop, and optimize cloud-based data warehousing solutions on Snowflake. You will lead ELT/ETL pipelines, implement best practices, and collaborate with stakeholders across the organization.

The role requires deep SQL expertise, data modeling (Dimensional and Data Vault), and hands-on experience with ETL tools and cloud platforms (AWS/Azure/GCP).

Qualifications

• 8+ years of IT experience with Snowflake development
• Strong data warehousing, ETL/ELT and data modeling skills
• Experience with cloud platforms (AWS/Azure/GCP)
• Excellent stakeholder management and communication skills
• Knowledge of CI/CD and DevOps practices
• Financial services or related domain experience is a plus

Responsibilities

• Design, develop, and implement scalable data warehouse solutions using Snowflake.
• Create and optimize Snowflake databases, schemas, tables, views, tasks, streams, and stored procedures.
• Develop and maintain ELT/ETL pipelines for loading data into Snowflake from multiple sources.
• Implement Snowflake best practices for performance, security, and cost optimization.
• Migrate data from on-premises databases to Snowflake.
• Build data ingestion frameworks for batch and real-time processing.
• Design dimensional and data vault models for analytics workloads.
• Develop complex SQL queries, stored procedures, and data transformations.
• Conduct data validation, reconciliation, and quality checks.
• Monitor warehouse utilization and query performance; tune where needed.
• Implement clustering, partitioning, materialized views, and caching strategies.
• Perform root cause analysis and resolve production issues.
• Integrate Snowflake with cloud platforms (AWS/Azure/GCP) and storage (S3/Blob/Azure Data Lake).
• Collaborate with business stakeholders, architects, and cross-functional teams.
• Work with ETL tools like Informatica, Matillion, DBT, Talend, Airflow, or ADF.
• Support API and file-based data integrations.

Skills

Snowflake data cloud

SQL programming

Python scripting

Cloud platforms

Education

Bachelor's or Master's in CS/IT

Snowflake Certification

Tools

Informatica

Matillion

DBT

Talend

Airflow

ADF

Job description

State Street Data Services Engineering

Who We Are Looking For

We are seeking an experienced Snowflake Developer with 8+ years of overall IT experience and strong expertise in designing, developing, and optimizing cloud-based data warehousing solutions on the Snowflake platform. The ideal candidate will have hands-on experience in data engineering, ETL/ELT development, performance tuning, data modeling, and cloud technologies. The candidate should be capable of working with business stakeholders, architects, and cross-functional teams to deliver scalable and secure data solutions.

What You Will Be Responsible For

• Design, develop, and implement scalable data warehouse solutions using Snowflake.
• Create and optimize Snowflake databases, schemas, tables, views, tasks, streams, and stored procedures.
• Develop and maintain ELT/ETL pipelines for loading data from multiple source systems into Snowflake.
• Implement Snowflake best practices for performance, security, and cost optimization.
• Perform data migration from on-premises databases to Snowflake.
• Build and maintain data ingestion frameworks using batch and real-time processing.
• Design dimensional and data vault models for analytical and reporting workloads.
• Develop complex SQL queries, stored procedures, and data transformation logic.
• Conduct data validation, reconciliation, and quality checks.
• Monitor and optimize warehouse utilization and query performance.
• Implement clustering, partitioning, materialized views, and caching strategies.
• Perform root cause analysis and resolve production issues.
• Integrate Snowflake with cloud platforms such as AWS, Azure, or GCP.
• Work with cloud storage solutions including S3, Azure Data Lake, and Blob Storage.
• Implement data pipelines using ETL tools such as Informatica, Matillion, DBT, Talend, Airflow, or ADF.
• Support API and file-based data integrations.

What We Value

• Strong hands-on experience with Snowflake Data Cloud Platform.
• Advanced SQL programming expertise.
• Experience with Snowflake Streams, Tasks, Dynamic Tables, Snowpipe, External Tables, and Stored Procedures.
• Experience with Python or Shell scripting.
• Strong understanding of data warehousing concepts and dimensional modeling.
• Hands-on experience with ETL/ELT tools.
• Experience working with cloud platforms (AWS/Azure/GCP).
• Knowledge of performance tuning and query optimization techniques.

Education & Preferred Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
• Snowflake Certification (SnowPro Core / Advanced) preferred.
• Experience with CI/CD pipelines and DevOps practices.
• Experience with Data Governance and Metadata Management tools.
• Experience in Financial Services, Banking, Asset Management, or Regulatory Reporting domains is a plus.

Additional & Nice To Have Skillset

• Databricks experience.
• Snowflake Native Apps and Snowpark development.
• Experience with Kafka/Event Streaming platforms.
• Knowledge of AI/ML data pipelines and analytics platforms.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Ability to lead technical discussions and mentor team members.
• Experience working in Agile environments.
• Strong ownership and accountability mindset.

Work Requirement

• Regular Shift – As per the Org Policy

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.