Business Systems Analyst - Data Warehouse & Cloud Migration

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

Position Title : Business Systems Analyst - Data Warehouse & Cloud Migration

Location : Cary, NC (Onsite/Hybrid from Day 1)

Experience : 8+ Years

Employee Type : Full Time with Benefits

Job Description

We are seeking a highly experienced Business Systems Analyst (BSA) to support enterprise data initiatives, including source data analysis, data mapping, data warehouse modernization, and cloud migration projects. The ideal candidate will bridge business and technical teams, gathering requirements, analyzing complex data ecosystems, and ensuring successful delivery of data-driven solutions.

Candidates with 10+ years of experience are preferred; however, we will consider professionals with fewer years of experience who bring strong domain expertise in Actuarial, Risk Management, or Underwriting environments.

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

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

Preferred Qualifications

• Experience in Actuarial, Risk, or Underwriting domains within the Insurance industry.
• Knowledge of cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP).
• Familiarity with data governance, data quality, and master data management practices.
• Experience working in Agile/Scrum environments.