Austin Aviation IT Data Architect
AI summary of the role
The City of Austin Department of Aviation seeks an IT Data Architect to design, build, and optimize the enterprise data platform supporting reporting, analytics, AI, and business decisions for Austin-Bergstrom International Airport.
What you’ll do
- Design and implement data and analysis infrastructure, including complex databases.
- Build and manage data pipelines that combine core data sources into data warehouses or other accessible structures.
- Create data transformation processes (ETL, SQL stored procedures) to support complex business systems and operational data flows.
- Work closely with Data Analysts and others to develop scalable, production-ready Advanced Analytics and supporting software.
What you’ll bring
- Bachelor's degree in Information Science or related field plus 5 years related experience (Master's may substitute up to 2 years; education/experience may substitute up to 4 years).
- Hands-on experience with Azure Synapse Analytics and Azure Data Factory (ADF) for ETL/ELT development and production deployment.
- Experience designing enterprise dimensional data models (Star Schema) and data warehouses for Power BI analytics.
- Advanced proficiency in T-SQL, SQL performance tuning, stored procedures, and data transformation for large-scale platforms.
Technologies
Azure Synapse Analytics · Azure Data Factory · Power BI · T-SQL · ETL/ELT · Data Lake Storage Gen2 · Star Schema · CI/CD · Python · R · NoSQL · RDBMS
Source and classification
Internal deployment & tooling · Evidence for this classification:
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
More from the 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 t [... source excerpt omitted ...] . 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 [... source excerpt omitted ...] onment. 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
Employer postings · Data from · Sources