
Data Engineering - Assistant Vice President
State Street1 day ago
Bengaluru, India or Hyderābād, IndiaStaff+
Responsibilities
- Lead the architecture, design, development, and production support of enterprise-grade batch and near-real-time data pipelines.
- Design reusable ETL/ELT frameworks using Python, SQL, Alteryx, and modern cloud data engineering services.
- Own dimensional and relational models, data marts, semantic-ready datasets, metadata, lineage, and documentation.
- Optimize queries, pipelines, storage, partitioning, indexing, incremental loads, parallel processing, and workloads for large-volume datasets.
- Establish data quality, reconciliation, auditability, security, retention, and access-management controls.
- Lead design reviews, code reviews, development standards, release governance, incident resolution, root-cause analysis, and continuous improvement.
- Partner with business, reporting, analytics, architecture, infrastructure, and vendor teams on roadmaps, estimates, dependencies, and delivery.
- Mentor engineers and analysts, build team capability, and communicate solution options, risks, and trade-offs to senior stakeholders.
- Evaluate data science, machine learning, and AI use cases that can improve data quality, anomaly detection, forecasting, classification, or operational efficiency.
Requirements
- 12–16 years of relevant technology experience, including substantial hands-on data engineering experience and at least 3 years leading complex data solutions or engineering workstreams.
- Advanced SQL skills including complex joins, window functions, stored procedures, query plans, indexing, performance tuning, and large-scale transformations.
- Strong Python engineering skills for data processing, automation, API integration, reusable libraries, testing, logging, and production pipeline development.
- Experience designing ETL/ELT pipelines, orchestration, scheduling, restartability, dependency management, monitoring, and production support.
- Strong knowledge of data modeling, relational databases, dimensional modeling, schema design, slowly changing dimensions, data marts, and master/reference data patterns.
- Hands-on Alteryx experience and experience with at least one modern engineering stack such as Azure Data Factory, Microsoft Fabric, Azure Synapse, Databricks, Apache Spark, or AWS Glue.
- Experience with APIs, JSON, CSV, Parquet, database extracts, file-based feeds, structured and semi-structured data, and secure data-transfer patterns.
- Experience with Git-based version control, CI/CD, unit and integration testing, environment promotion, release management, and technical documentation.
- Strong understanding of data quality, reconciliation, lineage, metadata, security, privacy, audit controls, and regulated data-management practices.
- Proven leadership, stakeholder management, problem-solving, written communication, and ability to manage competing priorities in a global delivery environment.
- Working knowledge of data science methods, machine learning libraries, generative AI concepts, MLOps or LLMOps, Power BI, DAX, semantic models, Docker, Kubernetes, graph databases, Kafka, and infrastructure-as-code is advantageous.
- Financial-services experience in banking operations, payments, transaction management, reconciliation, controls, or regulatory reporting is preferred.
- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Science, Statistics, or a related discipline.
- Cloud or data-engineering certifications from Microsoft Azure, Databricks, AWS, Google Cloud, or equivalent are advantageous.
Benefits
- Inclusive development opportunities and flexible work-life support.
- Paid volunteer days.
- Vibrant employee networks.
Tech Stack
Categories
Data Engineering
About State Street
State Street is a global custodian bank and asset manager serving institutional investors with investment servicing, fund accounting, trading/FX, data, and index/active strategies. Its products include State Street Global Advisors’ funds and ETFs, the Charles River Investment Management Solution, and the front-to-back State Street Alpha platform. Founded in 1792 and headquartered in Boston, the company is publicly traded on the NYSE (ticker: STT) and operates across major markets worldwide.