Business Analyst (Data Migration)

Job DescriptionWe 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 & WorkshopsSupport workshops with business users to:Document legacy data, screens, and reportsIdentify data cleansing needsDefine data mappings (As-Is to To-Be)Capture transformation rules and business logicClarify requirements and maintain proper documentation and traceability2. Functional CollaborationWork with Functional Consultants to:Support data field mapping and validationAssist in defining migration approachesSupport UAT activities:Prepare test scenarios and datasetsTrack defects and follow up on resolutions3. Data Migration SupportPerform data profiling and basic analysisIdentify data quality issues (missing, inconsistent, duplicates)Assist in defining cleansing rules and transformation logicSupport testing and validation of migration scripts and outputs4. DocumentationPrepare and maintain: Source-to-Target Mapping (STTM) Data cleansing and transformation specifications Workshop notes and requirementsEnsure clarity, accuracy, and alignment with standards5. Data Validation & TestingSupport data validation and reconciliation checksTrack and resolve defects during testingEnsure accuracy and completeness of migrated dataJob RequirementsEducation & ExperienceBachelor’s degree in Information Systems, Computer Science, Business, or related fieldFresh graduates or up to 3 years’ experience in: Data migration, data analysis, or software development Business analysis in IT projectsTechnical SkillsBasic understanding of: Data migration concepts (ETL, mapping, cleansing, transformation) Databases and SQLExposure to tools such as Excel, SQL, or ETL tools (e.g., Azure Data Factory is a plus)Ability to analyze and interpret datasetsSoft SkillsStrong communication and interpersonal skillsGood documentation and organization skillsAttention to detail and accuracyProactive team player with willingness to learnDesirableKnowledge of Salesforce data migration and Azure tools (ADF, Databricks, Airflow)Familiarity with data migration practices (mapping, cleansing, masking, reconciliation)Understanding of public sector processesLet's talk about 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.As "Architects of Positive Futures", Capgemini actively supports the community in 3 ways: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 their gender identity, ethnicity, sexual orientation, religion, ability, intersex status or age. To support our commitment to diversity and inclusion, we celebrate special events and days of significance that are important to our employees such as Diwali, Bastille Day, Pride, IDAHOBIT, IWD and International day of people with Disabilities. Our 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 are focusing 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. Embedded in our DNA, our seven values - Honesty, Boldness, Trust, Team Spirit, Freedom, Fun and Modesty - have remained the same since company inception in 1967. To see how we bring these values to life, click here to listen to some of our employee’s 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.