Data Architect

Apexon; Pune District; On-site; INR 4,200,000 - 7,000,000; Full time

Job summary

Apexon is seeking an experienced Data Architect to design and govern enterprise-scale data architectures, platforms, warehouses, lakes, and analytics ecosystems supporting BI, AI/ML and Generative AI initiatives.

You will work with stakeholders, architects, engineers, and AI/ML teams to build scalable, secure data solutions, defining standards, roadmaps, and blueprints while mentoring junior staff.

Qualifications

• 12+ years of experience in Data Architecture, Data Engineering, or Enterprise Data Management.
• Strong Data Modelling (ER, Dimensional, Star, Snowflake schemas).
• Extensive Data Warehousing, SQL, and Database Design expertise.
• Experience with Data Integration Patterns and Governance/Quality disciplines.
• Hands-on with at least one major cloud platform (AWS, Azure, or GCP).
• Familiarity with Spark, PySpark, Python or Scala, and distributed processing.

Responsibilities

• Define and maintain enterprise Data Architecture strategy, standards, and roadmap.
• Design conceptual, logical, and physical data models.
• Architect Data Warehouses, Data Lakes, and Lakehouse solutions.
• Design and optimize ETL/ELT pipelines and real-time data processing.
• Establish Data Governance, Metadata, MDM, Data Quality, and Security standards.
• Design cloud-based data platforms on AWS, Azure, or GCP.
• Provide architecture guidance for BI, Analytics, AI/ML, and Generative AI initiatives.
• Evaluate data technologies, storage, integration tools, and performance tuning.
• Ensure GDPR, HIPAA, ISO compliance; lead architecture reviews and governance.
• Mentor Data Engineers and Developers on best practices and patterns.
• Prepare architecture docs, data dictionaries, standards, and blueprints.

Skills

Data Modelling

Data Warehousing

SQL

Data Governance

Data Quality

Python/Scala

Spark/PySpark

Cloud Data Platforms

Education

Bachelor’s or Master’s in CS/IT/Data Science/Engineering

Tools

Databricks

Snowflake

Terraform

CloudFormation

ARM Templates

CI/CD for Data Platforms

Job description

We are looking for an experienced Data Architect to design, govern, and implement enterprise-scale data architecture, data platforms, data warehouses, data lakes/lakehouses, and analytics ecosystems supporting BI, Advanced Analytics, AI/ML, Generative AI, and digital transformation initiatives.

The ideal candidate should have strong expertise in Data Modelling, Data Warehousing, ETL/ELT, Cloud Data Platforms, Data Governance, Data Integration, SQL, and modern Data Engineering.

The role involves working closely with business stakeholders, Enterprise Architects, Data Engineers, Analysts, and AI/ML teams to build scalable, secure, highly available, and high-performing data solutions.

Key Responsibilities

• Define and maintain enterprise Data Architecture strategy, standards, and roadmap.
• Design conceptual, logical, and physical data models.
• Architect Data Warehouses, Data Lakes, and Lakehouse solutions.
• Design and optimize ETL/ELT pipelines, data integration frameworks, and real-time data processing architectures.
• Establish Data Governance, Metadata Management, MDM, Data Quality, Data Lineage, and Security standards.
• Design cloud-based data platforms using AWS, Azure, or GCP.
• Provide architecture guidance for BI, Analytics, AI/ML, and Generative AI initiatives.
• Evaluate data technologies, storage solutions, integration tools, and performance optimization strategies.
• Ensure compliance with applicable security, privacy, and regulatory standards such as GDPR, HIPAA, and ISO.
• Lead architecture reviews, technical design discussions, and governance forums.
• Mentor Data Engineers and Developers on architecture best practices, design patterns, and performance tuning.
• Prepare and maintain architecture documents, data dictionaries, standards, and solution blueprints.

Mandatory Skills

• 12+ years of experience in Data Architecture, Data Engineering, or Enterprise Data Management.
• Strong expertise in:
• Data Modelling – ER, Dimensional, Star Schema, Snowflake Schema
• Data Warehousing
• SQL and Database Design
• Data Integration Patterns
• Data Governance and Data Quality
• Strong hands-on experience with at least one major cloud platform:

AWS: Redshift, Glue, Athena, S3, Lake Formation, EMR

GCP: BigQuery, Dataflow, Dataproc, Cloud Storage

• Experience with relational and NoSQL databases such as PostgreSQL, SQL Server, Oracle, MongoDB, Cassandra, or DynamoDB.
• Strong knowledge of Spark / PySpark and distributed data processing.
• Strong SQL skills and familiarity with Python or Scala.
• Experience designing high-volume, highly available, and scalable enterprise data platforms.
• Strong stakeholder management, communication, architecture, and problem-solving skills.

Preferred Skills

• Databricks
• Snowflake
• MLOps and Feature Stores
• Generative AI
• Vector Databases
• Semantic Layers
• RAG (Retrieval-Augmented Generation)
• Terraform / CloudFormation / ARM Templates
• CI/CD for Data Platforms

Education

Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, Engineering, or a related field.