Business System Analyst

Position Title :
Business Data Analyst (Underwriting / Risk / Actuarial Data) Location :
Cary, NC/ New Jersey, NJ (Onsite/Hybrid from Day
1) Experience : 8+ Years Employee Type :
Full Time with Benefits Job Description

We are seeking a highly skilled Business Systems Analyst (BSA) to support enterprise data transformation and cloud migration initiatives. The ideal candidate will have strong experience in source system analysis, source-to-target mapping, data warehousing concepts, and SQL-based data analysis. This role will serve as a bridge between business stakeholders, data engineering teams, and technology partners, ensuring accurate data migration from on-premises platforms to cloud environments.

• Perform detailed source system analysis to understand data structures, business rules, and data lineage.
• Create and maintain comprehensive Source-to-Target Mapping (STTM) documents for data migration and integration projects.
• Gather, analyze, and document business, functional, and data requirements.
• Partner with business stakeholders, data architects, and developers to translate requirements into technical solutions.
• Support cloud migration initiatives by analyzing and mapping on-premises data assets to modern cloud-based platforms.
• Validate data quality, transformation logic, and business rules throughout the migration lifecycle.
• Develop complex SQL queries for data analysis, validation, reconciliation, and reporting.
• Collaborate with Data Warehouse (DWH) teams to support dimensional modeling, data integration, and reporting requirements.
• Participate in testing activities, including SIT, UAT, and data validation efforts.
• Produce functional specifications, process flows, gap analyses, and other project documentation.

• 8+ years of experience as a Business Systems Analyst in data-centric projects.
• Strong expertise in Source System Analysis and Source-to-Target Mapping (STTM).
• Advanced SQL skills with the ability to write complex queries for analysis and validation.
• Solid understanding of Data Warehousing concepts
  , including dimensional modeling, fact and dimension tables, and ETL/ELT processes.
• Experience supporting cloud migration projects from on-premises environments.
• Strong requirements gathering, documentation, and stakeholder management skills.
• Experience working in Agile and Waterfall delivery environments.
• Excellent analytical, problem-solving, and communication skills.

• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Knowledge of data migration, data governance, and data quality frameworks.
• Experience in financial services, banking, or other highly regulated industries.
• Familiarity with data integration and reporting tools.

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

• Healthcare including dental, vision, mental health, and well-being programs
• Financial well-being programs such as 401(k) and Employee Share Ownership Plan
• Paid time off and paid holidays
• Paid parental leave
• Family building benefits like adoption assistance, surrogacy, and cryopreservation
• Social well-being benefits like subsidized back-up child/elder care and tutoring
• Mentoring, coaching and learning programs
• Employee Resource Groups
• Disaster Relief

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on…