Senior Business Analyst

Quick Facts

Base compensation range (Hanover, NJ): $105,000 - $115,000

Description

This role gathers, analyzes, and documents business and data requirements from stakeholders, performing detailed data analysis to identify trends, anomalies, and business insights. You will analyze source-to-target mappings to document data lineage, develop business requirements including functional specifications and data dictionaries, and define data quality rules, validation processes, and reconciliation procedures. You will also support data migration, transformation, and integration initiatives, create and maintain dashboards, reports, and KPIs, and support UAT data validation and defect resolution while ensuring data governance, regulatory, and audit compliance.

Responsibilities

• Gather, analyze, and document business and data requirements from stakeholders
• Perform detailed data analysis to identify trends, anomalies, and business insights
• Analyze source-to-target data mappings and document data lineage
• Develop business requirements, functional specifications, and data dictionaries
• Work closely with Data Engineering, Data Governance, Technology and Business teams
• Define data quality rules, validation processes, and reconciliation procedures
• Support data migration, transformation, and integration initiatives
• Create and maintain dashboards, reports, and KPIs to support business decision-making
• Perform gap analysis and recommend process improvements
• Facilitate workshops with stakeholders to understand reporting and analytical needs
• Support User Acceptance Testing (UAT), including data validation and defect resolution
• Ensure compliance with data governance, regulatory, and audit requirements

Requirements

• Strong understanding of data analysis, data management, and reporting concepts
• Experience working with large and complex datasets
• Proven experience in requirements gathering and stakeholder management
• Strong problem-solving and analytical skills

Hard Skills and Technologies

• Data Analysis
• Advanced SQL
• Data Profiling
• Data Reconciliation
• Data Quality Analysis
• Data Lineage
• Root Cause Analysis
• Data Mapping

Benefits

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees.

• Paid time off based on employee grade (Vacation: 12-25 days depending on grade), company paid holidays, personal days, sick leave
• Medical, dental, and vision coverage
• Retirement savings plans (e.g., 401(k))
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility