Middle/Senior Data Analyst

At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world's most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same.

We are looking for a highly skilled Data Analyst with strong experience in ETL processes and data transformation. The ideal candidate will play a key role in ensuring data quality, managing migration activities, and supporting stakeholders with actionable insights. This position requires a mix of technical proficiency, analytical thinking, and excellent communication skills.

• Define, maintain, and distribute standard data templates for intake from various source systems
• Monitor and ensure consistency, quality, and compliance of incoming data from internal and external sources
• Design and document transformation rules to map source data to destination system requirements
• Perform rapid data consolidation and preliminary analysis using advanced Excel functions, Python scripts, VBA, or Power Query
• Conduct ad-hoc analysis to identify anomalies, gaps, and quality issues in source datasets
• Prepare clear reports and presentations summarizing findings, risks, and remediation recommendations
• Act as the primary data SME for multiple migration waves, ensuring accurate and smooth transitions
• Define and execute validation scripts/tests to confirm transformation and migration accuracy
• Investigate and resolve data-related defects during testing and post-migration phases
• Serve as the single point of contact for all data-related queries regarding structure, meaning, and content
• Collaborate with development teams, QA engineers, and stakeholders to facilitate data mapping and integration

• 3+ years as a Data Analyst, Business Analyst, or similar role with strong focus on data management and transformation
• Strong analytics experience with ETL tools (e.g., Talend, Apache NiFi, Python scripts)
• Knowledge of data transformation between relational and NoSQL databases
• Proficiency in Python or other scripting languages for automation of data migration tasks
• Familiarity with MongoDB query language
• Expert-level Excel skills (VLOOKUP/XLOOKUP, Pivot Tables, advanced formulas) and CSV processing
• Strong understanding of data modeling concepts and relational databases

Nice to have:

• Ability to write scripts (Python, VBA, SQL) for data cleaning and consolidation
• Previous experience in data migration projects

• We care about all our employees and want them to feel as comfortable as possible. That's why we offer them health insurance from the first days, regardless of the probationary period.
• The gift from the company - Christmas holidays from 25 December to 31 December.
• Сooperation with Superhumans center and Veteran HUB. Capgemini Engineering has supported the launch of psychological rehabilitation department of Superhumans. Our team also donnated over UAH prosthetics for three Ukrainian defenders. Currently, we support psychological counseling provided by the Veteran Hub, and we have implemented a internal policy making the company friendly to military and veterans with the assistance of the Hub.

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

#LI-IZ1