Data Engineer

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.