Sr. Data Analyst

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