Assistant Vice President - Data Architect

Job Description (JD) – Data Architect Position Title

Data Architect

Experience

12-15 Years

Location

Remote/Hybrid

Employment Type

Full-Time

Role Overview

We are seeking an experienced Data Architect with 12-15 years of experience in designing and implementing enterprise-scale data platforms, data architectures, and data management solutions. The ideal candidate will possess strong expertise in data modeling, data warehousing, big data ecosystems, cloud data platforms, and modern data architecture frameworks.

The Data Architect will be responsible for defining the organization's data strategy, designing scalable and secure data solutions, establishing best practices, and providing architectural leadership to data engineering, analytics, and business teams.

Key Responsibilities

• Define and implement enterprise data architecture strategy aligned with business objectives.
• Design scalable, secure, and high-performing data platforms supporting analytics, reporting, AI/ML, and operational workloads.
• Develop conceptual, logical, and physical data models for enterprise applications.
• Architect enterprise data warehouses, data lakes, lakehouses, and modern data platforms.
• Establish data governance, metadata management, data quality, and master data management frameworks.
• Lead the design of data integration and ETL/ELT architectures across multiple systems.
• Define standards, best practices, and architectural guidelines for data management.
• Collaborate with business leaders, enterprise architects, and technology teams to drive data transformation initiatives.
• Evaluate emerging technologies and recommend innovative data solutions.
• Provide technical leadership and mentorship to data engineering and analytics teams.
• Ensure compliance with security, privacy, and regulatory requirements.

Required Technical Skills Data Architecture & Design

• Strong expertise in:
  • Enterprise Data Architecture
  • Data Strategy & Roadmaps
  • Data Integration Architecture
  • Information Architecture
  • Reference Architecture Development
  • Data Modernization Programs

Data Modeling

• Extensive experience with:
  • Conceptual Data Modeling
  • Logical Data Modeling
  • Physical Data Modeling
  • Dimensional Modeling
  • Data Vault 2.0
  • Star & Snowflake Schemas
• Proficiency with data modeling tools such as:
  • Erwin
  • ER/Studio
  • PowerDesigner
  • Visio

Data Warehousing & Data Lakes

• Strong experience designing:
  • Enterprise Data Warehouses
  • Data Lakes
  • Lakehouse Architectures
  • Operational Data Stores (ODS)
  • Data Marts
• Deep understanding of:
  • Data Lifecycle Management
  • Metadata Management
  • Data Lineage

Cloud & Modern Data Platforms

Strong experience in one or more cloud platforms:

Microsoft Azure

• Azure Data Factory
• Azure Synapse Analytics
• Azure Data Lake Storage
• Microsoft Fabric
• Azure Databricks

Amazon Web Services (AWS)

• S3
• Glue
• Redshift
• EMR
• Athena

Google Cloud Platform (GCP)

• BigQuery
• Dataflow
• Dataproc
• Cloud Storage

Big Data & Data Engineering

• Strong understanding of:
  • Hadoop Ecosystem
  • Spark / PySpark
  • Hive
  • Kafka
  • Delta Lake
• Experience designing large-scale batch and real-time data processing architectures.

Database Technologies

Experience working with:

• SQL Server
• Oracle
• PostgreSQL
• Snowflake
• Teradata
• MySQL

Strong expertise in:

• Database Design
• Query Optimization
• Data Partitioning
• Performance Tuning

Data Governance & Security

• Strong knowledge of:
  • Data Governance Frameworks
  • Metadata Management
  • Data Cataloging
  • Data Quality Management
  • Master Data Management (MDM)
  • Data Privacy Regulations
• Experience implementing:
  • Role-Based Access Control (RBAC)
  • Data Security Policies
  • Data Compliance Frameworks

Architecture & Integration Skills

• Experience with:
  • Enterprise Integration Patterns
  • API-Based Data Integration
  • Event-Driven Architecture
  • Microservices Architecture
  • Data Mesh Concepts
  • Data Fabric Architecture
• Ability to create architecture artifacts, solution blueprints, and data flow diagrams.

Leadership Responsibilities

• Lead enterprise data architecture discussions and governance forums.
• Mentor Data Architects, Data Engineers, and Technical Leads.
• Drive architecture reviews and design approvals.
• Support pre-sales activities, solution proposals, and technical estimations.
• Engage with executive stakeholders to define long-term data strategies.
• Establish architecture standards and reusable frameworks across projects.

Preferred Skills

• Experience with:
  • Snowflake
  • Databricks
  • Microsoft Fabric
  • Informatica
  • Talend
  • Collibra
  • Alation
• Exposure to:
  • AI/ML Data Platforms
  • Generative AI Data Architecture
  • Data Observability Platforms
• Familiarity with:
  • DevOps
  • CI/CD
  • Infrastructure as Code (Terraform)

Soft Skills

• Strong leadership and strategic thinking abilities.
• Excellent stakeholder management and communication skills.
• Ability to present architectural solutions to executive leadership.
• Strong analytical and problem-solving capabilities.
• Proven ability to lead large-scale enterprise transformation initiatives.

Educational Qualifications

• Bachelor's or Master's Degree in:
  • Computer Science
  • Information Technology
  • Data Engineering
  • Engineering or related discipline

Preferred Certifications

• TOGAF Certification
• Microsoft Certified: Azure Solutions Architect Expert
• Microsoft Certified: Azure Data Engineer Associate
• Databricks Certified Data Engineer Professional
• AWS Certified Solutions Architect Professional
• Google Professional Data Engineer
• Snowflake SnowPro Certification

Key Competencies

• Enterprise Data Architecture
• Cloud Data Architecture
• Data Modeling
• Data Warehousing & Lakehouse Design
• Big Data Architecture
• Data Governance & MDM
• Data Security & Compliance
• Data Integration Architecture
• Stakeholder Management
• Technical Leadership & Mentoring

Ideal Candidate Profile

A highly experienced Data Architect with 12-15 years of experience in designing enterprise-scale data ecosystems, defining data strategy, architecting modern cloud-based data platforms, and leading large transformation programs. The candidate should possess exceptional expertise in data architecture, governance, data modeling, cloud platforms, and modern analytics solutions, along with the ability to provide strategic leadership and drive enterprise-wide data initiatives.

ResponsibilitiesOversee organizational product development. Lead highimpact initiatives. Ensure alignment with organizational goals. Provide executive guidance. QualificationsBachelor's or Master's degree in Computer Science, Engineering, Product Design, or a related field. 8-12 years of experience in product development or engineering.