Senior Python & SQL Data Engineer - ETL & AI Pipelines
Posted Updated
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.
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. 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).Skills
Sign in to read and join the discussion.