Lead Data Engineer - Snowflake and DBT

Posted Yesterday
Be an Early Applicant
Bangalore, Bengaluru Urban, Karnataka, IND
In-Office
Expert/Leader
Financial Services
The Role
Lead the design, development, and maintenance of enterprise data platforms, warehouses, lakes, marts, and cloud solutions. Build scalable ETL/ELT pipelines using Snowflake, AWS, DBT, Airflow, and related technologies; optimize SQL and data pipeline performance; establish data integration frameworks, governance, security, and privacy practices; lead design reviews, release coordination, automation, incident support, and technical risk management. Collaborate with product owners and global technology teams while guiding data engineering associates.
Summary Generated by Built In

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

  • Lead the development and maintenance of large-scale data platforms, data lakes and cloud solutions.
  • Responsible for designing and building data pipelines for enterprise data through ETL/ELT processes.

Job Details

Position Title:  Lead Data Engineer

Career Level:  P3

Job Category: Manager

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 designing, 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.
  • Establish enterprise-scale data integration procedures, data pipelines and frameworks across the data development life cycle. Suggest and implement appropriate technologies to deliver resilient, scalable, and future-proof data solutions.
  • Create data ingestion pipelines in data warehouses and other large-scale data platforms.
  • 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.
  • Manage deliverables of developers, perform design reviews and coordinate release management activities.
  • Estimate and provide timelines for project activities. Identify, document, and communicate technical risks, issues and alternative solutions discovered during project.
  • Drive automation, identify inefficiencies, optimize processes and data flows, and recommend improvements.
  • Use agile engineering practices and various data development technologies to rapidly develop and implement efficient data products.
  • Collaborate 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:
    • 10+ years of experience in designing and building Data Warehouse and Data lakes. 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:
    • Expertise in design and development of complex data pipelines
    • Technical expertise in ELT/ETL tools such as DBT, Qlik Replicate, Snowpark, etc.
    • Expert in SQL
    • Experience with Unix and Python scripting
    • Experience in data pipeline orchestration using Airflow
  • Strong knowledge of data architecture, data design patterns, modeling, and cloud data solutions (Snowflake, AWS Redshift).
  • Data Model: Expertise in Logical and Physical Data Model using Relational, Dimensional or Data Vault Modeling practices with 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 Financial Industry is a plus.

Relationships & Collaboration

  • Reports to: Senior Manager - Data Engineering
  • Partners: Senior leaders and cross-functional teams
  • Leads: 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.

Skills Required

  • 10+ years of experience designing and building data warehouses and data lakes
  • Strong knowledge of the Snowflake data platform, enterprise implementations, and legacy or on-premises migrations
  • Technical expertise with AWS services including S3, Lambda, Glue, Step Functions, and CloudWatch
  • Expertise designing and developing complex data pipelines
  • Experience with ETL/ELT tools such as DBT, Qlik Replicate, and Snowpark
  • Expert-level SQL skills
  • Experience with Unix and Python scripting
  • Experience orchestrating data pipelines with Airflow
  • Strong knowledge of data architecture, data design patterns, data modeling, and cloud data solutions
  • Experience with Snowflake and AWS Redshift
  • Expertise in logical and physical data modeling using relational, dimensional, or Data Vault practices
  • Experience with high-volume ETL/ELT processes
  • Experience tuning data pipelines and database objects for performance
  • Experience with GitLab version control and CI/CD processes
  • Financial industry experience

Silicon Valley Bank Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Silicon Valley Bank and has not been reviewed or approved by Silicon Valley Bank.

  • Healthcare Strength Medical, dental, and vision coverage are broad, complemented by mental health resources, healthcare advocacy, and wellness programs. Multiple plan options and added programs (e.g., digital health and well-being services) indicate depth in healthcare support.
  • Retirement Support Retirement programs include a matched 401(k) and additional savings vehicles such as ESOP and ESPP. Match levels and potential discretionary contributions signal strong employer support for long-term savings.
  • Parental & Family Support Parental leave provides up to 12 weeks at full base pay for birth or adoption. Family support extends to back-up care, special needs assistance, college coaching, and inclusive family-building benefits like fertility, adoption, and surrogacy support.

Silicon Valley Bank Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
3,970 Employees
Year Founded: 1983

What We Do

Silicon Valley Bank (SVB), a division of First Citizens Bank, is the bank of the world’s most innovative companies and investors. SVB provides commercial and private banking to individuals and companies in the technology, life science and healthcare, private equity, venture capital and premium wine industries. SVB operates in centers of innovation throughout the United States, serving the unique needs of its dynamic clients with deep sector expertise, insights and connections. SVB's parent company, First Citizens Bancshares, Inc. (NASDAQ: FCNCA) is a top 20 U.S. financial institution with more than $200 billion in assets. First Citizens Bank, Member FDIC. Learn more at svb.com.

Similar Jobs

In-Office
Bangalore, Bengaluru Urban, Karnataka, IND
3970 Employees

TransUnion Logo TransUnion

Senior Engineer

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
Bengaluru, Bengaluru Urban, Karnataka, IND
13000 Employees

CrowdStrike Logo CrowdStrike

Engineer III - CICD DevOps

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Hybrid
2 Locations
11000 Employees

Zeta Global Logo Zeta Global

Senior Analyst, Analytics and Insights (Programmatic)

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Hybrid
Bangalore, Bengaluru Urban, Karnataka, IND
2429 Employees

Similar Companies Hiring

Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account