Data Analyst
Capco · Gurugram, Haryana, India
Financial Services · 5,001-10,000 employees
About the role
The Data Analyst will perform data cleansing, standardization, and quality management to ensure high-quality and accurate data across enterprise systems. They will also collaborate with technical and business teams to define data standards, monitor quality metrics, and support data governance initiatives.
What they look for
Requirements
Candidates must hold a bachelor's degree in a relevant field and possess at least 3 years of experience in data analysis or quality management. Strong proficiency in SQL, data profiling tools, and BI software is required for this role.
Full description
Job Title: Data Analyst
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.
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.
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.