Data Analyst (SQL Server)

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

Job Summary

We are looking for 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 will focus on identifying data inconsistencies, analyzing error patterns, developing and executing correction scripts, and establishing data validation and monitoring processes to maintain data accuracy, integrity, and reliability.

Key Responsibilities

• Profile and assess master data based on completeness, format, length, special characters, duplicate entries, and referential integrity.

• Perform multi-source data reconciliation to identify discrepancies across source systems, databases, and downstream applications.

• Develop normalization and fuzzy-matching techniques to distinguish actual data mismatches from formatting-related differences, such as truncation, punctuation, spacing, and inconsistent naming conventions.

• Detect, investigate, and categorize data quality issues, including incorrect field mapping, data truncation, cross-record contamination, and orphaned records.

• Trace identified data issues to their possible sources, including batch processes, data loads, and integration activities.

• Prepare and maintain a prioritized exception register documenting affected records, identified error patterns, associated risks, and recommended corrective actions.

• Develop, test, and document T-SQL correction scripts to address identified data inconsistencies.

• Execute data correction activities following established change management procedures, including backup preparation, before-and-after validation, and audit documentation.

• Perform post-correction reconciliation and validation to measure data accuracy and identify remaining discrepancies.

• Develop recurring data quality reports, monitoring queries, and validation procedures to support ongoing data integrity.

• Work closely with IT, Operations, and other relevant stakeholders to investigate data issues and implement corrective measures.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Information Systems, Computer Engineering, or any related field.

• At least 5 years of experience in SQL Server development, database administration (DBA), or data analysis.

• Strong proficiency in T-SQL, including complex queries, stored procedures, and data correction techniques.

• Proven experience in data profiling, data reconciliation, and data quality management involving large datasets.

• Hands-on experience in production database correction and data remediation activities.

• Strong understanding of ETL processes, batch-load troubleshooting, and relational database structures.

• Experience with data normalization, fuzzy matching, string manipulation, and duplicate detection techniques.

• Familiarity with Python, SSIS, Power BI, or other data quality tools is an advantage.

• Experience working with .NET application data models is an advantage.

• Knowledge of database change control, backup procedures, audit documentation, and data privacy practices.

• Background in financial services, brokerage, or other data-intensive industries is preferred.