Senior Business Systems Analyst – Data & Cloud Migration

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

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.