Business System Analyst

Capgemini; Cary (NC); Hybrid; USD 100,000 - 150,000; Full time

Benefits offered by this job

Healthcare benefits

401(k) with ESOP

Paid time off

Paid parental leave

Adoption assistance

Social well-being benefits

Mentoring and learning programs

Employee Resource Groups

Disaster Relief

Job summary

Capgemini is seeking a highly skilled Business Data Analyst to support data transformation and cloud migration initiatives in Cary, NC (onsite/hybrid from Day 1). The role requires 8+ years as a Business Systems Analyst with strong STTM, SQL, and data warehousing expertise.

You will bridge business stakeholders with data engineers, validate data quality, and assist in migration from on-premises to cloud platforms. This is a full-time position with comprehensive benefits.

Qualifications

• 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 for data analysis, validation, and reporting.
• Solid understanding of Data Warehousing concepts, including dimensional modeling and ETL/ELT.
• Experience supporting cloud migration from on-premises to cloud environments.
• Strong requirements gathering, documentation, and stakeholder management skills.
• Experience working in Agile and Waterfall delivery environments.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Perform detailed source system analysis to understand data structures, rules and lineage.
• Create and maintain Source-to-Target Mapping (STTM) documents for migration projects.
• Gather, analyze, and document business, functional, and data requirements.
• Collaborate with stakeholders, data architects and developers to translate requirements.
• Support cloud migration by mapping on-premises data assets to cloud platforms.
• Validate data quality, transformation logic and business rules through migration lifecycle.
• Develop complex SQL queries for data analysis, validation, reconciliation and reporting.
• Partner with Data Warehouse teams for dimensional modeling and integration.
• Participate in SIT/UAT testing and data validation efforts.
• Produce functional specs, process flows, and gap analyses.

Skills

Source System Analysis

Source-to-Target Mapping

SQL

Data Warehousing

Cloud Migration

Requirements Gathering

Stakeholder Management

Agile/Waterfall

Data Quality & Validation

Data Modeling

Job description

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.

Key Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Life At Capgemini

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

Disclaimer

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 your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law