Data Governance- Senior Consultant – BigID/ Collibra /Onetrust / Data Remediation & Analytics

Capco Group

Bengaluru

On-site

INR 3,600,000 - 6,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Capco, a Wipro company, invites applications for the Senior Consultant – BigID/Collibra/Onetrust / Data Remediation & Analytics role in Bengaluru. The candidate will drive data discovery, remediation, and analytics across enterprise systems, collaborating with business, data, privacy, and technology teams.

We seek 7–10 years of experience in data management, strong BigID expertise, SQL, DBMS concepts, and Advanced Excel.

Qualifications

  • 7–10 years of experience in data management, data analytics, data remediation, data privacy, data governance or related areas.
  • Hands‑on experience or strong working knowledge of BigID.
  • Strong understanding of DBMS concepts and relational databases.
  • Strong SQL skills for querying, reconciliation, profiling, and data‑quality analysis.
  • Strong proficiency in Advanced Excel for data analysis and reconciliation.
  • Strong data analytics and problem‑solving capabilities.
  • Experience with large and complex datasets and data quality issues.
  • Ability to perform root-cause analysis and translate findings into remediation actions.
  • Understanding of data discovery, data classification, data lineage, sensitive data and remediation concepts.
  • Ability to translate technical findings into clear business language and communicate with stakeholders.

Responsibilities

  • BigID data discovery, classification, inventory and analysis across data sources.
  • Review BigID findings and validate sensitive and critical data.
  • Support onboarding and validation of data sources within BigID.
  • Perform data profiling and data reconciliation.
  • Write SQL queries to analyze data and validate remediation.
  • Prepare evidence and reporting for governance, risk, privacy and audit requirements.
  • Collaborate with data owners and stakeholders to validate findings and remediation actions.

Skills

BigID
DBMS
SQL
Advanced Excel
Data Analytics

Tools

Power BI

Job description

Data Governance- Senior Consultant – BigID/ Collibra /Onetrust / Data Remediation & Analytics

About Us

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount . With our presence across 32 cities across globe, we support 100+ clients acrossbanking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

Hi,

Please find the JD below-

Senior Consultant – BigID/Collibra/Onetrust / Data Remediation & Analytics

Experience: 7–10 Years
Role Level: Senior Consultant
Domain: Data Management / Data Privacy / Data Remediation
Key Skills: BigID, DBMS, SQL, Advanced Excel, Data Analytics

Role Overview

We are looking for an experienced Senior Consultant to support a BigID-driven data discovery, analysis, and remediation program. The candidate will work with business, data, technology, privacy, and remediation teams to identify sensitive and critical data across enterprise systems, analyze data-quality and privacy-related findings, and drive issues through remediation and closure.

The ideal candidate should have strong hands‑on knowledge of BigID, relational databases/DBMS, SQL, Advanced Excel, and data analytics, along with the ability to analyze large datasets, identify anomalies and trends, perform reconciliations, and translate findings into actionable remediation activities.

Key Responsibilities

BigID & Data Discovery

  • Work with BigID to support data discovery, classification, inventory, and analysis across structured and unstructured data sources.
  • Review BigID scan results and analyze identified sensitive, personal, confidential, and critical data.
  • Support onboarding and validation of data sources within BigID.
  • Analyze BigID findings to identify data requiring further investigation or remediation.
  • Work with application owners and data owners to validate findings and resolve exceptions.
  • Track identified issues through remediation, validation, and closure.
  • Support preparation of evidence and reporting for governance, risk, privacy, and audit requirements.

Database & SQL Analysis

  • Demonstrate strong understanding of DBMS concepts, relational databases, tables, keys, relationships, and data structures.
  • Write SQL queries to extract, analyze, reconcile, and validate data.
  • Perform data profiling and identify missing, duplicate, inconsistent, invalid, or anomalous records.
  • Perform source-to-target and cross-system data reconciliation.
  • Use joins, aggregations, subqueries, CTEs, CASE statements, and other SQL techniques for data investigation.
  • Validate data before and after remediation to confirm successful closure of identified issues.

Data Remediation

  • Analyze data issues identified through BigID scans, business controls, or data-quality assessments.
  • Perform root‑cause analysis and help determine appropriate remediation actions.
  • Define impacted populations and remediation rules in collaboration with business and technology stakeholders.
  • Perform pre‑ and post‑remediation validation and reconciliation.
  • Maintain appropriate documentation, evidence, exception logs, and audit trails.
  • Track remediation actions, dependencies, risks, and outstanding issues to closure.

Excel & Data Analytics

  • Use Advanced Excel for large-scale data analysis, reconciliation, validation, and reporting.
  • Strong working knowledge of Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, conditional formatting, logical functions, data cleansing, and reconciliation techniques.
  • Analyze large datasets to identify trends, patterns, exceptions, and data-quality issues.
  • Create management information (MI), dashboards, and remediation progress reports.
  • Translate complex datasets into clear insights for business and senior stakeholders.

Stakeholder & Project Management

  • Collaborate with data owners, application owners, technology teams, privacy teams, risk teams, and business stakeholders.
  • Facilitate discussions to understand data issues and agree on remediation actions.
  • Track actions, risks, issues, dependencies, and milestones.
  • Provide regular progress updates and management reporting.
  • Support junior team members and provide guidance on data analysis and remediation activities.
  • Ensure deliverables are completed with appropriate quality controls and within agreed timelines.

Required Skills & Experience

  • 7–10 years of overall experience in data management, data analytics, data remediation, data privacy, data governance, or related areas.
  • Hands‑on experience or strong working knowledge of BigID.
  • Strong understanding of DBMS and relational database concepts.
  • Strong hands‑on SQL skills for querying, reconciliation, profiling, and data-quality analysis.
  • Strong proficiency in Advanced Excel.
  • Strong data analytics and problem‑solving capabilities.
  • Experience working with large and complex datasets.
  • Experience in identifying and investigating data‑quality issues and performing root‑cause analysis.
  • Understanding of data discovery, data classification, data lineage, sensitive data, and data remediation concepts.
  • Ability to translate technical findings into clear business language.
  • Strong stakeholder management and communication skills.
  • Ability to independently manage assigned workstreams and drive issues through to closure.

Preferred Skills

  • Experience working on BigID implementation, data discovery, privacy, or remediation programs.
  • Experience within Banking, Financial Services and Insurance (BFSI) or other highly regulated industries.
  • Understanding of data privacy and protection principles and regulatory requirements.
  • Knowledge of data governance, metadata management, data lineage, and data‑quality frameworks.
  • Experience creating dashboards and management reporting using Excel, Power BI, or similar analytics tools.
  • Exposure to Agile/project delivery environments would be beneficial.
  • Strong analytical and problem‑solving skills
  • Attention to detail and data accuracy
  • Structured approach to investigation and remediation
  • Strong written and verbal communication
  • Ability to work independently and within cross‑functional teams
  • Ownership and accountability for deliverables
  • Ability to manage multiple priorities and deadlines

Expected Outcome of the Role

The Senior Consultant will play a key role in converting BigID data‑discovery findings into actionable insights and remediation activities, ensuring that identified data issues are accurately analyzed, appropriately remediated, validated, documented, and reported to relevant stakeholders.

If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Associate - Project Management Office (Risk and Engagement Operations) in Data and Analytics
Senior Associate - Project Management Office (Risk and Engagement Operations) in Data and Analytics

PriceWaterhouseCoopers Pvt Ltd ( PWC ) • Bengaluru

On-site
INR 1,500,000 - 2,300,000
Lead Big Data Engineer
Lead Big Data Engineer

Capco • Pune District

On-site
INR 2,500,000 - 4,000,000
Data Governance Senior Developer
Data Governance Senior Developer

Promaynov Advisory Services Pvt. Ltd • Bengaluru

On-site
INR 1,500,000 - 2,500,000
Data Governance Consultant
Data Governance Consultant

VMC Soft Technologies • Hoskote

On-site
INR 3,500,000 - 5,500,000
Data Privacy Consultant
Data Privacy Consultant

Capco • Pune District, Bengaluru

On-site
INR 1,200,000 - 1,800,000
Senior Data Governance - Data Governance Specialist - SC - CDO - Data Support (pipeline)
Senior Data Governance - Data Governance Specialist - SC - CDO - Data Support (pipeline)

Capco • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Big Data Developer
Big Data Developer

Mployee.me • Pune District

On-site
INR 2,400,000 - 4,000,000
IN_Senior Associate_ Data Governance, Data Quality and data Catalog Governance_D&A_Advisory_Gurugram
IN_Senior Associate_ Data Governance, Data Quality and data Catalog Governance_D&A_Advisory_Gurugram

PwC • Gurugram District

On-site
INR 1,200,000 - 1,800,000
Senior Business Analyst - Cloud Security and Engineering
Senior Business Analyst - Cloud Security and Engineering

Capco Technologies Pvt Ltd • Bengaluru

On-site
INR 1,400,000 - 2,400,000
Mid Business Analysis - Data Privacy
Mid Business Analysis - Data Privacy

Capco • Bengaluru, Chennai

On-site
INR 1,500,000 - 2,100,000