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 :

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

• Enterprise solutioning (multi-cloud strategy).

• Cloud platforms (Azure, AWS, GCP).

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

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

• 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.