Application Development Business/Data Analyst-VP

State Street; Austin (TX); Hybrid; USD 120,000 - 203,000; Full time

Benefits offered by this job

401K with company match

Comprehensive insurance

Paid time off

Employee Assistance Program

Performance bonuses

Job summary

State Street is seeking a Senior Business/Data Analyst to define business and system requirements, facilitate user meetings, and document detailed specifications for data warehouse and data lake projects in the securities domain.

You will work in Agile environments, lead end-to-end SDLC, perform deep Oracle SQL and Databricks data analysis, and partner with development and operations teams to deliver robust reporting and analytics capabilities.

Qualifications

• Master's degree in IT or MBA with IT background preferred.
• Experience in investment banking and regulatory reporting is required.
• Strong Oracle SQL and data analysis skills for financial data.

Responsibilities

• Lead requirements gathering and document business/functional specs.
• Analyze processes, identify gaps, and propose improvements.
• Develop conceptual models and data workflows for current/future state.
• Create detailed requirement documents for OLAP/OLTP reporting.
• Communicate project details to diverse audiences; prepare user docs.
• Own end-to-end Agile SDLC and participate in design/QA reviews.
• Collaborate with data teams on data warehouse/lake migration to AWS.

Skills

Agile PO

SQL queries

Data analysis

Data warehouse

Data lake

Databricks

Oracle SQL

Investment Banking

Regulatory reporting

Communication

Education

Master's degree in IT or MBA with IT

Tools

Databricks

SQL tools

BI tools

AWS Cloud

Job description

Who We Are Looking For

Defines business/system requirements by facilitating user meetings and interviewing users, developing use cases, working with SQL queries and researching and resolving issues. Participates in business analysis by documenting very low-level specifications and preparing project documentation. Analyzes current processes and recommends solutions for improving/adding processes. Provides technical and business knowledge to various stakeholders. Working with multiple teams to get the required functionality done. Work with Development and Internal support teams on any ongoing Business and Technical issues. Working in Agile environment as an Agile PO and exposure working with other PO's is a must and work on Business and data analysis in coordination with the team and Business users.

Who We Are Looking For

Defines business/system requirements by facilitating user meetings and interviewing users, developing use cases, working with SQL queries and researching and resolving issues. Participates in business analysis by documenting very low-level specifications and preparing project documentation. Analyzes current processes and recommends solutions for improving/adding processes. Provides technical and business knowledge to various stakeholders. Working with multiple teams to get the required functionality done. Work with Development and Internal support teams on any ongoing Business and Technical issues. Working in Agile environment as an Agile PO and exposure working with other PO's is a must and work on Business and data analysis in coordination with the team and Business users. The target system is a data warehouse and data lake application used for various financial reporting and persisting various functional data which includes in-depth Business analysis, user/stakeholder JAD sessions with robust Data analytical skills under Oracle SQL and Databricks platforms within Securities lending business domain.

HYBRID:

This role has a 2-day persona- 2 days working in office and 3 days work from home.

Responsibilities

Technical Business/Data Analyst to provide support for new projects and ongoing business processes. Should be a hands-on Oracle and Databricks queries for deep data analysis and documentation. Candidate should have 10 to 12 years of experience in the investment/securities industry.

• Having previous experience working in an Agile team as an Agile PO will help succeed in this role.
• In-depth working knowledge on Datawarehouse and data lake for various Investment banking use cases will be a quick consideration.
• Having hands on application development experience in terms of data and various business use cases within securities lending domain and having worked in data migration efforts is highly preferable.

The candidate MUST be able to complete the following job responsibilities:

What You Will Be Responsible For

As an application development Business/Data Analyst you will perform the following job responsibilities

• Researching and gathering business/system requirements through the facilitation of end user meetings and user interviews
• Analyzing current processes to identify gaps and improvement opportunities and providing business solutions.
• Decomposing abstract and complex details/concepts into business and functional requirements that can be understood by the stakeholders (i.e. end users, developers, testers, etc.)
• Developing conceptual modeling and process workflows to illustrate current and future states
• Developing detailed business and functional requirement documents
• Experience working as a business analyst on financial service applications that deal with OLAP and OLTP systems and reporting associated with front-end trading and back end batch processes
• Communicating (verbal and written) project details and concepts to various audiences
• Preparing end user documentation and facilitating end user training
• Defining the business deployment strategy and facilitating the business deployments
• Leading the end-to-end Agile SDLC. Includes participating and directing as needed the entire project from initiation to implementation to ensure business objectives are met - this includes actively participating in technical design and architecture reviews and test case reviews, etc.
• Experience in agile teams is a must
• Should be very good in Oracle SQL queries and using SQL tools, exposure to various data analytical functions.
• Developing UI design requirements is a must
• Knowledge of depositories, custodians, counterparties, Market reference data sets is a must
• working experience of Data warehouse and data lake platforms is a must
• Working knowledge of any agile methodology is preferable.
• Working knowledge of any Business Intelligence tool for visualization is highly preferable.
• Working experience in cloud technologies and having worked on migration projects from on premises to public cloud (AWS) cloud is preferrable
• 8+ years of Investment Banking industry experience with regulatory reporting frameworks like Liquidity, SFTR experience is a must.

What We Value

• Having previous experience working in an Agile team as an Agile PO will help succeed in this role.
• In-depth working knowledge on Datawarehouse and data lake for various Investment banking use cases with regulatory reporting experience will be a quick consideration.
• Having hands on application development experience in terms of data and various business use cases within securities lending domain and having worked in data migration efforts is highly preferable.

Education & Preferred Qualifications

• Master's degree in business administration with IT background or Master of Science in Information Technology is preferred.

Are you the right candidate? Yes!

We truly believe in the power that comes from the diverse backgrounds and experiences our employees bring with them. Although each vacancy details what we are looking for, we don’t necessarily need you to fulfil all of them when applying. If you like change and innovation, seek to see the bigger picture, make data driven decisions and are a good team player, you could be a great fit.

Why this role is important to us

Our technology function, Global Technology Services (GTS), is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We’re driving the company’s digital transformation and expanding business capabilities using industry best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation.

We offer a collaborative environment where technology skills and innovation are valued in a global organization. We’re looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company.

Join us if you want to grow your technical skills, solve real problems and make your mark on our industry.

Salary Range

$120,000 - $202,500 Annual

The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.

Employees are eligible to participate in State Street’s comprehensive benefits program, which includes: our retirement savings plan (401K) with company match; insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages; paid-time off including vacation, sick leave, short term disability, and family care responsibilities; access to our Employee Assistance Program; incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans); and, eligibility for certain tax advantaged savings plans.

For a full overview, visit https://hrportal.ehr.com/statestreet/Home.

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

Job Application Disclosure

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Job ID: R-794662