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 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 control