Data Architect (Snowflake & Databricks)

Area(s) of responsibility

Skills: Data Architect (Snowflake & Databricks)

Experience: 16+ years

Location: Noida/ Mumbai/ Pune/ Bangalore/ Hyderabad/ Chennai

Role Overview:

We are seeking a highly experienced Data Architect with deep expertise in modern cloud data platforms, specifically Snowflake and Databricks. The ideal candidate will be responsible for designing, developing, and governing scalable, high-performance data architectures that support advanced analytics, AI/ML, and enterprise data initiatives. This role requires a strategic thinker who can translate business requirements into robust technical solutions while ensuring data quality, security, and scalability.

Key Responsibilities:

• Design and implement end-to-end data architecture across Snowflake and Databricks platforms.
• Define data modeling standards including dimensional, normalized, and Data Vault models.
• Architect scalable data lakes, lakehouses, and data warehouses using best practices.
• Lead data integration strategies using ETL/ELT frameworks leveraging tools like ADF, dbt, and Spark.
• Optimize performance and cost across Snowflake and Databricks environments.
• Implement data governance, security, lineage, and compliance frameworks.
• Enable real-time and batch data processing architectures.
• Collaborate with business stakeholders to align data strategy with business goals.
• Mentor engineering teams and enforce architectural standards.
Technical Skills & Expertise
• Strong expertise in Snowflake: architecture design, Snowpipe, Streams/Tasks, performance tuning,
and data sharing.
• Advanced knowledge of Databricks: Delta Lake, Lakehouse architecture, Spark (PySpark/Scala), and
performance optimization.
• Experience with Databricks features such as Unity Catalog, Delta Live Tables, MLflow, and Mosaic AI.
• Proficiency in SQL, Python, and distributed data processing frameworks.
• Hands-on experience with cloud platforms (Azure/AWS/GCP) and related services.
• Strong understanding of data ingestion, transformation, orchestration, and data warehousing
concepts.
• Experience with data visualization tools such as Power BI, Tableau, or Qlik.
Architecture & Design Capabilities
• Design hybrid architectures leveraging Snowflake for warehousing and Databricks for advanced
analytics and ML workloads.
• Define data lakehouse strategies integrating structured, semi-structured, and unstructured data.
• Build event-driven, real-time data pipelines.
• Establish reusable frameworks for ingestion, transformation, and consumption.
Data Governance & Security
• Implement robust data governance frameworks including cataloging, lineage, and data quality
controls.
• Ensure compliance with enterprise security policies and regulatory requirements.
• Define access control strategies using role-based and attribute-based access.

Qualifications & Experience
• 10+ years of overall experience in data engineering and architecture.
• Proven experience working with both Snowflake and Databricks in enterprise environments.
• Strong experience in designing large-scale data platforms and migration strategies.
• Experience in AI/ML data pipeline enablement is highly preferred.
• Relevant certifications in Snowflake, Databricks, or cloud platforms are a plus.

Soft Skills
• Strong stakeholder management and communication skills.
• Ability to translate complex technical concepts into business outcomes.
• Leadership skills with experience managing cross-functional teams.
• Strong problem-solving and analytical thinking abilities.