CI Master Data Associate

Capgemini; Maharashtra; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Capgemini in Maharashtra is hiring a CI Master Data Manager focused on hands-on data preparation and ongoing quality controls for commercial intelligence datasets. You will map sources, cleanse data, and standardise inputs across markets and channels, enabling reliable analytics and reporting with tools like Power BI, HIVE and Databricks.

You will work with Commercial Intelligence, RGM, and Data teams to ensure reference data, KPI reporting, and issue management are well-documented and aligned

Qualifications

• 3-4 years hands-on in master data, data operations, data quality or analytics support.
• Experience collecting, cleansing, standardising and validating multi-source data.
• Working knowledge of data repositories, metadata, mapping tables, KPI reporting and issue-management.

Responsibilities

• Identify and map internal/external data sources for commercial intelligence use cases and KPIs.
• Cleanse data to resolve errors, duplicates and inconsistencies; apply standard formats.
• Validate data changes and document quality issues with remediation steps.

Skills

Data quality

Master data mgmt

Excel

Power BI

SQL

Databricks

HIVE

Analytical thinking

Cross-functional collaboration

Tools

Power BI

HIVE

Databricks

SQL

Excel

Job description

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.Your RoleThe CI Master Data Manager CI & RGM is responsible for the hands-on preparation and maintenance of commercial intelligence data used across market, category, segment, brand, channel, customer, competitor, KPI and forecasting activities. The role ensures data from approved internal and external sources is collected, cleaned, standardised, validated and stored so that downstream analytics and reporting teams can access consistent and reliable information.Working with Commercial Intelligence and RGM teams, markets, Data and Technology teams, platform owners and third-party providers, the role supports source mapping, data onboarding, quality controls, issue resolution, dashboard inputs and documentation across HIVE, Databricks, MSS, Power BI and related environments. This is a hands-on individual-contributor role and does not require people leadership.In this Role you will play Key role inKey Accountabilities1. Data Requirements and Source MappingIdentify and document internal and external data sources aligned to commercial intelligence use cases and KPI needs.Assess source relevance, coverage, quality and gaps across markets, categories and channels.Maintain mapped repositories of approved local and central data inputs, ownership, refresh frequency and downstream usage.2. Data Collection, Cleansing and StandardisationCollect raw category, segment, brand, channel, trade, customer, competitor, KPI and forecasting data from approved sources.Clean data to resolve errors, duplicates, missing values and inconsistencies, and apply standard formats and transformation rules.Harmonise core dimensions including SKU, category, brand, segment, channel, customer, format and geography.Maintain validated datasets, input logs and structured files using standard templates.3. Data Validation and Quality ControlsRun systematic quality checks, reconciliations and feedback loops to validate accuracy, completeness, consistency and reliability.Validate data changes, enhancements and new inputs following defined testing and approval requirements.Document quality issues, evidence, corrective actions and resolution status.Escalate material or recurring defects to accountable data, technology or provider teams.Key Accountabilities1. Data Requirements and Source MappingIdentify and document internal and external data sources aligned to commercial intelligence use cases and KPI needs.Assess source relevance, coverage, quality and gaps across markets, categories and channels.Maintain mapped repositories of approved local and central data inputs, ownership, refresh frequency and downstream usage.2. Data Collection, Cleansing and StandardisationCollect raw category, segment, brand, channel, trade, customer, competitor, KPI and forecasting data from approved sources.Clean data to resolve errors, duplicates, missing values and inconsistencies, and apply standard formats and transformation rules.Harmonise core dimensions including SKU, category, brand, segment, channel, customer, format and geography.Maintain validated datasets, input logs and structured files using standard templates.3. Data Validation and Quality ControlsRun systematic quality checks, reconciliations and feedback loops to validate accuracy, completeness, consistency and reliability.Validate data changes, enhancements and new inputs following defined testing and approval requirements.Document quality issues, evidence, corrective actions and resolution status.Escalate material or recurring defects to accountable data, technology or provider teams.Your Profile3-4 years of hands-on experience in master data, commercial data operations, data quality, business intelligence or analytics support.Practical experience collecting, cleansing, standardising, validating and consolidating multi-source commercial data.Working knowledge of data repositories, data models, metadata, mapping tables, KPI reporting and issue-management processes.Strong Excel capability; working exposure to Power BI, HIVE, Databricks, SQL or comparable data and reporting platforms preferred.Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.Make it real | www.capgemini.com