Senior Data Warehouse & Cloud Migration Analyst

Capgemini; Cary (NC); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Capgemini in Cary, NC is seeking a senior Business Systems Analyst (BSA) to drive data warehouse modernization and cloud migration initiatives. You will bridge business and technical teams, gathering requirements and documenting data flows across source systems, warehouses, and cloud platforms.

The role emphasizes source data analysis, data mapping, data quality, and UAT support, with collaboration from data engineers and architects to design scalable solutions.

Qualifications

• 10+ years of experience as a Business Systems Analyst, Business Analyst, or related role.
• Strong expertise in: SQL
• Data Warehousing
• Source Data Analysis
• Data Mapping
• Requirements Gathering and Documentation.
• Experience supporting large-scale cloud migration initiatives.
• Strong understanding of data models, ETL/ELT processes, and data integration concepts.
• Ability to work effectively with both business stakeholders and technical teams.
• Excellent analytical, communication, and documentation skills.

Responsibilities

• Partner with business stakeholders, data teams, and technology teams to gather and document business and system requirements.
• Perform detailed source data analysis, data profiling, and data lineage assessments.
• Lead data mapping activities between source systems, data warehouses, and cloud platforms.
• Analyze and document functional and technical requirements for data integration and migration initiatives.
• Support cloud migration projects, ensuring data quality, completeness, and business rule validation.
• Collaborate with Data Engineers, Architects, and Developers to design scalable data solutions.
• Create business process flows, data dictionaries, mapping documents, and requirement specifications.
• Validate data transformations and support testing activities, including UAT.
• Identify risks, dependencies, and data quality issues and recommend mitigation strategies.
• Act as a liaison between business users and technical teams throughout the project lifecycle.

Skills

SQL

Data Warehousing

Source Data Analysis

Data Mapping

Requirements Gathering

Documentation

Cloud Migration

Tools

AWS

Azure

GCP

Job description

Capgemini in Cary, NC is seeking a senior Business Systems Analyst (BSA) to drive data warehouse modernization and cloud migration initiatives. You will bridge business and technical teams, gathering requirements and documenting data flows across source systems, warehouses, and cloud platforms.

The role emphasizes source data analysis, data mapping, data quality, and UAT support, with collaboration from data engineers and architects to design scalable solutions.