Lead Data Architect

Calfus Inc.; Pune District; On-site; INR 2,500,000 - 4,500,000; Full time

Benefits offered by this job

Medical insurance

Group insurance

Parental insurance

Birthday leave

Gratuity

Provident fund

Job summary

Calfus Inc. seeks a Senior Data Architect to lead the design, implementation, and governance of enterprise data architectures that underpin analytics and AI-driven decision making.

The role focuses on cloud-native platforms using Snowflake, Databricks, and Azure, with hands-on leadership to mentor teams. You will own data modeling, governance, and scalable data pipelines while balancing performance, cost, and usability across complex ecosystems.

Qualifications

• Bachelor's degree in CS/IS or related field.
• 8–12 years of hands-on experience designing and architecting enterprise data solutions.
• Expertise in data warehouse/lakehouse architectures and medallion design (Bronze/Silver/Gold).
• Strong SQL, Python, and data transformation skills with production-grade pipelines.

Responsibilities

• Architect enterprise data platforms and governance frameworks to support analytics and AI initiatives.
• Design semantic data models and dimensional schemas for multi-source environments.
• Lead data architecture initiatives end-to-end from conception to production deployment.
• Mentor junior engineers and promote best-practice data engineering.

Skills

Data modeling

Cloud platforms

SQL

Python

ETL/ELT

Data governance

Leadership

Mentoring

Education

Bachelor's degree in CS/IS

Tools

Snowflake

Databricks

Azure

Job description

About the role:

As a Senior Data Architect, you will lead the design, implementation, and governance of enterprise-grade data architectures that serve as the foundation for organizational analytics and AI-driven decision-making. You will architect cloud-native data platforms using modern medallion architectures, design semantic data models, and establish data governance frameworks that scale across complex enterprise ecosystems. This is a highly technical, hands‑on leadership role that demands deep expertise in data modeling, cloud platforms (Snowflake, Databricks, Azure), and the ability to mentor engineering teams while driving strategic data architecture initiatives.

What You'll Do:

• Architect enterprise data platforms using medallion (bronze-silver-gold) layering strategies for scalable, maintainable analytics ecosystems.
• Design and implement semantic data models that enable self‑service analytics, reduce complexity, and improve business alignment.
• Lead dimensional, relational, and analytical schema design for complex multi‑source data environments.
• Own foundational data architecture strategies that balance performance, scalability, cost, and usability.
• Design and implement cloud‑native data architectures on Snowflake, Databricks, or Azure cloud ecosystems.
• Architect ETL/ELT pipelines and data ingestion frameworks for high‑volume, multi‑source enterprise data ecosystems.
• Establish reusable data frameworks, platform abstractions, and architectural best practices to drive long‑term scalability.
• Lead performance tuning, cost optimization, and capacity planning across cloud data platforms.

Data Modeling & Governance:

• Design and govern metadata, data catalogs, and semantic layers to enable discoverability and trustworthiness.
• Implement comprehensive data quality frameworks, validations, and observability practices.
• Establish data governance policies, lineage tracking, and compliance standards across the platform.

Technical Hands‑On Leadership:

• Write complex SQL, Python, and data transformation code alongside your team—not just provide direction.
• Lead greenfield data architecture initiatives from conceptualization through production deployment.
• Design and optimize database schemas, indexing strategies, and query execution plans for analytical workloads.
• Mentor and develop junior data engineers, fostering a culture of technical excellence.

Stakeholder & Client Collaboration:

• Partner with BI teams to enable semantic modeling and self‑service analytics on Power BI or Tableau.
• Translate complex business requirements into scalable, maintainable data architecture solutions.
• Drive cross‑functional initiatives and communicate technical architecture decisions to executive stakeholders.
• Support data visualization teams with optimized data structures and APIs for reporting and dashboarding.

On your first day, we'll expect you to have:

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 8–12 years of hands‑on experience designing and architecting enterprise data solutions, with deep expertise in:
• Data warehouse and lakehouse architecture design
• Medallion architecture implementation (Bronze, Silver, Gold layers)
• Semantic data modeling and dimensional design
• Proven track record of owning large-scale data architecture initiatives from inception through production deployment.
• Expert‑level proficiency with Snowflake or Databricks—candidates with expertise in both will be strongly preferred.
• Advanced SQL expertise with experience across modern data platforms (Snowflake, Databricks, Azure Synapse, Redshift).
• Strong hands‑on experience with cloud services (AWS, Azure, GCP) and data tools (Azure Data Factory, Databricks, cloud object storage).
• Proficiency in Python for scripting, automation, data manipulation, and framework development.
• Deep understanding of data serialization formats (Parquet, JSON, CSV, Delta Lake formats).
• Demonstrated ability to design scalable data platforms that handle complex enterprise analytics at petabyte scale.
• Leadership experience mentoring data engineering teams or leading technical workstreams.

We'd be super excited if you have:

• Snowflake or Databricks architect certifications
• Experience designing and implementing semantic layers (e.g., dbt, Semantic Layer frameworks)
• Hands‑on experience with REST APIs, data integration patterns, and ETL orchestration tools
• Prior experience architecting data solutions for AI/ML pipelines
• Exposure to data governance and metadata management tools
• Experience with containerization (Docker) and infrastructure‑as‑code for data platforms

Please note:

This role is heavily focused on data architecture, semantic modeling, platform engineering, and strategic data platform development. Candidates whose experience is primarily centered around BI tool development, maintenance of existing warehouses, or routine data operations may not be the best fit. We're looking for architects who design and build platforms from the ground up.

At Calfus, we value our employees and offer a strong benefits package.

• This includes medical, group, and parental insurance, coupled with gratuity and provident fund options.
• Further, we support employee wellness and provide birthday leave as a valued benefit.

Calfus is an Equal Opportunity Employer.

We believe diversity drives innovation. We're committed to creating an inclusive workplace where everyone—regardless of background, identity, or experience—has the opportunity to thrive. We welcome all applicants!