Key Responsibilities

- Investigate and analyze Data Quality & Critical Issues (DQCIs) across multiple systems and datasets.
- Perform detailed data, validation, and reconciliation activities to identify data inconsistencies and anomalies.
- Conduct root-cause analysis to determine the source of defects across source, integration, and consumption layers.
- Gather, analyze, and document business and technical remediation requirements.
- Perform impact assessments and data lineage analysis to understand downstream implications of defects and fixes.
- Work closely with business stakeholders, Data Engineers, Architects, and QA teams to drive issue resolution.
- Define validation strategies to ensure remediation effectiveness.
- Review data transformation logic, mappings, and business rules for accuracy and completeness.
- Monitor data quality metrics and identify recurring issue patterns for proactive remediation.
- Prepare analytical reports, findings, and recommendations for stakeholders.

Required Technical Skills

Core Skills

- Advanced SQL
- Complex query writing and optimization
- Data analysis and reconciliation
- Data validation and troubleshooting
- Understanding of Snowflake data structures & performance tuning

- Data Profiling

- Data quality assessment & Pattern identification
- Data completeness and consistency checks

- Root-Cause Analysis

- Defect investigation
- Issue diagnosis across data pipelines and systems
- Corrective action recommendations

- Data Reconciliation

- Source-to-target validation
- Data comparison and exception analysis
- Data accuracy verification

- Process Analysis

- Business process evaluation
- Process improvement recommendations
- Requirement impact assessment

Expected Contributions





- Investigate and analyze DQCIs to identify underlying causes and business impacts.
- Define business and technical remediation requirements for issue resolution.
- Perform impact analysis across upstream and downstream systems.
- Coordinate with business users, data engineers, architects, and QA teams to ensure timely remediation
- Identify recurring data quality patterns and recommend preventive measures.
- Ensure data accuracy, completeness, and consistency throughout remediation efforts & Validate implemented fixes.
- Support audit and compliance requirements through detailed analysis and documentation.
- Drive continuous improvement initiatives focused on data quality and operational efficiency.

Preferred Qualifications

- Experience in enterprise Data Quality, Data Governance, or Data Warehousing projects.
- Exposure to Snowflake-based analytics environments.
- Knowledge of ETL/ELT processes and data integration concepts.
- Experience working in Agile/Scrum environments.
- Robust stakeholder management and communication skills.
- Banking, Financial Services, Insurance, Healthcare, or Retail domain experience is preferred.

Soft Skills

- Strong analytical and problem-solving abilities.
- Excellent communication and stakeholder management skills.
- Attention to detail and data accuracy.
- Ability to work independently and collaboratively across teams.
- Strong documentation and presentation skills.





Target Designation: Senior Data Analyst

Location Preference: Offshore

Priority Skills: Advanced SQL, Snowflake Querying, Data Profiling, Root-Cause Analysis, Reconciliation, Process Analysis, Requirements Gathering, Testing & Validation.

Responsibilities

OK

Qualifications

OK At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises.

We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

📌 Sr. Data Analyst (Pune)
🏢 Zensar
📍 Pune