Business Analyst (Data Migration)

Job Description

We are seeking a motivated Data Migration Business Analyst to support public sector transformation initiatives. This role is ideal for fresh graduates or candidates with up to 3 years of experience in data, development, or information systems.

You will work within a Data Migration team alongside business users, functional consultants, and technical teams to support end-to-end migration from legacy systems. The role offers hands-on exposure to data analysis, requirements gathering, and testing under the guidance of a Data Migration Lead.

1. Requirements Gathering & Workshops

• Support workshops with business users to:
  • Document legacy data, screens, and reports
  • Identify data cleansing needs
  • Define data mappings (As-Is to To-Be)
  • Capture transformation rules and business logic
• Clarify requirements and maintain proper documentation and traceability

2. Functional Collaboration

• Work with Functional Consultants to:
  • Support data field mapping and validation
  • Assist in defining migration approaches
• Support UAT activities:
  • Prepare test scenarios and datasets
  • Track defects and follow up on resolutions

3. Data Migration Support

• Perform data profiling and basic analysis
• Identify data quality issues (missing, inconsistent, duplicates)
• Assist in defining cleansing rules and transformation logic
• Support testing and validation of migration scripts and outputs

4. Documentation

• Prepare and maintain:
  • Source-to-Target Mapping (STTM)
  • Data cleansing and transformation specifications
  • Workshop notes and requirements
• Ensure clarity, accuracy, and alignment with standards

5. Data Validation & Testing

• Support data validation and reconciliation checks
• Track and resolve defects during testing
• Ensure accuracy and completeness of migrated data

Job Requirements

Education & Experience

• Bachelor’s degree in Information Systems, Computer Science, Business, or related field
• Fresh graduates or up to 3 years’ experience in:
  • Data migration, data analysis, or software development
  • Business analysis in IT projects

Technical Skills

• Basic understanding of:
  • Data migration concepts (ETL, mapping, cleansing, transformation)
  • Databases and SQL
• Exposure to tools such as Excel, SQL, or ETL tools (e.g., Azure Data Factory is a plus)
• Ability to analyze and interpret datasets

Soft Skills

• Strong communication and interpersonal skills
• Good documentation and organization skills
• Attention to detail and accuracy
• Proactive team player with willingness to learn

Desirable

• Knowledge of Salesforce data migration and Azure tools (ADF, Databricks, Airflow)
• Familiarity with data migration practices (mapping, cleansing, masking, reconciliation)
• Understanding of public sector processes

 

What’s in it for you

Passionate people are Capgemini's Ace of Spades—join us to discover a career that will challenge, support, and inspire you. Working at Capgemini you’ll find the rewards are more than just financial. You will work alongside some very smart and inspiring people on exciting projects, and you will also enjoy incredible benefits. We offer flexible work practices and 40 hours of self-development every year with a huge selection of learning opportunities to choose from.

Our Values & Inclusion

Diversity and Inclusion

We believe diversity of thought fuels excellence and innovation, which is why we positively encourage applications from suitably qualified candidates regardless of gender identity, ethnicity, sexual orientation, religion, ability, intersex status, or age. We celebrate special events and days of significance important to our employees, such as Diwali, Bastille Day, Pride, IDAHOBIT, IWD, and International Day of People with Disabilities. Employee Resource Groups Women@Capgemini and OutFront support the grassroots passion of employees to drive our diversity agenda and effect change.

Digital Inclusion

At Capgemini we are using our skills to drive social impact initiatives focusing on helping society address the impact of the digital and automation revolution. We also provide employees with opportunities to give back to the community through charity projects and volunteer days.

Environmental Sustainability

Capgemini joined the CDP's (Carbon Disclosure Project) prestigious 'A list' for its commitment to the Net-Zero economy. We focus on helping our clients transform towards more sustainable business models and committing to reduce our own carbon emissions (GHG) by 20% per employee by 2020.

Recognized by Ethisphere as one of the World's Most Ethical Companies for the last 8 years in a row, ethics and values are at the heart of Capgemini's corporate culture and business. Our seven values—Honesty, Boldness, Trust, Team Spirit, Freedom, Fun, and Modesty—have remained the same since the company’s inception in 1967. To see how we bring these values to life, listen to some of our employees’ stories.

Come join us, bring your whole self to work, create new possibilities for you, your customers, and your community, and help us to be Architects of Positive Futures.