Snowflake & DBT Developer - Assistant Manager

Role Summary & Role Description:

We are seeking a talented Senior Software Engineer to join our agile team. The successful candidate will play a crucial role in ensuring the quality and reliability of our software products, with a focus on developing Azure-based applications, data warehouse and ETL backend systems. Proficiency in Data Warehousing and Snowflake is essential for this role.

Candidate must have minimum of 8 years of relevant experience in Data Warehousing and Database application development. Candidate must have hands on experience in Snowflake and Azure. Analyze, Design and Code snowflake objects and views. Create Database Views/materialized views, Indexes, Partitions. Experience in Shell scripting and Autosys/Control-M/Cron scheduling. Ability to communicate with Business users, understand and Analyze requirements and Use Cases. Experience working in Agile Teams. Proven problem solving, communication, interpersonal and analytical skills. Ability to work both independently as well as within a team.

Core/Must have skills:

• Good knowledge in Data Warehouse concepts and different schema types like Star and Snowflake
• Strong experience in writing complex queries, performance tuning, query optimization and debugging.
• Minimum 4 years working experience in Snowflake and good knowledge on Snowpipe, DBT Experience in working with Snowflake. Hands-on experience in bulk loading and unloading data into Snowflake tables using COPY command. Handling large and complex data sets like JSON, ORC, PARQUET CSV files from various sources like AWS S3. TASK, Snowpipe creation for scheduling/Automate Snowflake jobs.
• Good exposure in Snowflake Cloud Architecture, SnowSQL and SNOWPIPE for continuous data loading.
• Good communication skills, problem solving skills and ability to analyses quickly and come-up with an efficient industry standard solution for a given problem

Good to have skills:

• Good knowledge on Oracle database and Proficient in SQL Performance tuning.
• Good knowledge on BigData and Spark
• Good knowledge on Databricks
• Good knowledge on DBT (Data Build Tool)

Work Schedule: On-premise / Hybrid

Why this role is important to us

Our technology function, Global Technology Services (GTS), is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We’re driving the company’s digital transformation and expanding business capabilities using industry best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation.

We offer a collaborative environment where technology skills and innovation are valued in a global organization. We’re looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company.

Join us if you want to grow your technical skills, solve real problems and make your mark on our industry.

State Street's Speak Up Line