Data Warehouse Architect

Welcome to San Diego International Airport, where our core purpose is to create an exceptional experience for both our community and visitors from around the world. It extends beyond just flights; we embody the vibrant spirit of San Diego itself—sunny, welcoming, and full of life. We are committed to attracting, fostering, and empowering a team of talented individuals who can deliver our strategic goals:

• Advance Airport Development
• Transform the Customer Experience
• Optimize Ongoing Business
• Cultivate Our Culture

Here, you’ll find a workplace culture that thrives on diversity and is anchored in our collective mindsets: collaboration, empathy, inclusivity, thoughtful decision-making, active listening, and always believing the best in people. If you are ready to contribute to a team that values meaningful impact and enjoys the journey along the way, we invite you to apply today and help us connect our community to the world.

Why You'll Love Working at SAN:

• Location:  The new Airport Authority Administration building, located on the San Diego International Airport campus and near the waterfront, providing stunning views of our runway, San Diego Bay, the Pacific Ocean, and the city skyline.
• Hybrid Work Schedule: We offer a flexible hybrid schedule, with an opportunity for remote work based on operational requirements, while supporting both in-office collaboration and remote productivity. 
• Salary: The hiring salary for Data Warehouse Architect is at $103,856. The full pay range for Data Warehouse Architect is $88,675-$142,025.
• Benefits: You will enjoy 14 paid holidays, 18 – 33 days of vacation (PTO), parental and child care benefits, salary continuance for family & parental leave, tuition reimbursement, ensure your future with our retirement plan options including our comprehensive pension plan and 457 defined contribution plan. Plus, take advantage of our annual employer-funded Lifestyle Spending Account, designed to support your personal development and growth activities—and much more!
• Wellness: Take advantage of multiple on-site gyms with regular fitness classes, outdoor working areas, fitness discounts for all levels and goals, monthly fruit deliveries, rewards for volunteer time, financial wellness advisors, and a campus with easy access to some of San Diego's best walking trails.
• Application Deadline: March 3, 2025. Applications will be reviewed after the closing date.

About the Job:

The Business Intelligence department is looking for a Data Warehouse Architect with a strategic mindset on designing and optimizing data environments to support the SAN’s business intelligence needs. This role will design and implement an efficient, flexible, and robust data warehouse environment, ensuring it meets the complex needs of airport operations. The ideal candidate will establish data modeling standards, define best practices for data management, and collaborate closely with Data Engineers and Data Analysts to maintain data accuracy and integrity.

This role is unique—small team, big impact. Unlike large Business Intelligence teams, here, your work is visible and strategic. You’ll have the opportunity to build from the ground up, introduce modern cloud solutions, and create a data infrastructure that supports millions of passengers, flights, and airport operations. Your architecture decisions will influence how the airport optimizes everything from passenger flow to financial forecasting.

What You’ll Do:

• Architect & Optimize: Design, develop, and sustain a scalable, adaptable data warehouse infrastructure that enhances data quality, accessibility, and business alignment. Optimize Snowflake for data warehousing and Power BI for reporting, ensuring best practices for ETL/ELT, data ingestion, and metadata management.
• Establish Standards & Security: Define and enforce data warehouse standards to ensure consistency, reliability, and compliance. Implement robust data security measures to meet industry regulations and safeguard sensitive information.
• Collaborate & Lead: Work closely with data engineers, analysts, and stakeholders to refine data collection, transformation, and storage processes, support self-service reporting, and provide technical leadership while fostering a culture of innovation.
• Align Data Solutions with Business Goals: Partner with cross-functional teams to develop solutions that support business objectives and analyze the impact of operational changes on data architecture, ensuring adaptability.
• Monitor & Innovate: Continuously evaluate system performance, recommend infrastructure enhancements, and stay ahead of emerging technologies to maintain a future-proof, high-performing data environment.

The Skills You Need:

1. Technology & Tools – Proficient in cloud-based data warehouses (Snowflake, Databricks, Azure Synapse, AWS Redshift, Google BigQuery), data visualization tools (Tableau, Power BI), and database languages (SQL, relational databases). Strong understanding of data modeling (Kimball vs. Inmon), ETL/ELT processes, and data marts, with additional expertise in big data (Hadoop, Spark) and programming languages (Python, TSQL, C#).
2. Problem Solving & Adaptability – Analyzes complex challenges, develops innovative solutions, and adapts to evolving business needs in a fast-paced environment.
3. Communication & Collaboration – Translates technical data concepts for non-technical stakeholders, aligning business needs with data solutions while fostering cross-team collaboration.
4. Data Governance & Security – Deep expertise in data privacy, security best practices, and governance frameworks to ensure compliance and data integrity.

Requirements

The Experience You Need to Have**:

• Minimum of five years experience in data architecture, data engineering, business intelligence, or a related field, with a strong focus on data warehouse technologies. Proven ability to design, implement, and manage scalable, high-performance data warehouse systems or any equivalent combination of education, training, and/or experience.
• Bachelor’s degree in computer science, information systems, data analytics, or a closely related field.

Preferred Licenses; Certificates; Special Requirements:

• Master’s degree in computer science, information technology, engineering, data analytics or a closely related field.
• Certifications such as SnowPro Core, SnowPro Advanced Architect, AWS Certified Solutions Architect, AWS Certified Big Data, Azure Data Engineer Associate (DP-203), Azure Solutions Architect Expert (AZ-305), Google Cloud Professional Data Engineer, Google Cloud Professional Cloud Architect.
• Familiarity with AI, machine learning, and predictive modeling.
• Experience in aviation or transportation industries appreciated.

**Lacking some of the skills or experiences we've listed? No worries! Here at the San Diego International Airport, we're on a mission to cultivate a workforce as dynamic and diverse as the community we serve. While certain roles may require specific qualifications, we understand that talent comes in many forms. Some of our positions may not require specific degrees, and we're always open to individuals who bring a willingness to learn and a commitment to excellence. If you think this could be you, we encourage you to apply, and even if this position isn't the right role for you, we will add you to our database to consider for other opportunities in the future that align with your unique knowledge and skills. There's a chance we have the perfect spot for you to land!

EEO Statement

It is the policy of the San Diego County Regional Airport Authority to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, SDCRAA will provide reasonable accommodations for qualified individuals with disabilities.

Physical & Mental Demands

Persons with disabilities may be able to perform the essential duties of this class with reasonable accommodation. Reasonable accommodation will be evaluated on an individual basis and depends, in part, on the specific requirements for the job, the limitations related to disability and the ability of the hiring department to accommodate the limitation. If you need any form of accommodation during the recruitment process, please inform the Talent Acquisition Partner (Recruiter).

Under California Government Code Sections 3100 - 3109, public employees are designated disaster service workers. The term "public employees" includes all persons employed by the state or any county, city, state agency, or public district. Disaster service workers are required to participate in such disaster service activities as they may be assigned to them by their employer or law.