Enterprise Data Architect

Job Description:

• 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