Senior Python & SQL Data Engineer - ETL & AI Pipelines

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. 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.