Key Responsibilities :

- Design, build, and maintain scalable ETL/ELT pipelines and data workflows on AWS.

- Develop and optimize data models (OLTP/OLAP), schemas, and warehousing solutions (e.g., Redshift, Snowflake, or similar).

- Build data ingestion frameworks for batch and streaming data from diverse sources (APIs, RDBMS, files, event streams).

- Implement data quality checks, validation rules, and monitoring for data reliability and SLAs.

- Write efficient, production-grade Python and SQL for data transformations and orchestration.

- Manage and optimize data storage, partitioning, and performance (query tuning, indexing, cost optimization).

- Implement orchestration and workflow management (e.g., Airflow/Step Functions).

- Collaborate with stakeholders to translate business requirements into technical specs and data contracts.

- Ensure data security, governance, lineage, and compliance (IAM, encryption, PII handling).

- Set up observability for pipelines (logging, metrics, alerting) and support on-call rotations.

- Contribute to CI/CD for data workloads, infrastructure-as-code, and best practices documentation.