Senior Cloud ETL Architect

Role : SENIOR CLOUD ETL ARCHITECT

ROLE SUMMARY :

Seeking Senior Cloud ETL Architect (10+ yrs) to lead enterprise data warehouse & ETL platform design on Azure, AWS, GCP. Architect end-to-end data integration solutions, lead presales/RFP initiatives, and mentor delivery teams. Proven experience with ADF, Synapse, Snowflake, Python, SQL, data warehouse design, and enterprise governance frameworks.

KEY RESPONSIBILITIES :

- Design & own ETL/ELT architecture (Azure Data Factory, AWS Glue, Databricks, Synapse).

- Lead presalesRFP responses, technical proposals, client workshops, CXO engagement.

- Architect enterprise DWH (Kimball, Data Vault, dimensional modeling).

- Define data governance, compliance, metadata management, data lineage.

- Design CI/CD, monitoring, observability for data pipelines.

- Mentor data engineers, establish architectural standards, build accelerators.

REQUIRED QUALIFICATIONS :

- 10+ yrs data engineering/architecture.

- 3+ yrs senior architect/tech lead.

Super Mandatory Skills :

1. Presales/RFP (RFP responses, technical solutioning).

2. Enterprise solutioning (multi-cloud strategy).

3. Cloud platforms (Azure, AWS, GCP).

4. ADF or equivalent ETL (Azure Data Factory, AWS Glue).

5. SQL/T-SQL (advanced data modeling, optimization).

6. DWH design (Kimball, Data Vault, enterprise warehouse architecture).

- Advanced SQL (T-SQL, PL-SQL, PySpark SQL).

- Python & PySpark for transformations.

- RDBMS (Oracle, MSSQL, PostgreSQL, MySQL).

- Data modeling (dimensional, hierarchies, SCD).

- Data governance, GDPR/HIPAA compliance.

- Azure DevOps, Terraform, CI/CD pipelines.

PREFERRED QUALIFICATIONS :

- Kafka/streaming (Event Hubs, Kinesis).

- Power BI semantic modeling.

- Azure certifications (DP-203, AZ-305).

- Consulting/practice delivery background.

- Databricks, Snowflake, dbt expertise.

TECHNICAL STACK : Azure Data Factory, Azure Synapse, AWS Glue, Databricks, Snowflake, Python, PySpark, SQL, Terraform, Azure DevOps, Power BI, Kafka.