Assistant Vice President - Data Architect

EXL • New York, NY

2d • $160,000 - $190,000 • Hybrid

About The Position

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.

Requirements

• 12-15 years of experience in designing and implementing enterprise-scale data platforms, data architectures, and data management solutions.
• Strong expertise in data modeling, data warehousing, big data ecosystems, cloud data platforms, and modern data architecture frameworks.
• Strong expertise in Enterprise Data Architecture, Data Strategy & Roadmaps, Data Integration Architecture, Information Architecture, Reference Architecture Development, Data Modernization Programs.
• 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.
• 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.
• Strong experience in one or more cloud platforms: Microsoft Azure (Azure Data Factory, Azure Synapse Analytics, Azure Data Storage, Microsoft Fabric, Azure Databricks), Amazon Web Services (AWS) (S3, Glue, Redshift, EMR, Athena), Google Cloud Platform (GCP) (BigQuery, Dataflow, Dataproc, Cloud Storage).
• Strong understanding of Hadoop Ecosystem, Spark / PySpark, Hive, Kafka, Delta Lake.
• Experience designing large-scale batch and real-time data processing architectures.
• Experience working with SQL Server, Oracle, PostgreSQL, Snowflake, Teradata, MySQL.
• Strong expertise in Database Design, Query Optimization, Data Partitioning, Performance Tuning.
• 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.
• 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.
• 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.
• Bachelor's or Master's Degree in Computer Science, Information Technology, Data Engineering, Engineering or related discipline.
• 8-12 years of experience in product development or engineering.

Nice To Haves

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

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.
• 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.
• Oversee organizational product development.
• Lead high-impact initiatives.
• Ensure alignment with organizational goals.
• Provide executive guidance.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior