Senior Data Systems Analyst - Cloud Migration & ETL

Capgemini; Atlanta (GA); Ibrido; USD 86.000 - 105.000; Tempo pieno

Vantaggi offerti da questo lavoro

Paid time off

Health benefits

Retirement plan

Descrizione del lavoro

Capgemini is seeking a seasoned Business Systems Analyst to support data transformation and cloud migration initiatives across on-prem to cloud. You will bridge business stakeholders, data engineers, and technology partners, translating requirements into technical solutions and ensuring data quality.

You will create STTM documents, develop complex SQL queries, and collaborate with DWH teams on dimensional modeling and reporting.

Competenze

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

Mansioni

• 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 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 teams on dimensional modeling and data integration.
• Participate in SIT, UAT, and data validation testing.
• Produce functional specifications, process flows, gap analyses, and project docs.

Conoscenze

Source System Analysis

Source-to-Target Mapping

SQL

Data Warehousing

ETL/ELT

Cloud Migration

Requirements Gathering

Agile

Stakeholder Management

Communication Skills

Strumenti

AWS

Azure

Google Cloud

Descrizione del lavoro

Capgemini is seeking a seasoned Business Systems Analyst to support data transformation and cloud migration initiatives across on-prem to cloud. You will bridge business stakeholders, data engineers, and technology partners, translating requirements into technical solutions and ensuring data quality.

You will create STTM documents, develop complex SQL queries, and collaborate with DWH teams on dimensional modeling and reporting.