Data Engineer II - Snowflake, DBT, AWS

Silicon Valley Bank; Karnataka; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Silicon Valley Bank is looking for a Data Engineer II to join their team in Bangalore. This role involves building and maintaining data platforms supporting key business functions and requires significant experience in data engineering and data warehousing.

The successful candidate will have strong skills in SQL, Python, and cloud-based data platforms like Snowflake, alongside excellent problem-solving abilities. The position offers a hybrid work model and involves close collaboration with global technology teams.

Qualifications

• 5+ years of experience in data engineering and data warehousing.
• Proficient in SQL and at least one scripting language like Python.
• Experience in developing complex data pipelines.

Responsibilities

• Build and maintain data platform supporting data integrations.
• Create data ingestion pipelines for various data sources.
• Optimize data pipelines for performance.

Skills

Team Player

Communication

Problem Solving

Partnership and Collaboration

Attention to Detail

Education

Experience in Data Engineering

Experience with Snowflake and AWS

Understanding of data warehouse principles

Tools

GitLab

IBM Data Stage

SAP BODS

SQL

Python

Job description

Company Overview

FC Global Services India LLP (First Citizens India), a part of First Citizens BancShares, Inc., a top 20 U.S. financial institution, is a global capability center based in Bengaluru. Our India‑based teams benefit from the company’s over 125‑year legacy of strength and stability. First Citizens India is responsible for delivering value and managing risks for our lines of business. We are particularly proud of our strong, relationship‑driven culture and our long‑term approach, which are deeply ingrained in our talented workforce.

Position Details

Title: Data Engineer II

Career Level: P2

Job Category: Senior Associate

Role Type: Hybrid

Location: Bangalore

Team Overview

The data engineering team is a community of dedicated professionals committed to designing, building, and maintaining data platform solutions for the organization. The enterprise data warehouse supports several critical business functions for the bank, including regulatory reporting, finance, risk steering, and customer 360. This role is vital for building and maintaining the enterprise data platform, data processes, and to support business objectives.

Key Deliverables (Duties and Responsibilities)

• Responsible for building and maintaining data platform that supports data integrations for Enterprise Data Warehouse, Operational Data Store or Data Marts, etc. with appropriate data access, data security, data privacy and data governance.
• Create data ingestion pipelines in data warehouses and other large‑scale data platforms.
• Create data ingestion pipeline for a variety of sources – File (Flat, delimited, Excel), DB, API (with Apigee integration), and SharePoint.
• Build reusable data pipelines / frameworks using Python.
• Create scheduled and trigger‑based ingestion patterns using scheduling tools.
• Create performance‑optimized DDLs for any row‑based or columnar databases such as Oracle, Postgres, Netezza per Logical Data Model.
• Performance tuning of complex data pipelines and SQL queries.
• Perform impact analysis of proposed changes on existing architecture, capabilities, system priorities, and technology solutions.
• Work in Agile framework, participating in various agile ceremonies, coordinating with scrum master, tech lead, and PO on sprint planning, backlog creation, refinement, demo, and retrospection.
• Work with product owners to understand PI goals, PI planning, requirement clarification, and delivery coordination.
• Provide technical support for production incidents and failures.
• Work with global technology teams across different time zones (primarily US) to deliver timely business value.

Skills and Qualification

• Functional Skills:
• Team Player: Support peers, team, and department management.
• Communication: Excellent verbal, written, and interpersonal communication skills.
• Problem Solving: Excellent problem‑solving skills, incident management, root cause analysis, and proactive solutions to improve quality.
• Partnership and Collaboration: Develop and maintain partnership with business and IT stakeholders.
• Attention to Detail: Ensure accuracy and thoroughness in all tasks.

Technical/Business Skills

• Data Engineering: Experience in designing and building data warehouse and data lakes. Good knowledge of data warehouse principles and concepts. Technical expertise working in large scale data warehousing applications and databases such as Oracle, Netezza, and SQL Server.
• Experience with public cloud‑based data platforms especially Snowflake and AWS.
• Data integration skills: Expertise in design and development of complex data pipelines. Solutions using any industry leading ETL tools such as IBM Data Stage and/or SAP BODS.
• Basic knowledge of ELT tools such as DBT (Data Build Tool), Fivetran, and AWS Glue.
• Expert in SQL – development experience in at least one scripting language (Python, etc.), adept in tracing and resolving data integrity issues.
• Knowledge of logical and physical data models using relational or dimensional modeling practices, high‑volume ETL/ELT processes.
• Performance tuning of data pipelines and DB objects to deliver optimal performance.
• Experience in GitLab version control and CI/CD processes.
• Experience working in the financial industry is a plus.

Reporting Structure

Reports to: Associate Director – Data Engineering

Partners: Senior leaders and cross‑functional teams

Accessibility Needs

We are committed to providing an inclusive and accessible hiring process. If you require accommodations at any stage (e.g. application, interviews, onboarding) please let us know, and we will work with you to ensure a seamless experience.

Equal Employment Opportunity

FC Global Services India LLP (First Citizens India) is an Equal Employment Opportunity Employer. We are committed to fostering an inclusive and accessible environment and prohibit all forms of discrimination on the basis of gender, religion, caste, disability, sexual orientation, economic status or any other characteristics protected by the law. We strive to foster a safe and respectful environment in which all individuals are treated with respect and dignity. Our EEO policy ensures fairness throughout the employee life cycle.