Lead AWS Data Engineer — Data Lakes, Pipelines & DW

Wishalicious; Maryland; On-site; USD 140,000 - 190,000; Full time

Job summary

Wishalicious is seeking a senior data engineer to design and operate scalable data lakes, marts and data mesh architectures. You will own data integration pipelines using Python, AWS data services, and DBT, ensuring data quality and timely delivery.

You will collaborate with business stakeholders and architects to shape the enterprise data strategy, models, and migration roadmap, while mentoring junior engineers and improving performance across ETL/ELT pipelines.

Qualifications

• 12+ years of hands-on experience in Python, AWS Data Services, DBT, Airflow, SQL and PySpark.
• Very good knowledge of SQL and Data Warehousing lifecycle is required.
• Experience in building data pipelines and orchestrating with DBT and Airflow.
• Experience with data migrations and development of ODS, EDW, Data Lake and Data Marts.
• Experience fixing performance issues and data modeling exposure is a must.
• Nice-to-have: cloud ETL/ELT tools like Glue/EMR or similar.
• Experience with Snowflake, DB2, PostgreSQL and other databases is a plus.
• Excellent communication to liaise with Business & IT stakeholders.
• Experience in planning projects and estimating effort.
• Exposure to Agile ways of working.

Responsibilities

• Lead design of reliable, secure data lakes, data marts and data meshes.
• Lead design, development, and maintenance of data integration solutions using Python, AWS Data Services, and DBT to ensure data quality.
• Collaborate with stakeholders to define enterprise data strategy, models, and migration roadmap.
• Translate complex constraints into business insights and manage cross-functional expectations.
• Develop, modify, configure and debug existing data pipelines per business requirements.
• Troubleshoot and optimize code for performance.
• Manage new requirements, review jobs, perform gap analysis and fix performance issues.
• Mentor junior/mid-level engineers on best practices and modern data patterns.
• Document all data flow, mappings, sessions and workflows.
• Handle tickets and perform issue analysis in Agile / POD contexts.

Skills

Python

AWS Data Services

DBT

Apache Airflow

SQL

PySpark

Data Warehousing

Data pipelines

Data migrations

Data modeling

Performance tuning

Data engineering best practices

Agile

ETL / ELT tooling

Snowflake

DB2

PostgreSQL

Communication

Project planning

Effort estimation

Tools

DBT

Apache Airflow

Snowflake

Glue

EMR

PostgreSQL

DB2

Job description

Wishalicious is seeking a senior data engineer to design and operate scalable data lakes, marts and data mesh architectures. You will own data integration pipelines using Python, AWS data services, and DBT, ensuring data quality and timely delivery.

You will collaborate with business stakeholders and architects to shape the enterprise data strategy, models, and migration roadmap, while mentoring junior engineers and improving performance across ETL/ELT pipelines.