Austin Aviation IT Data Architect

austintexas; Austin (TX); On-site; AUD 167,000 - 251,000; Full time

Job summary

Austin-Bergstrom International Airport, owned by the City of Austin and operated by the Department of Aviation, seeks an IT Data Architect to design and manage data pipelines that enable analytics and ML across IT and business units.

You will collaborate with data analysts to build scalable, production-ready data infrastructure, ETL processes, and governance to support reporting and decision-making in a dynamic public-sector environment.

Qualifications

• Bachelor’s degree in Information Science or a related field and 5 years of experience.
• Master’s degree may substitute for up to 2 years of experience.
• Education or experience may substitute up to 4 years.

Responsibilities

• Assist in building and managing data pipelines to support value creation, growth, and delivery of IT results.
• Design and implement the data and analysis infrastructure, including complex databases.
• Assist in developing tools/services for large-scale machine learning solutions.
• Work with Data Analysts and others to develop scalable, production-ready analytics and supporting software.
• Maintain data management systems and data pipelines that combine core data sources into warehouses or other structures for reporting.
• Document models, solutions, and implementations (Data Mapping, Technical Specifications, Data Dictionaries, Test Cases).
• Create ETL processes (SQL stored procedures, etc.) to support complex business systems and data flows.

Skills

Python

SQL

ETL

Data Modeling

Big Data

Education

Bachelor's degree in Information Science

Tools

Tableau

Power BI

KNIME

Alteryx

Job description

About This Position

Owned by the City of Austin and operated by the Department of Aviation, Austin-Bergstrom International Airport is an economic engine, supplying over 74,000 direct and indirect jobs in the Central Texas region. Now, as we build the airport's largest improvement program in its history, we are redefining the travel experience in one of the fastest-growing cities in the United States. This is an exciting opportunity to join the team behind Journey With AUS, the airport's expansion and development program, where bold ideas, cutting-edge infrastructure, and a shared commitment to excellence are taking flight.

Job Description:

IT Data Architect

Purpose:

IT Data Architects build and manage the data pipelines necessary to support value creation, growth, and delivery of IT results through designing and implementing the data and analysis infrastructure. This position optimizes data pipelines and moves data pipelines effectively into production for key data and analytics consumers by working across the City and with IT and other subject matter experts to plan and deliver optimal analytics and data solutions to users.

Duties, Functions and Responsibilities:

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

• Assists in building and managing the data pipelines necessary to support value creation, growth, and delivery of business and IT results.
• Designs and implements the data and analysis infrastructure, including complex databases.
• Assists in developing different technical tools/services to enable large scale machine learning solutions.
• Works closely with Data Analysts, and others to develop scalable and production ready Advanced Analytics and supporting software.
• Assists in building and maintaining data management systems and data pipelines that combine core data sources into data warehouses or other accessible structures to support reporting and analytical systems.
• Documents models, solutions, and implementations (e.g., Data Mapping, Technical Specifications, Production Support, Data Dictionaries, Test Cases, etc.).
• Creates data transformation processes (ETL, SQL stored procedures, etc.) to support moderately complex to complex business systems and operational data flows.

Responsibilities - Supervisor and/or Leadership Exercised:

May provide leadership, work assignments, evaluation, training, and guidance to others.

Knowledge, Skills, and Abilities:

• Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.
• Knowledge of languages such as (R, Pearl, Python, Java, C++, C#, Scala etc.), modern data storage and access technologies, including caching, application of NoSQL, Key/Value, and RDBMS datastores.
• Knowledge of commercial data science platforms (e.g., Python, R, KNIME, Alteryx, etc.).
• Knowledge of Extract-Transform-Load (ETL) processing and Change Data Capture (CDC) technologies.
• Knowledge of big data concepts and frameworks and business intelligence tools (such as Tableau, Qlik, PowerBI) and AI frameworks (Caffe, TensorFlow)
• Knowledge of Data Management architectures like Data Warehouse, Data Lake, Data Hub and the supporting processes like Data Integration, Governance, Metadata Management.
• Knowledge of data pipeline guiding principles, and best practices to build and maintain data pipelines.
• Skill in data storage, data processing, database fundamentals, data orchestration and automation, programming, CI/CD, data validation and testing, version control systems, scripting and coding, cloud migration, metadata management, infrastructure as a code (IAC), data monitoring and observability skills.
• Ability to build, manage and optimize data pipelines that facilitate data movement.
• Ability to reduce manual data work and improve productivity.
• Ability to build robust data operations and to identify critical issues faster in order to debug and troubleshoot quickly.
• Ability to work with and across teams and foster a cooperative and efficient working environment.
• Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
• Ability to turn data insights into recommendations for both clients and internal stakeholders based on context.
• Ability to adhere to required compliance to all change management policies and procedures.
• Ability to adhere to required compliance to all information security policies and procedures.

Minimum Qualifications:

• Graduation with a Bachelor's degree from an accredited college or university with major coursework in Information Science or in a field related to the job, plus five (5) years related experience.
• Masters degree may substitute for experience up to two (2) years.
• Education or experience may substitute up to four (4) years.

Licenses and Certifications Required:

None.