Data Engineer (SQL Server, ETL & Performance Optimization)

Location: Islamabad
Job Type: Full-Time
Experience Level: 5 - 7 Years
Industry: Banking / Financial Services (Preferred)

Role Summary

We are seeking a highly skilled Data Engineer with deep expertise in SQL Server performance optimization, high-volume ETL operations, and large-scale data processing. The ideal candidate will have hands-on experience managing complex data ecosystems, optimizing long-running jobs, and ensuring robust, efficient, and scalable ETL pipelines. Experience in financial systems or large MIS/reporting environments will be a strong plus.

Key Responsibilities

• Design, develop, and optimize SQL Server queries, indexes, partitions, and overall database performance.

• Perform SQL Server performance tuning to support high-volume OLTP and OLAP workloads.

• Optimize and maintain ETL batch jobs, ensuring efficient execution and minimal downtime.

• Handle large-volume data loads, ensuring reliability, consistency, and performance across data pipelines.

• Troubleshoot and resolve long-running or failing ETL jobs, bottlenecks, and inefficiencies.

• Develop and maintain CDC (Change Data Capture)-based incremental data models.

• Manage end-to-end ETL processes, including scheduling, orchestration, monitoring, and debugging.

• Work with SQL CLR functions and assemblies, including reviewing, debugging, updating, and replacing them when necessary.

• Collaborate closely with BI, Data Analytics, and Application teams to support data integration requirements.

• Ensure data quality, consistency, and compliance across all integrated systems.

Required Skills & Expertise

• Strong hands-on experience with SQL Server (performance tuning, indexing, partitioning, query optimization).

• Deep understanding of ETL frameworks, including batch processing and incremental loads.

• Experience managing large ETL architectures with complex dependencies.

• Strong knowledge of CDC and incremental data movement strategies.

• Expertise in working with large OLTP and OLAP environments.

• Experience with SQL CLR functions and assemblies (reading, debugging, modifying).

• Strong troubleshooting skills for long-running processes, query slowness, and data pipeline issues.

Preferred Experience

• Experience in the banking or financial domain (T24 or similar core banking systems).

• Hands-on experience working with heavy reporting or MIS environments with demanding data refresh cycles.

• Exposure to large-scale ETL ecosystems involving 500+ tables or high-volume enterprise data models.

Soft Skills

• Strong problem-solving and analytical abilities.

• Effective communication and collaboration skills.

• Ability to work independently in high-pressure, data-intensive environments.

• Attention to detail with a commitment to data accuracy and quality.