
Data Engineer II - Snowflake and DBT
Silicon Valley Bank12 hours ago
Bengaluru, IndiaMid Level
Responsibilities
- Build and maintain data platforms supporting enterprise data warehouses, operational data stores, and data marts.
- Develop ingestion pipelines for files, databases, APIs with Apigee integration, and SharePoint.
- Build reusable data-pipeline frameworks using Python and create scheduled or trigger-based ingestion patterns.
- Create performance-optimized DDLs and tune complex data pipelines, SQL queries, and database objects.
- Apply data access, security, privacy, governance, and logical and physical data-modeling practices.
- Perform impact analysis of proposed changes across architecture, capabilities, priorities, and technology solutions.
- Provide technical support for production incidents and failures, including root-cause analysis and proactive remediation.
- Participate in sprint planning, backlog refinement, demonstrations, retrospectives, PI planning, and requirement clarification.
- Coordinate with Product Owners, Scrum Masters, technical leads, global technology teams, and cross-functional stakeholders.
Requirements
- At least 5 years of experience building data pipelines on data warehouse and data lake platforms.
- Strong knowledge of Snowflake for enterprise implementations and migration from legacy or on-premises systems.
- Technical expertise with AWS services including S3, Lambda, Glue, Step Functions, and CloudWatch.
- Experience designing and developing complex data pipelines and using ELT tools such as dbt, Qlik Replicate, and Snowpark.
- Expert SQL skills plus experience with Unix and Python scripting.
- Experience orchestrating data pipelines with Airflow.
- Knowledge of logical and physical data models using relational or dimensional modeling and high-volume ETL/ELT processes.
- Experience with GitLab version control and CI/CD processes.
- Data Vault 2.0 experience and financial-industry experience are preferred.
- Excellent problem-solving, incident-management, communication, collaboration, and stakeholder-partnership skills.
Benefits
- Hybrid work arrangement in Bengaluru/Bangalore.
- Inclusive and accessible hiring process with accommodations available during application, interviews, and onboarding.
- Opportunity to work with global technology teams and support critical banking data functions.
About Silicon Valley Bank
Silicon Valley Bank provides commercial banking, treasury management, venture debt, and global services to startups, growth-stage companies, and investors in technology, life sciences, healthcare, and premium wine industries. Founded in 1983 and based in Santa Clara, California, it operates in the U.S. as Silicon Valley Bank, a division of First Citizens Bank, following its 2023 acquisition. Clients include venture-backed companies and venture capital/private equity firms needing specialized credit, cash management, and international banking.