Business Analyst – Sales Data

Crisil; New Jersey; On-site; USD 100,000 - 160,000; Full time

Job summary

Crisil seeks an experienced Business Analyst with Investment Banking sales data expertise to support a strategic data transformation for a global client. You will bridge business and technology teams, document current processes, gather requirements, and drive improvements.

Key focus areas include data mappings, benchmarking data, and revenue analytics using McLagan and Coalition datasets. Strong SQL, stakeholder collaboration, and Agile delivery are essential.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or related field.
• Experience as a Business Analyst in Investment Banking or Capital Markets.
• Hands-on experience with McLagan and Coalition datasets.
• Strong SQL for data analysis and validation.
• Experience in Agile delivery environments.
• Strong requirements gathering and stakeholder management.

Responsibilities

• Analyze and document existing sales data feeds, data lineage, mappings, and reporting processes.
• Gather, analyze, and document business requirements from stakeholders across Sales, Business Management, and Technology teams.
• Create and maintain business requirements, process flows, functional specifications, and data mapping documents.
• Act as the liaison between business users and development teams throughout the project lifecycle.
• Validate solutions to ensure business requirements are accurately implemented.
• Support testing, UAT, defect resolution, and implementation activities.
• Leverage McLagan and Coalition data to support sales performance, benchmarking, market share, and revenue analytics.
• Identify process improvement and automation opportunities to enhance data quality, efficiency, and reporting capabilities.
• Ensure data integrity through reconciliation, validation, and control processes.

Skills

SQL

Analytical thinking

Stakeholder management

Requirements gathering

Workshop facilitation

Agile delivery

Data analysis

Documentation

Data mapping

Education

Bachelor’s degree in Computer Science, Engineering, or related field

Tools

McLagan data

Coalition data

Job description

We are seeking an experienced Business Analyst with Investment Banking Sales Data expertise to join a strategic data transformation initiative for a global investment banking client. The successful candidate will bridge the gap between business stakeholders and technology teams, helping to analyze, document, enhance, and automate critical sales performance data processes.

The role requires deep understanding of industry benchmarking and revenue data from McLagan and Coalition, including data mappings, feed structures, reporting processes, and associated business workflows. The candidate will be responsible for documenting current-state processes, gathering and managing requirements, supporting implementation activities, and driving process improvement initiatives.

• Analyze and document existing sales data feeds, data lineage, mappings, and reporting processes.
• Gather, analyze, and document business requirements from stakeholders across Sales, Business Management, and Technology teams.
• Create and maintain business requirements, process flows, functional specifications, and data mapping documents.
• Act as the liaison between business users and development teams throughout the project lifecycle.
• Validate solutions to ensure business requirements are accurately implemented.
• Support testing, UAT, defect resolution, and implementation activities.
• Leverage McLagan and Coalition data to support sales performance, benchmarking, market share, and revenue analytics.
• Identify process improvement and automation opportunities to enhance data quality, efficiency, and reporting capabilities.
• Ensure data integrity through reconciliation, validation, and control processes.
• Bachelor’s degree in Computer Science, Engineering, or related field
• Strong Business Analyst experience within Investment Banking or Capital Markets.
• Hands-on experience working with McLagan and Coalition datasets, methodologies, and reporting.
• Solid understanding of sales/revenue benchmarking, market share, client wallet, and performance metrics.
• Experience documenting data feeds, source-to-target mappings, business rules, and data lineage.
• Strong requirements gathering, stakeholder management, and workshop facilitation skills.
• Ability to translate business requirements into functional and technical specifications.
• Experience partnering with development, data engineering, and reporting teams.
• Strong analytical and problem-solving skills with attention to detail.
• Proficiency in SQL for data analysis and validation.
• Experience working in Agile delivery environments.