Zensar Technologies
Sr. Data Analyst
Skills
Job 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.
Strong 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.
OK
OK