Enterprise Data Architect

Posted 1hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Enterprise Data Architect designing Snowflake, ODS, and Kafka data architecture for Vista, a global business aviation company. Defining data models, pipelines, schemas, and governance standards.

Responsibilities:

  • Design and maintain enterprise data models for the Snowflake data warehouse and Operational Data Store (ODS)
  • Own data architecture strategy connecting operational systems, the ODS, and the enterprise data warehouse
  • Design integration and data flows between operational systems, ODS, and warehouse layers
  • Define and document data modeling standards, naming conventions, modeling patterns, and best practices
  • Partner with data engineers to design and review ELT/ETL pipelines using dbt and Airflow
  • Define event payload schemas and data contract standards for Kafka topics
  • Drive data governance practices including metadata management, data lineage, data quality standards, and documentation using tools such as Open Metadata
  • Evaluate new data sources, systems, and integration requirements and design corresponding data models and ingestion patterns
  • Provide design reviews and technical guidance to data engineers, analysts, and application teams
  • Translate business requirements into well-structured, reusable data models supporting enterprise reporting and analytics
  • Work as an individual contributor with no direct reports

Requirements:

  • Bachelor’s degree in Computer Science, Engineering or related discipline required
  • Minimum 8 years of total professional experience in data engineering, database development, or related fields
  • At least 3 years of experience specifically in a data architecture or senior data modeling role
  • Hands-on experience designing and modeling data for both a cloud data warehouse (Snowflake preferred) and a relational operational data store (PostgreSQL/Aurora preferred) required
  • Experience defining event payload schemas and data contracts on a streaming/messaging platform such as Kafka required
  • Aviation industry experience preferred
  • Deep proficiency in SQL, data modeling techniques (dimensional modeling, 3NF, data vault), and ELT/ETL design principles
  • Experience with orchestration tools such as Airflow
  • Working knowledge of PostgreSQL/Aurora and cloud data warehouse platforms (Snowflake preferred), including performance and schema design considerations for both transactional and analytical workloads
  • Ability to define and enforce data architecture standards, modeling best practices, and documentation across warehouse and ODS environments
  • Knowledge of Master Data Management (MDM) principles and metadata management frameworks
  • Strong stakeholder management skills and ability to partner effectively across technical and non-technical teams
  • Excellent communication skills with ability to articulate technical concepts to diverse audiences
  • Detail-oriented with strong commitment to data quality, consistency, and governance across systems
  • Required to verify identity and eligibility to work in the United States and complete the required employment eligibility verification form upon hire

Benefits:

  • Global business aviation company environment
  • Autonomy and responsibility from day one
  • Hands-on learning
  • Close collaboration within a supportive global community