AWS Data Lead - SQL/Python
First seen by Alion on Aug 20, 2026.
Role Summary :
The AWS Data Lead will lead the design and delivery of AWS data engineering and analytics solutions, guide data engineers and analytics engineers, and ensure that data platforms are scalable, secure, governed, reliable, and aligned to business outcomes. The role bridges architecture and hands-on delivery across data ingestion, transformation, storage, analytics, governance, operational readiness, and AI / GenAI data foundations.
Required Primary Skills :
- AWS data platform delivery using Amazon S3, AWS Glue, Amazon Redshift, Amazon Athena and AWS Lake Formation.
- Strong SQL, Python and PySpark skills for data ingestion, transformation, validation and optimization.
- ETL / ELT pipeline design, data lake and lakehouse implementation, data warehousing and dimensional modeling.
- Technical leadership for data engineering teams, solution reviews, sprint planning and delivery governance.
- Data quality, metadata, lineage, cataloging, security, privacy and access-control implementation.
Secondary Skills :
- Amazon EMR, Amazon Kinesis, AWS DMS, AWS DataSync and Amazon OpenSearch.
- Streaming and event-driven data processing using Kinesis, Kafka or equivalent technologies.
- Infrastructure as Code using Terraform or AWS CloudFormation and CI/CD for data workloads.
- Amazon QuickSight, Power BI or Tableau integration for analytics consumption.
- AI / GenAI data foundations including feature stores, embeddings, vector-ready datasets and RAG data pipelines.
Key Responsibilities :
- Lead discovery sessions and translate business, analytics and AI requirements into an executable AWS data platform backlog.
- Own technical delivery of data ingestion, ETL / ELT, data lake, warehouse, analytics and streaming workstreams.
- Define solution standards for pipeline design, data modeling, coding, testing, orchestration, monitoring and deployment.
- Guide and mentor data engineers and analytics engineers through design reviews, code reviews and production-readiness checkpoints.
- Collaborate with the AWS Data Architect on target architecture, service selection, scalability, resilience, security and cost optimization.
- Establish data quality rules, reconciliation controls, metadata, cataloging, lineage and governance practices.
- Coordinate with AI / ML and GenAI teams to prepare trusted datasets, feature pipelines, knowledge repositories and RAG-ready data assets.
- Manage technical risks, dependencies, defects, performance issues and production incidents through root-cause analysis and corrective actions.
- Support estimations, proposals, proof-of-concepts, customer demonstrations and reusable AWS data accelerators when required.
- Ensure documentation, knowledge transfer and operational handover are complete for each release.
Preferred Certifications :
- AWS Certified Data Engineer Associate.
- AWS Certified Solutions Architect Associate.
- AWS Certified Solutions Architect Professional, preferred for senior candidates.
- Databricks Data Engineer certification or equivalent data-platform certification, desirable.
Qualification :
- 6 to 10 years of overall experience in data engineering or analytics, including hands-on AWS data-platform delivery and team leadership responsibilities.
- Demonstrated experience delivering production-grade data pipelines, data lakes, warehouses or analytics platforms.
Skills
Data Engineering, AWS, Python, SQL, ETL, Data Quality, Metadata, Data Warehousing, Dimensional Modeling, DataLake, Analytics