Alpha Data Implementation Business Analyst- Assistant Vice President

STATE STREET CORPORATION; Burlington (MA); Hybrid; USD 80,000 - 140,000; Full time

Benefits offered by this job

401(k) with company match

Medical, dental, vision benefits

Paid time off

Job summary

State Street is seeking an Implementation Business Analyst to help integrate client data services across front, middle, and back office data platforms. You will collaborate with clients and Architecture leads to articulate requirements, map reference data, and drive data ingestion standards.

The role emphasizes data governance, ETL/ELT processes, and ensuring data quality throughout the lifecycle from ingestion to reporting, in a fast-paced, global environment.

Qualifications

• Bachelor’s degree or higher in Finance, Accounting, Computer Science, Information Systems, or a related discipline.
• 5+ years of experience with investment accounting, portfolio management, or financial data across asset classes.
• Experience with software implementation projects, data onboarding, or enterprise data services in financial services.
• Strong understanding of investment management operating models and data lifecycle from front office to accounting.

Responsibilities

• Support integration of new data services by gathering requirements, testing, and supporting features in scaled agile teams.
• Lead client workshops to elicit, document, and prioritize business, functional, and data requirements.
• Define and maintain standards for data ingestion, enrichment, and validation of client portfolio data.

Skills

SQL

ETL/ELT

Data governance

Agile

JIRA/Azure DevOps

Education

Bachelor’s degree or higher in Finance, Accounting, Computer Science, Information Systems

Tools

Power BI

Tableau

ThoughtSpot

Snowflake

Databricks

Job description

What we are looking forState Street Alpha Data Implementation organization is seeking individuals with subject matter expertise spanning a wide array of financial instrument types and working knowledge of Asset Management Data Domains to join our team as an Implementation Business Analyst.Why is this role importantImplementation Business Analysts are at the heart of continued growth of our Alpha Data Services offering. These energetic, self-motivated individuals collaborate with clients and Business, Data and Technology Solution Architecture leads at State Street and Charles River on a daily basis to articulate business requirements, navigate dependencies and drive innovative enhancements that empower our architecture to support new and more robust Front, Middle and Back Office managed data services - allowing our clients to focus on generating revenue for their core business.What your responsible forContribute to the integration of new data services and sources by participating in requirement gathering, testing and support of newly developed features as part of the Product’s scaled agile teams.Work as a member of the Client Implementation Team with the Development teams as well as the Project Manager to help establish project delivery plans and delivery estimates for projects involving integration of client middle or back-office data.Guide Clients on required reference data and other setups and mapping as part of initial client implementations.Define and maintain standards around data ingestion, enrichment and validation of client portfolio data into our Enterprise Data Management solution.Perform in-depth analysis of the functional capabilities inherent to our existing and emerging data platform.Document product specifications and prepare business cases to drive development in scaled agile rooms.Capture on-going enhancements to scope of services for existing clients as needed into roadmap.Create and maintain client facing documentationMaintain an excellent working knowledge of the service offering to perform Subject Matter Expert activities: consultancy, implementation configuration and demonstrations.Education and Preferred QualificationsBachelor's degree or higher in Finance, Accounting, Computer Science, Information Systems, or a related discipline.5+ years of experience working with investment accounting, portfolio management, investment operations, or financial data across asset classes including Fixed Income, Equities, Derivatives, Forwards, Futures, Cash, Positions, Settlements, General Ledger, NAV, Corporate Actions, Pricing, and Benchmark data.Experience supporting software implementation projects, data onboarding initiatives, platform migrations, or enterprise data services programs within the financial services industry.Good understanding of investment management operating models and the lifecycle of investment data from front office through accounting, performance, reporting, and downstream consumers.Proven experience conducting client workshops and requirements gathering sessions to elicit, document, validate, and prioritize business, functional, and data requirements.Strong data analysis and data mapping skills, including creation of source-to-target mappings, transformation rules, data dictionaries, business rules, and cross-reference documentation.Experience with ETL/ELT processes, data ingestion frameworks, and data integration solutions used to acquire, transform, and load data between systems.Ability to analyze source system data structures and reconcile data between upstream platforms, operational systems, and target data warehouses.Experience performing data profiling, root-cause analysis, data quality assessments, exception resolution, and reconciliation activities.Understanding of data governance concepts including data quality, metadata management, data cataloging, lineage, stewardship, controls, and ownership.Strong understanding of relational data models, dimensional data modeling concepts, and data warehouse architectures including fact and dimension structures.Knowledge of security master, reference data, benchmark data, pricing data, corporate actions, positions, transactions, and performance measurement data domains.Familiarity with data lineage, traceability, impact analysis, and end-to-end data flow documentation.Working knowledge of data structures and data models within investment platforms such as Aladdin, CRIMS, Charles River, Eagle, or other Front Office and Investment Management platforms.Strong SQL skills with the ability to write complex queries, joins, aggregations, reconciliation queries, and validation scripts.Experience working with structured and semi-structured data formats including SQL tables, CSV, XML, JSON, and Parquet.Exposure to cloud-based data and analytics platforms such as Snowflake, Databricks, AWS, Azure, or Google Cloud.Familiarity with reporting and business intelligence tools such as Power BI, Tableau, ThoughtSpot, or similar platforms.Understanding of API-based integrations, file-based interfaces, data exchange patterns, and system integration concepts.Experience supporting System Integration Testing (SIT), User Acceptance Testing (UAT), parallel testing, data validation, and production readiness activities.Understanding of conversion, migration, cutover, and implementation activities associated with large-scale data onboarding programs.Strong communication and stakeholder management skills, with the ability to translate technical concepts into business language and vice versa.Experience working in Agile delivery environments utilizing tools such as JIRA, Rally, Azure DevOps, or similar platforms.Highly detail-oriented with a strong sense of ownership, accountability, and follow-through.Proficient in Microsoft Office tools including Excel, Word, PowerPoint, and Visio.Team-oriented and comfortable working in a collaborative, global environment with clients, vendors, and cross-functional teams.Self-motivated, adaptable, and capable of managing multiple priorities in a fast-paced environment. About State StreetWhat we do. State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world. From technology to product innovation we're making our mark on the financial services industry. For more than two centuries, we've been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing, data & analytics, investments research & trading and investment management to institutional clients.Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary in locations, but you may expect generous medical care, insurance and savings plans among other perks. You'll have access to flexible Work Program to help 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, experience 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 the 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 program 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 www.StateStreet.com/careersSalary Range:$80,000 - $140,000 AnnualThe 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 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 StatementJob 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.