Business Intelligence & Data Warehousing - Assistant Vice President

Assistant Vice President (AVP) – Business Intelligence & Data Warehousing Location Bangalore, India Role Summary We are seeking a highly motivated and experienced Assistant Vice President (AVP) – Business Intelligence & Data Warehousing to lead the design, delivery, modernization, and operational excellence of enterprise data warehousing, reporting, analytics, and data visualization platforms. This role will be responsible for managing a team of engineers, BI developers, and data analysts supporting critical Finance and business intelligence applications. The ideal candidate will combine strong technical expertise in Data Warehousing and BI platforms with proven leadership capabilities, stakeholder management skills, and a passion for driving data-driven decision-making across the organization. Key Responsibilities Leadership & Strategy • Lead and mentor a team of BI developers, data engineers, ETL specialists, and support engineers. • Define and execute the roadmap for Data Warehouse, Reporting, Analytics, and Visualization platforms. • Drive modernization initiatives including cloud migration, automation, self-service analytics, and AI-enabled reporting solutions. • Partner with Finance, Product, Operations, Risk, and Technology stakeholders to prioritize and deliver strategic data initiatives. • Establish engineering best practices, governance standards, and data quality frameworks. Data Warehousing & Engineering • Lead architecture, development, and support of enterprise-scale Data Warehouse solutions. • Design scalable data models including Star Schema, Snowflake Schema, Data Marts, and Aggregation Layers. • Oversee ETL/ELT development, data integration, and orchestration frameworks. • Ensure adherence to data governance, metadata management, lineage, and security standards. • Drive performance tuning, capacity planning, and optimization of warehouse platforms. Business Intelligence & Analytics • Lead delivery of enterprise reporting, dashboards, self-service BI, and analytical solutions. • Collaborate with business partners to translate requirements into actionable insights. • Promote adoption of data visualization best practices and KPI standardization. • Establish metrics and reporting frameworks to measure business performance. Technology & Innovation • Evaluate and implement emerging data technologies and cloud-native solutions. • Drive automation using Python, APIs, workflow orchestration, and modern engineering practices. • Champion DevSecOps, CI/CD, Infrastructure as Code, and observability standards. • Identify opportunities to leverage AI/ML and advanced analytics to improve business outcomes. Operational Excellence • Ensure high platform availability, stability, and resiliency. • Manage production support, incident management, capacity planning, and service improvements. • Drive reduction of technical debt and operational risks. • Maintain compliance with security, audit, risk, and regulatory requirements. Stakeholder Management • Communicate effectively with senior leadership and executive stakeholders. • Provide transparent status reporting on roadmap, risks, dependencies, and achievements. • Influence cross-functional teams and drive alignment across business and technology organizations. Required Qualifications • Bachelor's degree in Computer Science, Engineering, Information Systems, or related field. • 12+ years of experience in Business Intelligence, Data Warehousing, Analytics, or Data Engineering. • 5+ years of experience leading technical teams and large-scale enterprise initiatives. • Proven experience delivering enterprise reporting and analytics solutions in financial services or similar regulated industries. • Strong understanding of SDLC, Agile methodologies, and DevOps practices. Technical Expertise Data Platforms • Oracle • AWS Redshift / Cloud Data Warehouses • SQL Server / PostgreSQL (preferred) ETL & Data Integration • Informatica • Airflow • Python • PL/SQL • API-based integrations Business Intelligence & Visualization • Tableau • Cognos Analytics • Power BI (preferred) Cloud & Modern Engineering • AWS / Azure • CI/CD Pipelines • GitHub / Bitbucket • Monitoring & Observability Platforms Data Architecture • Data Modeling • Star/Snowflake Schema Design • Data Lakes & Lakehouse Concepts • Metadata and Data Governance Leadership Competencies • Strategic thinking and execution • Strong stakeholder management • Excellent communication and presentation skills • Team development and succession planning • Problem-solving and decision-making • Ability to operate effectively in a global, matrixed organization • Influencing without authority and driving organizational change Preferred Qualifications • Experience supporting Finance, Revenue, AUM, Profitability, Performance Management, or Enterprise Reporting platforms. • Experience with Cognos Framework Manager, Tableau Enterprise Deployment, and Cloud Data Warehouse modernization. • Exposure to GenAI, Predictive Analytics, and AI-driven reporting solutions. • Experience managing globally distributed teams. Success Measures • Improved data platform reliability and performance. • Delivery of strategic modernization initiatives on time and within budget. • Increased self-service analytics adoption. • Enhanced stakeholder satisfaction and business value realization. • Reduction in technical debt, manual effort, and operational risk. • Development of high-performing engineering teams and succession pipelines. This version is aligned to the type of work your BIG, AUM, Finance Warehouse, Cognos, Tableau, Oracle/Redshift, and modernization programs currently support, while positioning the role at a strong AVP leadership level suitable for State Street Finance IT About State Street Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future. As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement