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