Senior SQL Server Data Analyst - Quality & Reconciliation

Vertere Global Solutions, Inc.; Taguig; Hybrid; PHP 700,000 - 1,100,000; Full time

Job summary

Vertere Global Solutions, Inc. is seeking a hands-on Data Analyst with strong SQL Server and data quality expertise to assess, reconcile, and remediate large datasets across multiple systems.

The role focuses on identifying inconsistencies, analyzing error patterns, and developing correction scripts, while establishing data validation and monitoring processes to ensure accuracy and reliability. The ideal candidate has 5+ years in SQL Server development, DBA, or data analysis, with proficiency in

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Information Systems, Computer Engineering, or related field.
• At least 5 years of experience in SQL Server development, DBA, or data analysis.
• Strong proficiency in T-SQL with complex queries and data correction techniques.
• Experience in data profiling, reconciliation, and quality management on large datasets.
• Hands-on data remediation and production database correction.
• Understanding of ETL processes and batch-load troubleshooting.
• Familiarity with Python, SSIS, Power BI, or other data quality tools is an advantage.

Responsibilities

• Profile and assess master data for completeness, format, length, and duplicates.
• Perform multi-source data reconciliation across source systems and databases.
• Develop normalization and fuzzy-matching to distinguish real mismatches from formatting differences.
• Detect, investigate, and categorize data quality issues and data mapping errors.
• Trace issues to sources such as batch processes and data loads.
• Prepare and maintain an exception register with affected records and actions.
• Develop, test, and document T-SQL correction scripts.
• Execute data correction following change management with backups and validation.
• Post-correction reconciliation to measure accuracy and remaining discrepancies.
• Develop recurring data quality reports and monitoring queries.
• Collaborate with IT/Operations to investigate issues and implement fixes.

Job description

Vertere Global Solutions, Inc. is seeking a hands-on Data Analyst with strong SQL Server and data quality expertise to assess, reconcile, and remediate large datasets across multiple systems.

The role focuses on identifying inconsistencies, analyzing error patterns, and developing correction scripts, while establishing data validation and monitoring processes to ensure accuracy and reliability. The ideal candidate has 5+ years in SQL Server development, DBA, or data analysis, with proficiency in