Sr. Data Analyst
Zensar · Remote
Collected role 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. Role Summary We are seeking a highly analytical Senior Data Analyst to support Data Quality and Critical Issue (DQCI) remediation initiatives across enterprise data platforms. The ideal candidate will have strong expertise in data analysis, advanced SQL, root-cause investigation, and business process analysis. The role will serve as a bridge between business and technology teams to identify, analyze, and validate data quality improvements and sustainable remediation solutions. OK OK
Collected experience requirement
5-8 years