Data Transformation Analyst: Cloud & SQL Expert

Capgemini; Jersey City (NJ); On-site; USD 86,000 - 105,000; Full time

Benefits offered by this job

Paid time off

Health coverage

Retirement plan

Life insurance

Employee assistance

Other benefits

Job summary

Capgemini in Jersey City, NJ (Onsite/Hybrid from Day 1) is seeking an accomplished Business Systems Analyst to support enterprise data transformation and cloud migration initiatives. The role focuses on source system analysis, source-to-target mapping, data warehousing concepts, and SQL-based data analysis, acting as a bridge between business stakeholders, data engineers, and technology partners.

You will work with DWH teams, validate data quality, develop complex SQL queries, and contribute to

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 analysis and validation.
• Solid understanding of Data Warehousing concepts, including dimensional modeling and ETL/ELT.
• 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.

Responsibilities

• Perform detailed source system analysis to understand data structures, business rules, and data lineage.
• Create and maintain 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 mapping on-premises data assets to cloud 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 and reporting requirements.
• Participate in SIT, UAT, and data validation efforts.
• Produce functional specifications, process flows, gap analyses, and other project documentation.

Skills

BSA

Source System Analysis

STTM

SQL

Data Warehousing

Cloud Migration

Agile

Communication

Job description

Capgemini in Jersey City, NJ (Onsite/Hybrid from Day 1) is seeking an accomplished Business Systems Analyst to support enterprise data transformation and cloud migration initiatives. The role focuses on source system analysis, source-to-target mapping, data warehousing concepts, and SQL-based data analysis, acting as a bridge between business stakeholders, data engineers, and technology partners.

You will work with DWH teams, validate data quality, develop complex SQL queries, and contribute to