Job Title: Data Engineer (5+ Years Experience)

Location: Karachi (Hybrid)
Experience Required: 5+ Years
Employment Type: Full-Time

Job Overview

We are looking for an experienced Data Engineer to design, build, and maintain scalable data pipelines and architectures. The ideal candidate is highly analytical, detail-oriented, and passionate about working with large and complex datasets while ensuring data quality, performance, and reliability.

Key Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines for data processing and transformation

• Build scalable and high-performance data architectures and workflows

• Develop production-grade code using Python and SQL

• Work with orchestration tools such as Airflow or Databricks Workflows

• Optimize SQL queries using advanced techniques (CTEs, window functions, query tuning)

• Implement and manage data models (star schema, snowflake, normalization, partitioning)

• Ensure data quality, consistency, and reliability across pipelines

• Troubleshoot, debug, and resolve complex data issues with root cause analysis

• Implement best practices for version control, CI/CD, automated testing, and code reviews

• Manage data governance and access using tools like Unity Catalog

• Continuously monitor and improve pipeline performance and scalability

Required Skills & Qualifications

• 5+ years of experience in Data Engineering or ETL development

• Strong proficiency in Python and SQL

• Hands-on experience with Databricks, including:

  • Spark APIs

  • Delta Lake (ACID transactions, schema evolution, time travel)

• Experience with orchestration tools (Airflow, Databricks Workflows, etc.)

• Solid understanding of data modeling and architecture design principles

• Experience with large-scale or complex datasets

• Strong debugging, troubleshooting, and problem-solving skills

• Ability to design reliable systems with focus on:

  • Idempotency

  • Error handling & recovery

  • Backfilling strategies

Preferred Skills

• Experience with data quality frameworks

• Proven ability to build and maintain production-grade pipelines

• Strong expertise in optimizing both SQL queries and Python code

• Hands-on experience demonstrated through technical assessments or real-world projects

Soft Skills

• Excellent communication skills with the ability to explain technical concepts clearly

• Strong analytical thinking and attention to detail

• Curious mindset with a habit of deep-diving into problems and solutions

• Ability to justify technical decisions and trade-offs effectively

What We’re Looking For

Someone who doesn’t just build pipelines—but understands why things work, identifies issues proactively, and continuously improves systems with a strong sense of ownership.