Data Analyst

Capco; Kolkata Metropolitan Area; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Capco, a Wipro company, is seeking a detail-oriented Data Analyst to support enterprise data initiatives by ensuring high-quality, standardized data across business systems. The role covers data cleansing, data quality assessment, data conformance, and data profiling in collaboration with business and technical teams.

Key work includes monitoring data quality metrics, creating dashboards, and driving data governance initiatives with stakeholders to improve data reliability and compliance across

Qualifications

• Bachelor's degree in CS, IS, data analytics, statistics, or related field.
• 3+ years in data analysis, data quality, or data governance.
• Strong SQL skills for data extraction, validation, and analysis.
• Experience with data profiling and data quality tools.
• Experience with BI tools (Power BI, Tableau, Excel).

Responsibilities

• Data cleansing to identify inconsistencies, duplicates, and missing values.
• Implement data correction and remediation processes.
• Monitor and report data quality metrics and KPIs.
• Define and enforce data quality standards and controls.
• Collaborate with stakeholders to resolve data anomalies and governance needs.

Skills

SQL

Data profiling

Data governance

ETL concepts

BI tools (Power BI/Tableau/Excel)

Analytical thinking

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, or related field

Tools

Informatica DQ

Ataccama

Talend

Collibra

IBM Information Analyzer

Job description

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.

Job Title: Data Analyst

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.

Job Description

Data Analyst – Data Cleansing, Data Quality & Data Conformance

Job Summary

We are seeking a detail-oriented Data Analyst to support enterprise data initiatives by ensuring high-quality, accurate, and standardized data across business systems. The role involves data cleansing, quality assessment, data conformance, validation, profiling, and collaborating with business and technical teams to improve data integrity and governance.

Key Responsibilities

Data Cleansing

• Analyze and identify data inconsistencies, duplicates, missing values, and inaccurate records.
• Perform data cleansing, standardization, and enrichment activities.
• Develop and implement data correction and remediation processes.
• Establish data cleansing rules and validation checks to improve data accuracy.

Data Quality Management

• Monitor, measure, and report data quality metrics and KPIs.
• Conduct data profiling and root cause analysis for data quality issues.
• Define and implement data quality standards, controls, and monitoring mechanisms.
• Collaborate with business stakeholders to resolve data anomalies and improve data reliability.
• Support data governance initiatives and compliance requirements.

Data Conformance & Standardization

• Ensure data adheres to enterprise standards, business rules, and regulatory requirements.
• Map and transform data from multiple source systems into standardized formats.
• Validate conformance with master data definitions, reference data, and metadata standards.
• Support data migration, integration, and system implementation projects by ensuring data consistency.

Analysis & Reporting

• Perform data analysis to identify trends, anomalies, and opportunities for improvement.
• Create dashboards and reports to track data quality performance.
• Provide actionable recommendations based on data findings.
• Communicate analysis results to business and technical stakeholders.

Stakeholder Collaboration

• Work closely with Data Governance, Business Analysts, Data Engineers, and Product Owners.
• Participate in data quality improvement initiatives and governance forums.
• Document data quality issues, business rules, and remediation actions.

Required Skills & Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, or related field.
• 3+ years of experience in Data Analysis, Data Quality, or Data Governance.
• Strong SQL skills for data extraction, validation, and analysis.
• Experience with data profiling and data quality tools (Informatica DQ, Ataccama, Talend, Collibra, IBM Information Analyzer, etc.).
• Knowledge of ETL processes and data integration concepts.
• Experience with Excel, Power BI, Tableau, or similar BI tools.
• Understanding of Master Data Management (MDM) and Data Governance principles.
• Strong analytical, problem-solving, and communication skills.