Description

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

📌 Sr. Data Analyst (India)
🏢 Zensar Technologies
📍 India