Senior Business Analyst Investment Data Modernization & Cloud Transformation
Position Summary
We are seeking a Senior Business Analyst to play a critical role in our enterprise data modernization and cloud transformation initiative. This position will serve as the bridge between investment business teams, operations, finance, and technology, helping transform legacy investment data platforms into a modern, cloud-based data ecosystem.
The ideal candidate combines deep investment management domain expertise with experience delivering large-scale data and technology transformation initiatives. This individual understands how investment data flows across the investment lifecycle from underwriting and portfolio management through fund accounting, investor reporting, and analytics and can translate complex business requirements into scalable data solutions.
This role will partner closely with Data Engineering, Enterprise Architecture, Product Owners, and business stakeholders to design and implement modern data capabilities that improve operational efficiency, reporting, analytics, and decision-making.
Key Responsibilities
Business Analysis & Requirements Management
- Partner with front office, middle office, finance, accounting, operations, and technology teams to elicit, analyze, and document business and functional requirements.
- Lead discovery sessions to understand current-state business processes, pain points, and future-state operating models.
- Create business process maps, user stories, functional specifications, data requirements, and acceptance criteria.
- Facilitate workshops between business and technical teams to drive alignment and solution design.
Investment Data Modernization
- Support the modernization of investment data platforms by defining business requirements for cloud-based data architecture and enterprise data products.
- Analyze legacy investment systems and recommend improvements to simplify and standardize investment data.
- Define business rules governing investment data, fund accounting data, portfolio data, and investor reporting data.
- Collaborate with Data Engineering teams on data ingestion, transformation, integration, and consumption requirements.
- Support migration of investment data from legacy applications to modern cloud data platforms.
Cloud Transformation
- Partner with Cloud Engineering and Enterprise Data teams to support migration initiatives involving Azure, Snowflake, Databricks, Microsoft Fabric, or similar cloud technologies.
- Define source-to-target mappings for cloud data pipelines.
- Assist with data validation and reconciliation during migration activities.
- Participate in cloud solution design reviews to ensure business requirements are accurately represented.
- Support implementation of modern reporting and self-service analytics capabilities.
Data Governance & Data Quality
- Define critical business data elements and business glossary definitions.
- Document data lineage across front office, operations, accounting, and reporting platforms.
- Identify data quality issues and recommend remediation strategies.
- Partner with Data Governance teams to establish data standards, ownership, and stewardship.
- Develop business rules supporting Master Data Management (MDM) initiatives.
Testing & Delivery
- Develop business test scenarios and User Acceptance Testing (UAT) plans.
- Coordinate business validation activities for cloud migration releases.
- Validate data accuracy across legacy and target systems.
- Support Agile ceremonies including backlog refinement, sprint planning, and demonstrations.
Required Investment Management Domain Expertise
Candidates should possess strong knowledge of investment management business processes and investment data across one or more of the following areas:
Front Office
- Investment underwriting
- Deal pipeline management
- Portfolio monitoring
- Investment performance analysis
- Portfolio company financial analysis
- Investment lifecycle management
Middle Office & Operations
- Investment operations
- Transaction processing
- Position management
- Cash management
- Reconciliation
- Security master and reference data
- Investment data management
Fund Accounting
- NAV calculations
- Capital calls
- Distributions
- Waterfall calculations
- General ledger integrations
- Financial reporting
- Fund accounting operations
Investor Reporting
- LP reporting
- Quarterly reporting packages
- Investor statements
- Performance reporting
- Regulatory reporting
- Portfolio analytics
Required Experience
- 7+ years of Business Analysis experience within investment management, private equity, private credit, hedge funds, asset management, or alternative investments.
- Demonstrated experience supporting enterprise data modernization or digital transformation initiatives.
- Hands-on experience working directly with investment management datasets, including:
- Fund accounting
- Investment lifecycle
- Portfolio monitoring
- Investment performance
- LP reporting
- Portfolio company financials
- Investment reference data
- Experience documenting complex business processes and translating them into technical requirements.
- Experience working alongside Data Engineers, Data Architects, Software Engineers, and Product Managers.
Preferred Technical Skills
Data & Analytics
- SQL
- Data profiling and analysis
- Data mapping
- Data lineage
- Metadata management
- Data quality analysis
- Master Data Management (MDM)
Cloud Technologies
Experience supporting projects involving:
- Microsoft Azure
- Snowflake
- Databricks
- Microsoft Fabric
- Azure Data Factory
- Azure Data Lake
- Synapse Analytics
- REST APIs
- ETL/ELT pipelines
Business Analysis Tools
- Jira
- Azure DevOps
- Confluence
- Visio
- Lucidchart
- Excel (Advanced)
- Power BI
- Tableau
Preferred Investment Platforms
Experience with one or more of the following:
- Allvue
- eFront
- Investran
- Geneva
- Clearwater Analytics
- BlackRock Aladdin
- SS&C Advent
- Yardi Investment Suite
- Salesforce
- Microsoft Dynamics
Desired Competencies
- Strong understanding of investment data architecture and enterprise data models.
- Ability to translate complex investment workflows into scalable cloud solutions.
- Knowledge of data governance, data stewardship, and enterprise data management principles.
- Experience supporting cloud migration, legacy system modernization, or enterprise data warehouse implementations.
- Strong analytical and problem-solving skills with attention to detail.
- Excellent communication and stakeholder management skills across business and technology teams.
- Ability to manage multiple priorities in a fast-paced Agile environment.
Preferred Qualifications
- Bachelor's degree in Finance, Accounting, Economics, Information Systems, Computer Science, or a related discipline.
- Experience working within Agile or Scrum delivery teams.
- Experience supporting enterprise cloud transformation initiatives.
- Familiarity with data governance frameworks, investment data models, and enterprise architecture practices.
Ideal Candidate Profile
The ideal candidate is a strategic Business Analyst with deep investment management expertise and a passion for data transformation. They understand the full investment lifecycle from underwriting and portfolio management through fund accounting and investor reporting and have successfully partnered with business and technology teams to modernize investment data platforms.
They are equally comfortable discussing portfolio monitoring with investment professionals, defining fund accounting data requirements with finance teams, and collaborating with Data Engineers to design scalable cloud-based data solutions. Their ability to connect business strategy, investment operations, and modern data architecture makes them a key contributor to enterprise data modernization and cloud transformation initiatives.
Never miss an opportunity! Create an alert based on the job you applied for.
