Self Service Reporting - Business Analyst, Officer

State Street; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Competitive benefits

Flexible work program

Educational support

Volunteer days

Employee networks

Job summary

State Street Corp. is seeking a seasoned professional to design, develop, and support reporting and dashboards for Alpha Services. You will perform end-to-end requirement analysis, validate data quality, and collaborate with data experts across teams.

The role emphasizes SQL optimization on Snowflake, data modeling, and BI reporting expertise to deliver insights for investment management services.

Qualifications

• Bachelor's degree in Business, Accounting, Finance, MIS, Information Technology, or related field.
• 8+ years of experience in analyzing, designing, and developing reports and dashboards using BI tools.
• Hands-on experience in data analysis and querying using Snowflake cloud data platform and writing complex SQL queries.

Responsibilities

• Design, develop and support reporting and dashboards for State Street Alpha Services.
• Perform end-to-end requirement analysis and support dashboards/reports.
• Develop data models and govern data quality across large financial datasets.

Skills

SQL

Data visualization

Snowflake

BI tools

Education

Bachelor's degree

Tools

Snowflake

Job description

State Street’s Alpha Services Client Reporting Team offers a full suite of reporting services required by the most sophisticated Investment Managers. We gather data from multiple sources internally and externally from - IBOR, ABOR, performance, market data vendors and client supplied data, which runs through a robust workflow to produce end client reports or provides insights via data visualization. We are a self-service report development team who has taken the initiative to meet the most complex reporting requirements for the entire bank.Individual in this role will participate in the design, development and support reporting and dashboard for State Street Alpha ServicesIndividual in this role will perform end to end Requirement analysis and support dashboards/reporting for State Street Investment Management Services.Expertise in analysis, design and implementation of reporting and visualization ( Dashboards) using BI suits like Jasper, Webfocus, Actuate, eSpreadsheet, etcExperience in working with large scale data warehouse solutions , data modeling and designing data martsExperience in data governess models and data quality implementation techniquesStrong knowledge of SQL and experience in query performance optimizationExperience working with complex data sets and implementing complex business logics to provide intelligence reporting solutions, perform data gap analysis on complex financial dataRequires intimate knowledge of Interactive Report Designer (IRD) and IBI WebFocusParticipate in projects in design, implementation and testing of dashboards/reports. Work with operations, client, and technology to deliver various projectsDevelop data and functional requirements and assist in the creation of related estimates and dashboards/reports using different source applicationsParticipate in information delivery and business intelligence strategy sessionsComplete data analysis, profiling, and data mappingsInterface with data experts, data sourcing resources and assist in the data validation process and write queriesAssist in the development the conceptual/logical data models with appropriate business contextsKnowledge in Big data platforms and cloud technologiesPerform data gap analysis on complex financial dataServe as a subject matter expert across the organization and assist users with adhoc dashboard/report construction queries and researching issues on existing data, query tools, and reportsEnsure project activity is customer focused, results oriented, performance driven, and in compliance with all applicable internal and external requirementsEmploy analytical, conceptual, and creative thinking skills to improve performanceSupport user training, documentation, and rolloutMaintain effective working relationships with organizational team and clientsQualificationsBachelor's degree in Business, Accounting, Finance, MIS, Information Technology, or related field of studyDemonstrated excellence in business writing, development of business process flow diagrams, making comparisons regarding current and future processes, and effective communication8+ years of experience analyzing, designing, and developing reports and dashboards using BI toolsHands-on experience in data analysis and querying using the Snowflake cloud data platform, including writing and optimizing complex SQL queries, working with large structured and semi-structured datasets, and validating data qualityAbility to analyze query execution, troubleshoot data issues, and improve query performance and compute efficiency in SnowflakeFamiliarity in Snowflake concepts such as virtual warehouses, databases, schemas, roles, stages, views, and secure data accessExpertise in designing and developing reports and dashboards using BI suitsAbility to articulate basic project methodology concepts using either SDLC or AgileAbility to analyze entity-relationship diagrams and logical data models to validate design against requirementsAbility to write SQL code for strong data analysis through queries, data profiling, and data validation exercisesFamiliarity with financial reporting, business intelligence, and data warehousing principlesUnderstanding of BI/reporting tool architecture, functions, and featuresExcellent oral and written communication skills for diverse audiences with excellent facilitationAbout State Street: Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary in location, but you may expect generous medical care, insurance and savings plans among other perks. You’ll have access to flexible Work Program to help you match your needs. And our wealth of development programs and educational support will help you reach your full potential.Inclusion, Diversity and Social Responsibility. We truly believe our employees’ diverse backgrounds, experiences and perspective are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients. We warmly welcome candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality. Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader. You will have tools to help balance your professional and personal life, paid volunteer days, matching gift programs and access to employee networks that help you stay connected to what matters to you.State Street is an equal opportunity and affirmative action employer. Discover more at StateStreet.com/careers.Interested in learning more about us? Visit our www.statestreet.com www.crd.com LinkedIn page: State Street on LinkedInAbout State StreetAcross 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/careersRead our CEO Statement