Lead Data Engineer - Snowflake + (Datastage/BODS)

SIG - India Global Delivery Center

Bengaluru

Hybrid

INR 3,000,000 - 6,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

FC Global Services India LLP (First Citizens India) in Bengaluru seeks a Lead Data Engineer to design, build, and maintain enterprise data platforms and data lakes. You will lead data pipeline development for large-scale data ingestion, leveraging ETL/ELT processes and cloud technologies.

Join a collaborative data engineering team, work across time zones, and drive scalable data solutions that support regulatory reporting, finance, risk, and customer insights.

Qualifications

  • 10+ years of experience designing and building Data Warehouse and Data Lakes.
  • Strong knowledge of data warehouse principles and concepts.
  • Experience with large-scale Data Warehousing applications and multiple databases.
  • Cloud-based data platforms, especially Snowflake and AWS.
  • Experience with ETL/ELT tools and data integration technologies.
  • Proficient in SQL, stored procedures, and data governance.

Responsibilities

  • Design, build, and maintain data platforms, data lakes, and cloud solutions.
  • Develop data pipelines for enterprise data through ETL/ELT processes.
  • Collaborate with Product Owners and global teams to ensure timely delivery.
  • Establish scalable data integration procedures and data governance.
  • Perform design reviews and coordinate release management.
  • Provide technical risk assessment and incident support.

Skills

Team Player
Communication
Problem Solving
Partnership & Collaboration
Attention to Detail

Tools

Oracle
Netezza
Teradata
SQL Server
Snowflake
AWS
IBM DataStage
SSIS
SAP BO Data Services
Unix
Python
DBT
AWS Glue
Snowpark

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 Preposition

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 for any row-based or columnar databases such as Oracle, Postgres, Netezza database 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.
  • Technical expertise working in large scale Data Warehousing applications and databases such as Oracle, Netezza, Teradata, and SQL Server.
  • Cloud-based data platform experience 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 or SSIS or SAP Business Objects Data Services (BODS)
  • Experience with Unix, Python or equivalent scripting language
  • Basic knowledge of Transform/ELT tools such as DBT , Qlik Replicate, AWS Glue or Snowpark , etc.
  • Expert in SQL , stored procedures and adept in tracing and resolving data integrity issues.

Str

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer - Snowflake + DBT (Data build Tools)
Lead Data Engineer - Snowflake + DBT (Data build Tools)

Svb • Bengaluru

Hybrid
INR 4,000,000 - 7,000,000
Lead Data Engineer - Snowflake + DBT (Data build Tools)
Lead Data Engineer - Snowflake + DBT (Data build Tools)

First Citizens India • Bengaluru

Hybrid
INR 4,000,000 - 7,000,000
Lead Data Engineer - Snowflake Platform
Lead Data Engineer - Snowflake Platform

First Citizens India • Bengaluru

Hybrid
INR 4,000,000 - 6,000,000
Lead Data Engineer - Snowflake + DBT (Data build Tools)
Lead Data Engineer - Snowflake + DBT (Data build Tools)

First Citizens India • Bengaluru

Hybrid
INR 4,000,000 - 6,000,000
Lead Data Engineer
Lead Data Engineer

Indxx • Gurugram District

On-site
INR 3,600,000 - 5,200,000
Data Engineer II - Snowflake, DBT, AWS
Data Engineer II - Snowflake, DBT, AWS

Silicon Valley Bank • Karnataka

Hybrid
INR 1,200,000 - 1,800,000
Lead Data Engineer
Lead Data Engineer

Gardahaus • Karnataka

Hybrid
INR 2,800,000 - 3,800,000
Lead Data Engineer (Lead Software Engineer)
Lead Data Engineer (Lead Software Engineer)

DigitalXNode • Ahmedabad District

On-site
INR 1,800,000 - 2,600,000
Snowflake Data Engineer – Lead
Snowflake Data Engineer – Lead

Taggd • Mumbai

Hybrid
INR 3,500,000 - 6,000,000
Lead Data Engineer
Lead Data Engineer

Stryker India Private Limited • Gurugram District

Hybrid
INR 3,000,000 - 6,000,000