Python & SQL Data Engineer

Ambidex; Karachi Division, Lahore, Islamabad; Hybrid; PKR 1,800,000 - 3,600,000; Full time

Job summary

Ambidex Inc. in Pakistan is seeking a Python & SQL Data Engineer for a hybrid role to design, build and optimize data pipelines and ETL workflows supporting reporting, analytics, and AI initiatives.

You will work with cross-functional teams to clarify data needs, analyze OLTP databases, and implement data models using 3NF, Star, and Snowflake schemas. Strong Python/SQL skills and cloud experience are essential.

Qualifications

• 5+ years of data engineering experience focused on Python and SQL.
• Experience designing, building, and optimizing ETL pipelines.
• Experience with OLTP and OLAP data sources.
• Strong communication and collaboration with cross-functional teams.
• Bachelor's degree in Computer Science or related field.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Familiarity with data modeling (3NF, Star, Snowflake).

Responsibilities

• Work with engineering, business, and US-based teams to clarify data requirements and technical needs.
• Analyze existing OLTP databases to understand table structures, relationships, and data flow.
• Design data models aligned with business needs, applying OLTP and OLAP schema techniques such as 3NF, Star, and Snowflake.
• Build data pipelines to ingest, transform, and integrate data from OLTP and external sources.
• Develop ETL/ELT workflows that support reporting, dashboards, and analytical models.
• Apply data validation rules, reconcile row counts, and verify transformations to ensure accuracy across sources.
• Optimize SQL queries to improve performance while reducing compute and memory usage.
• Diagnose and resolve data issues such as schema drift, failed jobs, and pipeline errors. Document data flows, transformation logic, and business rules.

Skills

Python

SQL

OLTP concepts

Relational databases

OLAP modeling

ETL/ELT patterns

Cloud platforms

Analytical skills

Communication skills

Education

Bachelor's in Computer Science or related field

Tools

PostgreSQL

SQL Server

MySQL

Oracle

Databricks

Spark

Snowflake

Microsoft Synapse

Airflow

Prefect

dbt

S3

Azure Blob

GCS

Job description

Ambidex Inc., a US-based technology consulting company, is hiring a Python & SQL Data Engineer for a hybrid role to design, build and optimize data and ETL pipelines.

Details

Location: Karachi, Lahore or Islamabad
Working Hours: Evening Shift
Experience: 5+ years in Python & SQL - Data Focused
MinimumEducation: Bachelors in Computer Science or related field
Compensation: based on experience
Interview Process: 2 Zoom Rounds

Summary

Design and build data pipelines that support reporting, analytics, and AI. This role requires strong Python and SQL skills, good communication, an understanding of OLTP and OLAP data sources, and the ability to translate business needs into clear technical solutions.

Responsibilities

• Work with engineering, business, and US-based teams to clarify data requirements and technical needs.
• Analyze existing OLTP databases to understand table structures, relationships, and data flow.
• Design data models aligned with business needs, applying OLTP and OLAP schema techniques such as 3NF, Star, and Snowflake.
• Build data pipelines to ingest, transform, and integrate data from OLTP and external sources.
• Develop ETL/ELT workflows that support reporting, dashboards, and analytical models.
• Apply data validation rules, reconcile row counts, and verify transformations to ensure accuracy across sources.
• Optimize SQL queries to improve performance while reducing compute and memory usage.
• Diagnose and resolve data issues such as schema drift, failed jobs, and pipeline errors. Document data flows, transformation logic, and business rules.

Required Skills

• Required Skills Strong proficiency in Python and SQL.
• Understanding of OLTP concepts (normalization, relational design).
• Experience with relational databases (PostgreSQL, SQL Server, MySQL, or Oracle).
• Experience with OLAP modeling (Star/Snowflake, fact/dimension design).
• Familiarity with ETL/ELT patterns and data transformations (including CDC).
• Familiarity with at least one cloud platform (AWS, Azure, or GCP).
• Strong analytical, problem-solving, and communication skills.

Preferred Skills

• Modern data platforms: Databricks, Spark, Snowflake or Microsoft Synapse
• Orchestration tools: ADF, Airflow or Prefect
• dbt or similar frameworks
• Cloud storage systems: S3, Azure Blob or GCS
• Modern data concepts: Data Lake, Lakehouse, Medallion Architecture
• Excellent package & benefits.
• Opportunity to work with international clients, innovative startups, and modern Cloud, Data and AI technologies.
• Fast career growth based on performance and results.
• Company paid certifications (AWS, Azure, GCP, Databricks, Snowflake).