Skip to main content
Z

Zensar Technologies

Sr. Data Analyst

IndiaPosted today

Skills

SQLSnowflakeETLAnalytical SkillsStakeholder ManagementCommunicationProblem SolvingAttention to DetailPresentationQuality AssuranceData AnalysisFintech

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

Apply on Zensar Technologies