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

Location: India - Bengaluru
Department: Business Consulting

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 across banking, 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.

Key Competencies

• Strong analytical and problem-solving skills
• Attention to detail and data accuracy
• Structured approach to investigation and remediation
• Stakeholder management
• 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.