Lead Data Engineer - Snowflake and DBT
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
Key Skills for This Role
Full Job Posting
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.
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.
- 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
- 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.
About First Citizens Bank
Financial institution providing personal, business, and commercial banking services.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at First Citizens Bank
Senior Risk Analyst (Remote)
, USA
Operations Analyst I
Charlotte, USA
Premier Client Banker
Atlanta, USA
Senior Red Hat Linux Platform Engineer
, USA
Wealth Client Specialist - Raleigh
Raleigh, USA
Fraud Prevention Analyst II
, USA
Senior Global Treasury Implementation Associate
Charlotte, USA
Equipment Finance Collateral Monitoring Spec I
Portsmouth, USA