Data Engineer II - Snowflake and DBT

Silicon Valley Bank; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

FC Global Services India LLP (First Citizens India) in Bengaluru hires a Data Engineer II to design and build enterprise data pipelines and platforms. You will craft ingestion flows for data warehouses and data lakes, leveraging Snowflake, AWS, Airflow, and Python within a collaborative, Agile environment.

The role focuses on building scalable data platform solutions, data governance, and enabling analytics across Finance, Risk, and Operations teams.

Qualifications

• 5+ years of experience building data pipelines in Data Warehouse/Data Lake environments.
• Strong SQL and data modeling knowledge, with experience in enterprise data platforms.
• Experience with Snowflake and AWS cloud services (S3, Lambda, Glue, Step Function).

Responsibilities

• Build and maintain data platform solutions for Enterprise Data Warehouse and Data Lake.
• Create data ingestion pipelines from File, DB, API, and SharePoint sources.
• Develop reusable data pipelines/frameworks using Python.
• Implement scheduled and trigger-based ingestion patterns.
• Tune performance of pipelines and DB objects for efficiency.
• Collaborate in Agile ceremonies with product owners and tech teams.
• Support production incidents and cross-time-zone delivery.

Skills

Team player

Communication

Problem solving

Partnership and collaboration

Attention to detail

Education

Bachelor's degree in CS or related

Tools

Snowflake

AWS

Airflow

DBT

Qlik Replicate

Snowpark

Gitlab CI/CD

Python

Unix

Job description

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 (GCC) 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. This is evident across all key areas of our operations, including Technology, Enterprise Operations, Finance, Cybersecurity, Risk Management, and Credit Administration. We are seeking talented individuals to join us in our mission of providing solutions fit for our clients’ greatest ambitions.

Job Description

Value Proposition: Responsible for designing and building data pipelines for enterprise data through ETL/ELT processes. Develop and maintain large-scale data platforms, data lakes and cloud solutions.

Job Details: Position Title: Data Engineer II Career Level: P2 Job Category: Senior Associate Role Type: Hybrid Job Location: Bangalore

About the Team

The data engineering team is community of dedicated professionals committed to designing, building, and maintaining data platform solutions for the organization. Impact: 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 enterprise data platform, data processes, and to support business objectives. Our values — inclusivity, transparency, and excellence — drive everything we do. Join us and make a meaningful impact on the organization.

Key Deliverables

• 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.
• Creating scheduled as well as trigger-based ingestion patterns using scheduling tools.
• Create performance optimized DDLs as per Logical Data Model.
• Performance tuning of complex data pipelines and SQL queries.
• Performs impact analysis of proposed changes on existing architecture, capabilities, system priorities, and technology solutions.
• Working in Agile Framework, participating in various agile ceremonies, co-ordination with scrum master, tech lead, and PO on sprint planning, backlog creation, refinement, demo, and retrospection.
• Working with Product Owners to understand PI goals, PI planning, requirement clarification, and delivery coordination.
• 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: 5+ years of experience in building data pipelines in Data Warehouse and Data Lake platforms.
• Good knowledge of data warehouse principles, and concepts.
• Strong knowledge of Snowflake data platform and solutions for enterprise level implementation, and migration from legacy or on-prem systems.
• Technical expertise of AWS cloud related services such as S3, Lamda, Glue, Step Function, CloudWatch, etc.
• Data integration skills: Experience in design and development of complex data pipelines.
• Technical expertise in ELT tools such as DBT, Qlik Replicate, Snowpark, etc.
• Expert in SQL.
• Experience with Unix and Python scripting.
• Experience in data pipeline orchestration using Airflow.
• Data Model: Knowledge of Logical and Physical Data Model using Relational or Dimensional Modeling practices, high volume ETL/ELT processes.
• Good to have Data Vault 2.0 experience.
• Performance tuning of data pipelines and DB Objects to deliver optimal performance.
• Experience in Gitlab version control and CI/CD processes.
• Experience working in Financial Industry is a plus.

Relationships & Collaboration: Reports to: Senior Manager - Data Engineering Partners: Senior leaders and cross-functional teams Collaborates: A team of Data Engineering associates.

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.

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 (GCC) 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. This is evident across all key areas of our operations, including Technology, Enterprise Operations, Finance, Cybersecurity, Risk Management, and Credit Administration. We are seeking talented individuals to join us in our mission of providing solutions fit for our clients’ greatest ambitions.

First Citizens BancShares, Inc., a top 20 U.S. financial institution with more than $200 billion in assets and a member of the Fortune 500™, is the financial holding company for First-Citizens Bank & Trust Company ("First Citizens Bank"). Headquartered in Raleigh, N.C., First Citizens Bank has built a unique legacy of strength, stability and long-term thinking that has spanned generations.

Visit: https://www.firstcitizens.com/