S

State Street

Holds assets for institutions and runs index funds

Self Service Reporting - Business Analyst, Officer

Business IntelligenceConfirmed live in the last 24 hours
Full-timeBengaluru, Karnataka, IndiaNo salary listedIn-person

About the Job

Requirements

  • A bachelor's degree in Business, Accounting, Finance, MIS, Information Technology, or a related field of study.
  • At least 8 years of experience analyzing, designing, and developing reports and dashboards using business intelligence tools.
  • Hands-on experience analyzing data and querying the Snowflake cloud data platform, including writing and optimizing complex SQL queries, working with large structured and semi-structured datasets, and validating data quality.
  • Ability to analyze query execution, troubleshoot data issues, and improve query performance and compute efficiency in Snowflake.
  • Familiarity with Snowflake concepts including virtual warehouses, databases, schemas, roles, stages, views, and secure data access.
  • Expertise designing and developing reports and dashboards using business intelligence suites.
  • Ability to articulate basic project methodology concepts using either SDLC or Agile.
  • Ability to analyze entity-relationship diagrams and logical data models to validate designs against requirements.
  • Ability to write SQL code for data analysis through queries, data profiling, and data validation exercises.
  • Familiarity with financial reporting, business intelligence, and data warehousing principles.
  • Understanding of business intelligence and reporting tool architecture, functions, and features.
  • Demonstrated excellence in business writing and development of business process flow diagrams, and ability to compare current and future processes.
  • Excellent oral and written communication and facilitation skills for diverse audiences.

Responsibilities

  • Participate in the design, development, and support of reporting and dashboards for State Street Alpha Services.
  • Perform end-to-end requirements analysis and support dashboards and reporting for State Street Investment Management Services.
  • Analyze, design, and implement reporting and visualization dashboards using business intelligence suites such as Jasper, WebFOCUS, Actuate, and eSpreadsheet.
  • Work with large-scale data warehouse solutions, data modeling, and data mart design.
  • Work with data governance models and data quality implementation techniques.
  • Optimize SQL query performance.
  • Work with complex datasets and implement complex business logic for reporting solutions; perform data gap analysis on complex financial data.
  • Use Interactive Report Designer (IRD) and IBI WebFOCUS.
  • Participate in dashboard and report design, implementation, and testing projects; work with operations, clients, and technology teams to deliver projects.
  • Develop data and functional requirements, assist with estimates, and create dashboards and reports using different source applications.
  • Participate in information delivery and business intelligence strategy sessions.
  • Complete data analysis, profiling, and data mapping.
  • Interface with data experts and data sourcing resources, assist with data validation, and write queries.
  • Assist in developing conceptual and logical data models with appropriate business context.
  • Work with big data platforms and cloud technologies.
  • Serve as an organizational subject matter expert; assist users with ad hoc dashboard and report construction queries and research issues involving existing data, query tools, and reports.
  • Ensure project activity is customer-focused, results-oriented, performance-driven, and compliant with applicable internal and external requirements.
  • Support user training, documentation, and rollout.
  • Maintain effective working relationships with organizational teams and clients.

About the Company

State Street

Holds assets for institutions and runs index funds

State Street holds and services investments for pension funds, insurers, fund companies, and other large institutions, and it also runs index funds through State Street Investment Management. It launched the first US-listed exchange-traded fund, the SPDR S&P 500 ETF Trust, in 1993, and in 1924 it became custodian of the first US mutual fund. As a custody bank, it safekeeps clients' stocks and bonds, completes their trades, calculates what their funds are worth, and lends their securities to other investors. It earns fees on the assets it services and manages, plus income from currency trading and from interest on client cash. State Street traces its roots to a bank chartered in 1792 and is based in Boston, Massachusetts.

Company size
10,001+
Company stage
IPO
Headquarters
Boston, MA
Founded
1792

Recently Posted Jobs

Explore more opportunities at State Street

See more jobs