Austin Aviation IT Data Architect

City of Austin; United States; On-site; USD 91,000 - 117,000; Full time

Job summary

City of Austin, through the Department of Aviation at AUS, invites you to join as IT Data Architect. You will design and manage data pipelines, build data and analytics infrastructure across the organization, and support production deployments for analytics stakeholders.

The role emphasizes ETL, data warehousing, cloud platforms (Azure Synapse, ADF), and BI tooling (Power BI). Ideal candidate has 5+ years of experience, Bachelor's in Information Science, and strong collaboration with analysts

Qualifications

• Bachelor’s degree in Information Science or a related field plus five years of relevant experience.
• Master’s degree can substitute for up to two years of experience.
• Experience with ETL/ELT, data warehousing, and data governance is preferred.

Responsibilities

• Assists in building and managing the data pipelines to support business and IT results.
• Designs and implements data and analysis infrastructure, including complex databases.
• Develops tools/services to enable large-scale ML solutions.
• Works with Data Analysts to develop scalable, production-ready analytics and software.
• Maintains data management systems and data pipelines to support reporting and analytics.
• Documents models, solutions, and implementations (e.g., data mapping, specs, test cases).
• Creates data transformation processes (ETL, SQL procedures) to support complex business systems.

Skills

R

Python

Java

C++

C#

Scala

Education

Bachelor’s degree in Information Science or related field

Master's degree may substitute for up to two years

Tools

Azure Synapse Analytics

Azure Data Factory

Power BI

Tableau

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:

• 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:

• 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.

Preferred Qualifications:

1. Hands‑on experience designing and implementing data pipelines using Azure Synapse Analytics and Azure Data Factory (ADF), including ETL/ELT development, orchestration, and production deployment.
2. Experience designing enterprise dimensional data models (Star Schema) and data warehouses to support reusable semantic models and self‑service Power BI analytics.
3. Advanced proficiency in T‑SQL, SQL performance tuning, stored procedures, and data transformation techniques for large‑scale enterprise data platforms.
4. Experience developing enterprise Power BI semantic models, reusable datasets, row‑level security (RLS), and Power BI Apps using Microsoft best practices.
5. Experience implementing Microsoft Azure analytics solutions, including Azure Data Lake Storage Gen2 (ADLS Gen2), Azure Synapse, data governance, CI/CD, and enterprise data integration.

Notes to Candidate:

As an IT Data Architect, you will design, build, and optimize the enterprise data platform that powers reporting, analytics, artificial intelligence, and business decision‑making. You'll develop scalable data pipelines, integrate data from multiple systems, and create modern data architectures such as data warehouses, data lakes, and data hubs. Working closely with business stakeholders, data analysts, engineers, and application teams, you'll ensure data is accurate, secure, accessible, and production‑ready. This role combines technical expertise with strategic thinking, requiring experience in ETL/ELT, SQL, cloud data platforms, data modeling, automation, and modern analytics technologies. Success in this position means transforming complex data into trusted enterprise assets that enable smarter decisions across the organization while following governance, security, and change management best practices.

Salary Range:

$91.080-$117,000.

Travel:

This position requires traveling to multiple sites as part of the regular job duties. A driving record verification will be conducted. If you are selected for this position, and meet the Driver Safety Standards in the City of Austin Driver Safety Program, you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations. Go to the Driver Safety Program for more information at City of Austin Driver Safety Standards.

Skills Assessment:

A skills assessment/s will be required for this position.

Essential Personnel:

This position is categorized as essential personnel. Essential personnel are required to come to work during emergencies or bad weather at the airport if they are scheduled to work and, in some cases, when they are not scheduled.

Veteran:

Veteran candidates will be required to provide a copy of your DD214 at the time of interview.

Criminal History Records Check:

The top candidate will be subject to a minimum 10‑year criminal background check and security threat assessment.

GOOD STANDING – DEPARTMENT/DIVISION EMPLOYEES:

Employees in good standing, who are candidates within the department/division that the position resides in and who meet the minimum and preferred qualifications (if any) of the position will be included in the initial interview. Department/division employees must remain in good standing through the top candidate selection phase at which time the good standing status will be re‑verified.

Language:

Must have the ability to read, write, and fluently speak in English.

Work Hours:

Monday-Friday 8:30 am-5:30 pm. Hours may change according to departmental needs; work hours may include after hours, holidays, and weekend work.

Benefits:

Working with Aviation provides a number of health and welfare benefits see City of Austin Promotional Benefits Overview to learn more. See us in action: Austin-Bergstrom International Airport - AUS - YouTube .

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin, we are more than just an employer—we are a vibrant community dedicated to shaping one of the nation's most dynamic and innovative cities. As we strive to fulfill our commitment as public servants, it is important that we ground our efforts in a set of guiding principles – Empathy, Ethics, Excellence, Engagement, and Equity – that anchor our delivery of services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career, contributing to the community, and being part of a forward‑thinking organization that values every employee.

What Makes the City of Austin Special? Make a Difference: Join a team driving meaningful change in one of the fastest-growing cities in the nation. Value and Innovation: Work in an environment where employees are valued, and innovation thrives. Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave, work-life balance programs, and extensive benefits. Retirement Security: Plan for the future with the City of Austin Employees' Retirement System. Sustainable Transportation Options: Commute easily with access to public transit and bike-friendly infrastructure. Focus on Wellness: Stay healthy through wellness programs, on-site fitness centers, and mental health support. Career Growth: Advance your skills and expertise with professional development and leadership opportunities. Modern Workspaces: Work in innovative and sustainable environments that foster collaboration and inspiration. By joining us, you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country.

EEO Statement for City of Austin:

The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual's AIDS, AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.

Workday Jobs Hub

JOIN THE CITY OF AUSTIN TEAM At the City of Austin, we are more than just an employer—we are a vibrant community dedicated to shaping one of the nation's most dynamic and innovative cities. As we strive to fulfill our commitment as public servants, it is important that we ground our efforts in a set of guiding principles – Empathy, Ethics, Excellence, Engagement, and Equity – anchors in delivering services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career, contributing to the community, and being part of a forward‑thinking organization that values every employee. What Makes the City of Austin Special? Make a Difference: Join a team driving meaningful change in one of the fastest-growing cities in the nation. Value and Innovation : Work in an environment where employees are valued and innovation thrives. Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave, work-life balance programs, and extensive benefits. Retirement Security: Plan for the future with the City of Austin Employees' Retirement System. Sustainable Transportation Options: Commute easily with access to public transit and bike-friendly infrastructure. Focus on Wellness: Stay healthy through wellness programs, on-site fitness centers, and mental health support. Career Growth: Advance your skills and expertise with professional development and leadership opportunities. Modern Workspaces: Work in innovative and sustainable environments that foster collaboration and inspiration. By joining us, you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country. City of Austin Employment Video