Enterprise Data Architect

Vista

. Design and maintain enterprise data models for the Snowflake data warehouse and Operational Data Store (ODS) .

Posted 10/13/2026full-timeRemote • Ohio • United StatesSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining enterprise data models for Snowflake and operational data stores, with a strong focus on data architecture strategy, data governance, and integration practices. Proficient in SQL, data modeling techniques, and ELT/ETL design principles, ensuring high data quality and effective communication across teams.

Highest-signal resume keywords

Data Architecture StrategySnowflake Data WarehouseSQL ProficiencyELT/ETL Design PrinciplesKafka Event Payload Schemas

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Modeling TechniquesDimensional Modeling3NFData VaultPostgreSQLAuroraData GovernanceMetadata ManagementData Quality StandardsData Integration

Soft Skills

Stakeholder ManagementCommunication SkillsDetail-Oriented

Tools & Technologies

AirflowDbtOpen Metadata

Industry Keywords

Aviation Industry ExperienceMaster Data Management

Tech Stack

Tools & technologies

AirflowCloudETLKafkaPostgresSQLVault

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

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