Data Operations Analyst: SQL & Data Quality Pro

Travel Innovation Group; Lahore; On-site; PKR 1,000,000 - 1,800,000; Full time

Benefits offered by this job

Modern Lahore office

Medical insurance

Pension scheme

Gym access

Annual increments

Professional certifications

Career progression

Lunch provided

Team events

Onsite parking

Monthly mobile allowance

Work-life balance

Job summary

Calrom Pakistan (Private) Limited, a Travel Innovation Group tech division, is seeking a Data Operations Analyst to maintain data accuracy across critical applications. The role emphasizes investigating data issues, performing controlled fixes, and using SQL to support incident investigations.

You will collaborate with SRE and development teams to improve data quality and ensure systems run reliably from the Lahore office. Strong SQL skills and production experience are essential.

Qualifications

• Experience writing, troubleshooting, and optimizing SQL queries against Microsoft SQL Server.
• Strong knowledge of SQL Server architecture, tables, views, indexes and stored procedures.
• Experience investigating data-related issues in production environments.
• Ability to perform controlled data fixes with data integrity and auditability.
• Working knowledge of SQL Server Agent, jobs and automated processes.
• Experience using SQL Server Profiler and Extended Events to diagnose performance issues.

Responsibilities

• Investigate and resolve data-related issues across multiple systems.
• Analyze data discrepancies and identify root causes of incidents.
• Perform controlled data fixes following governance standards.
• Validate data changes for accuracy, completeness and integrity.
• Write, troubleshoot, and optimize SQL queries for operations.
• Extract and analyze data to support incident investigations and business requests.
• Support production activities and data-related incident resolution.
• Validate data and business processes before/after deployments.
• Create and maintain SQL scripts to automate routine tasks.
• Collaborate with SRE and development teams on long-term solutions.
• Produce and maintain documentation for investigations and fixes.
• Identify opportunities to improve data quality and efficiency.

Skills

SQL queries

MS SQL Server

SQL Server Agent

SQL Server Profiler

Extended Events

Data analysis

Problem solving

Communication

Tools

SSMS

SQL Server Profiler

Extended Events

Job description

Calrom Pakistan (Private) Limited, a Travel Innovation Group tech division, is seeking a Data Operations Analyst to maintain data accuracy across critical applications. The role emphasizes investigating data issues, performing controlled fixes, and using SQL to support incident investigations.

You will collaborate with SRE and development teams to improve data quality and ensure systems run reliably from the Lahore office. Strong SQL skills and production experience are essential.